Questions:
  1. What is the BASIC CONFIG for my MySQL DB ?
  2. I am not sure if MySQL is operating properly on my account. Do You have a TEST PROGRAM to see if it is running?
  3. Connecting to MySQL with PHP
  4. My database manager informed me that I must be able to access my MySQL database through Telnet. As a result, I purchased the SSH upgrade because you do not support regular Telnet. However, once connected, the "mysql" COMMAND is not found. I would rather not use the control panel SQL database manager. Instead I would like to manage it through SSH. The command I am using in its is: mysql
  5. I am trying to access our MySql Database through the control panel, and it keeps coming up and asking for a username and password... I don't know it.. I didn't know I assigned it one?
  6. Is MySql database compatible with FrontPage?
  7. The password for the MySQL directory (accessed from the web control panel) no longer conforms to the password I've set for the panel. It has reverted to the original password I was assigned when I applied for my hosting. I've tried using the change password interface to change everything back to the password I chose, but even after waiting more than the 10 minutes required this did not seem to fix anything.
  8. Do you set the MySQL db up with name and password etc for me, then I can create tables.
  9. How do I change the PASSWORD of my MySQL database?
  10. How do I change the NAME of my MySQL database?
  11. Can I have more than ONE database with my account?
  12. Do we allow you to access your MySQL db remotely (instead of from localhost)?
  13. Where is the location of the MySQL Manual?
  14. HELP! None of this makes any sense to me... What should I do?
  15. What are the Advantages of MySQL and PHP over ASPs?
  16. What is the MySQL Debug command?
  17. How do I work with a MySQL database using PHP?
  18. Since you don't offer direct techincal support for MySQL, where can I go to get the info I need?
  19. Do you support MySql?
