Hosting FAQs
  • F.A.Q: MYSQL Support

    Common questions on using the MYSQL database system.

    1. Where can I find basic information about mySQL?
    2. How do I connect to mySQL using mySQLPerl Module?
    3. Can I use JDBC with MySQL/MSQL?
    4. How many databases can I create?
    5. How do I connect to mySQL through PHP?
    6. What's the telnet command to activate msql?
    7. What's the telnet commands to access mySQL?
    1. Where can I find basic information about mySQL? - Top

    For SQL, you'll probably be using mySQL.
    The best place to start is at the source

    http://mysql
    http://mysql.com/Manual_chapter/manual_toc.html
    http://mysql.com/information/links.html - Updated: March 23, 2000
    2. How do I connect to mySQL using mySQLPerl Module? - Top

    Use the following outline to connect and begin querying the mySQL server from a Perl script. Remember that you cannot connect to your databases remotely due to security concerns, you can only connect from localhost.

    1. Declarations
    You must require the mySQL package for your script to function properly. Do this by including the following line in your code: use Mysql;

    2. Connect To The Database
    Somewhere near the beginning of your script, you need to make your initial connection to the database server. Using the following form, substitute your database, username, and password for the examples to connect succesfully.
    Mysql->connect('localhost','DATABASENAME','USERNAME','USERPASSWORD');

    3. Executing A Query
    You are now ready to begin querying the database server. Most problems that you may incur will generally occur due to invalid permission settings for the specified user.

    - Updated: March 23, 2000
    3. Can I use JDBC with MySQL/MSQL? - Top

    At this time we donot support JDBC.

    - Updated: March 23, 2000
    4. How many databases can I create? - Top

    We allow 4 individual databases to be created using your WebControl System.

    - Updated: March 23, 2000
    5. How do I connect to mySQL through PHP? - Top

    Use the following outline to connect and begin querying the mySQL server from within your PHP scripts. Remember that you cannot connect to your databases remotely due to security reasons. You can only connect to them form localhost.

    1. Connect To The mySQL Server
    Use the following statement to connect to the database server. Substitute the username, and password for ones who have created in the WebControl System.

    MYSQL_CONNECT('localhost','USERNAME','PASSWORD');

    2. Select Your Database
    Use the following statement to select the database you wish to connect to. Make sure you substitute the example with your database name.
    @mysql_select_db("DATABASENAME");

    3. Executing A Query
    You are now ready to execute your queries. Most problems that arise with your scripts will be due to incorrect permission settings.

    - Updated: March 23, 2000
    6. What's the telnet command to activate msql? - Top

    msql dbname

    - Updated: March 23, 2000
    7. What's the telnet commands to access mySQL? - Top

    Use the following outline to connect and begin querying the mySQL server from a Telnet. Remember that you cannot connect to your databases remotely due to security concerns, you can only connect from localhost.

    1. Connect To The mySQL Server
    servername:/> mysql -u USERNAME -p
    Enter Password: PASSWORD

    2. Connect To The Database
    mysql> use DATABASENAME;

    3. Receving Help
    mysql> help

    - Updated: March 23, 2000

    [e-Mail me the FAQs]  -   [Search our FAQs]  -   [Question Not Answered?]