MySQL


MySQL is a true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular and standardized database language in the world. MySQL is a client/server implementation that consists of a server daemonmysqld and many different client programs and libraries.

*/day'mn/ or /dee'mn/ (From the mythological meaning, later rationalized as the acronym "Disk And Execution MONitor") A program that is not invoked explicitly, but lies dormant waiting for some condition(s) to occur.)

  1. Start the MySQL Manager program. Click Tools>Register Server. A screen similar to the one shown below should open:

  2.  

  3. If you will be using the ValueWeb SQL server, for both Server and Host, enter ida.valueweb.net.

  4. For Login ID enter your username and password for the SQL server.

  5. If you will be using the CyberGate SQL server, for both Server and Host, enter sql.yourdomain.com.

  6. For Login ID enter your username and password for the SQL server.

  7. Note: Be sure to use your username and password for the SQL server. This will likely be different than your username and password for other services. (i.e. control panel, ftp, etc.)

  8. Click Register. You should now have a folder labeled as ida.valueweb.net or sql.theirdomain.com. Right Click the new folder and click SQL query. A screen similar to the one below should open.

  9. To check to see if your database resides on the SQL server, click the gold icon at the top. This will list all the SQL databases on the server. Look for one with your username. In this case we are using the database named "haf".

  10. Click the Query tab at the top. As shown in the above screen shot, type "use haf" (no quotes)

  11. Click the green arrow near the top of the window. This should tell the SQL server that you want to use the database called "haf". If everything worked OK, you should be looking at a blank results window.

  12. Click the Query tab at the top. Erase the entry for "use haf" from the Query screen. Type "show tables".

  13. Click the green arrow. A window similar to the one shown below should open.

  14. This will show us that the database "haf" has two tables in it.

  15. To see what a table has in it, click the Query tab at the top. Erase what is showing and type "describe (table name)". In this case, we would type describe Members. Click the green arrow at the top. You should see a window similar to the one shown below.

  16. This gives us information about the columns used in the table "Members".

     

    This concludes the basics about MySQL. You should now be able to:

    Start the SQL program

    Log into the ValueWeb / CyberGate SQL server

    Tell the SQL server which database you wish to use

    Show the tables in the database you logged into

    Show the column rules(describe) in the database you logged into

    This is the scope of support for MySQL offered by Nethelper.   For additional help, please visit www.mysql.com.





HOME >Homepage Setup >FAQ >Feedback

>OS >Windows 3.1 >Windows 95 >Windows 98 >Windows NT >Macintosh

>SUPPORT >FTP Support >E-mail Support >Modem Support