Answers:
  1. What is the BASIC CONFIG for my MySQL DB?
    $hostname = "localhost"; /* MUST ALWAYS be localhost */
    $username = "username"; /* This will be the username you used to login to your control panel when you installed MySQL */
    $password = "password"; /* This will be the PassWord you used to login to your control panel when you installed MySQL */
    $userstable = "table"; /* You will have had to CREATE a table and you will have named it something*/
    $dbName = "something_com"; /* You will be given this when you login to your control panel and click on the MySQL button*/
  2. I am not sure if MySQL is operating properly on my account. Do You have a TEST PROGRAM to see if it is running?
    Yes.
    Simply follow these steps to test your MySQL:

    Step 1:
    create a file called test.phtml and place it in your main web directory. So, you would access the file like this:
    http://yourdomain.com/test.phtml

    PLACE THE CODE LOCATED HERE IN test.phtml
    YOU WILL NEED TO EDIT A FEW THINGS AT THE TOP OF THE FILE, INSTRUCTIONS ARE INCLUDED.

    NEXT, Login to your Online Control Panel, and CLICK ON THE MySQL BUTTON.
    In the Left Hand Side Menu, CLICK ON your DataBase Name.

    At the bottom of the page, you will see the following:
    Create new table on database DATABASE_NAME:
    In the NAME box, type: info
    In the Fields box, type: 3
    CLICK the Go Button.

    For the first Field, type in name and change the TYPE to VARCHAR
    In the Length/Set Box TYPE: 10
    In the Default Box TYPE: 0
    Thats it for that field.

    For the NEXT Field, type in email and change the TYPE to VARCHAR
    In the Length/Set Box TYPE: 10
    In the Default Box TYPE: 0
    Thats it for that field.

    For the NEXT Field, type in preference and change the TYPE to VARCHAR
    In the Length/Set Box TYPE: 10
    In the Default Box TYPE: 0
    Thats it for that field.

    CLICK on the SAVE button.

    NOW, go back to your webpage called:
    http://yourdomain.com/test.phtml

    and REFRESH the page.

    NOW, go back to your Online Control Panel, and CLICK on your DataBase name again.
    YOU SHOULD NOW SEE, your table name and there should now be 1 Record.
    CLICK on Browse
    You should now see the FILES in your DB.
    There should be at least ONE ENTRY for each RECORD.

    THAT'S IT!
    IF THERE IS DATA in the DB, then IT IS WORKING 100% :)
  3. Connecting to MySQL with PHP
    How do I work with a MySQL database using PHP?

    1.To merely display the information in your database without the use of a form to call a php script you simply create your HTML document as you would any other web page but instead of the extension of .htm or .html you need to name the file with the extension .phtml. Then within the document itself the section that you'd like to be the PHP code, you begin it with <? and end it with ?>. For instance:

    <P>These are the products I sell:</P>

    <TABLE BORDER="1">

    <?
    mysql_connect(localhost, username, password);
    $result = mysql(mydatabase, "select * from products");
    $num = mysql_numrows($result);
    $i = 0;

    while($i < $num) {
    echo "<TR>n";
    echo "<TD>n";
    echo mysql_result($result,$i,"prodid");
    echo "</TD>n<TD>";
    echo mysql_result($result,$i,"name");
    echo "</TD>n<TD>";
    echo mysql_result($result,$i,"price");
    echo "</TD>n";
    echo "</TR>n";
    $i++;}
    ?>
    </TABLE>

    Thus having the loop in the php program create a table with the products listed. NOTE your username and password for the database are not written in the file when it's displayed on the Internet so users viewing the source of your webpage will not see your password.

    2.When using a CGI script to pull information from a form which has been submitted by a browser you must have the first line of the script have this command on it (Much like perl scripts):

    #!/usr/local/bin/php
  4. My database manager informed me that I must be able to access my MySQL database through Telnet. As a result, I purchased the SSH upgrade because you do not support regular Telnet. However, once connected, the "mysql" COMMAND is not found. I would rather not use the control panel SQL database manager. Instead I would like to manage it through SSH. The command I am using in its is: mysql
    Use this:
    /usr/local/mysql/bin/mysql

  5. I am trying to access our MySql Database through the control panel, and it keeps coming up and asking for a username and password... I don't know it.. I didn't know I assigned it one?
    Yes, it is the Username and Password of the control panel AT THE TIME YOU INSTALLED THE MySQL db.
  6. Is MySql database compatible with FrontPage?
    No, it is not :)
  7. The password for the MySQL directory (accessed from the web control panel) no longer conforms to the password I've set for the panel. It has reverted to the original password I was assigned when I applied for my hosting. I've tried using the change password interface to change everything back to the password I chose, but even after waiting more than the 10 minutes required this did not seem to fix anything.
    Right, your Mysql Password is SET at the time you INSTALL it, and does NOT change when you change your CONTROL panel password.
    THE ONLY way to get that password changed is to remove Mysql and reinstall it at the time, you have your desired password set.

    OTHERWISE, you can purchase time to talk with a tech support tech, and them to change it for you, as this is not a service that we provide.
  8. Do you set the MySQL db up with name and password etc for me, then I can create tables.
    Yes, when you login to your control panel, and click MySQL, you are then prompted to create your db. It will use the same Password as your online control panel.
  9. How do I change the PASSWORD of my MySQL database?
    We do not provide this as a basic service.
    You may request this from a PAID TELEPHONE TECH SUPPORT ONLY.
  10. How do I change the NAME of my MySQL database?
    We do not provide this as a basic service.
    You may request this from a PAID TELEPHONE TECH SUPPORT ONLY.
  11. Can I have more than ONE database with my account?
    No, we only allow one database per account.
  12. Do we allow you to access your MySQL db remotely (instead of from localhost)?
    No, we do not.
  13. Where is the location of the MySQL Manual?
    For detailed information regarding MySQL, you can go to the MySQL Online Manual:

    http://www.mysql.com/Manual/manual_toc.html

  14. HELP! None of this makes any sense to me... What should I do?
    FIRST, if NONE of the following makes any sense to you... you should NOT be using MySQL. It is a VERY ADVANCED feature, and if you are not an experienced programmer, then we suggest that you get one first.

    Again, we STRONGLY suggest that you find an experienced MySQL programmer when attempting to work with MySQL.
  15. What are the Advantages of MySQL and PHP over ASPs?
    Here are some of the reasons to switch:

    1). UNIX is more reliable. Here are some articles backing this up.

    UNIX vs. NT 4.0 Service Pack 3 from an experienced user:
    http://www.zdnet.com/sr/columns/sjvn/980528.html

    UNIX vs. NT 5.0 with detailed comparison:
    http://www.zdnet.com/zdnn/content/inwk/0513/305389.html

    2). MySQL is a very fast Database System. This page will allow someone to compare MySQL with a bunch of other database systems.
    http://www.mysql.com/benchmark.html

    3). MySQL is very functional. This page allows comparisons of the different functions between MySQL and other Database Systems.
    http://www.mysql.com/crash-me-choose.htmy

    4). PHP 3.0 is designed to be fast and was written to do database work. PHP 3.0 is a server side HTML embeded scripting language, meaning that PHP is embeded in the HTML files and the server does the work of translating the PHP 3.0. This means that it is totally platform and browser independent (it is possible to make things platform and browser independent with Microsoft ASP (Active Server Pages) having the server do all the compiling but if someone brings this up, revert back to the UNIX reliability and Database speed, ASP is not quicker than PHP 3.0 but I don't have any bench marks on this). Let people know it is reliable and fast. They can look here for information on PHP 3.0 here:
    http://www.php.net
  16. What is the MySQL Debug command?
    printf("MYSQL DEBUG: %s %s: \n", mysql_errno(), mysql_error());
  17. How do I work with a MySQL database using PHP?
    FIRST, if NONE of the following makes any sense to you... you should NOT be using MySQL. It is a VERY ADVANCED feature, and if you are not an experienced programmer, then we suggest that you get one first.

    1.To merely display the information in your database without the use of a form to call a php script you simply create your HTML document as you would any other web page but instead of the extension of .htm or .html you need to name the file with the extension .phtml. Then within the document itself the section that you'd like to be the PHP code, you begin it with . For instance:

    These are the products I sell:

    mysql_connect(localhost, username, password);
    $result = mysql(mydatabase, "select * from products");

    $num = mysql_numrows($result);

    $i = 0;

    while($i < $num) {
    echo "\n";
    echo "\n";
    echo mysql_result($result,$i,"prodid");
    echo "\n ";
    echo mysql_result($result,$i,"name");
    echo "\n ";
    echo mysql_result($result,$i,"price");
    echo "\n";
    echo "\n";
    $i++;}
    ?>

    Thus having the loop in the php program create a table with the products listed. NOTE your username and password for the database are not written in the file when it's displayed on the Internet so users viewing the source of your webpage will not see your password.

    2. When using a CGI script to pull information from a form which has been submitted by a browser you must have the first line of the script have this command on it (Much like perl scripts):

    #!/usr/local/bin/php
  18. Since you don't offer direct techincal support for MySQL, where can I go to get the info I need?
    For detailed information regarding MySQL, you can go to the MySQL Online Manual:

    http://www.mysql.com/Manual/manual_toc.html

    Again, we STRONGLY suggest that you find an experienced MySQL programmer when attempting to work with MySQL.
  19. Do you support MySql?
    Yes, we do "support" it. Meaning that we offer MySQL as a standard feature on the webservers. BUT, we do NOT provide ANY technical support on it.
   

 

 

 

 

Google