MySQL Server FAQ

What is MySQL?
MySQL is a free, open-source, professional quality database system similar to Microsoft SQL Server and Oracle. MySQL is a more powerful alternative to Microsoft Access databases, but without the expensive costs of other database servers.
What are the details of the MySQL Server?
The MySQL server is version 3.23.58. It runs on the server using the standard port.
How do I obtain a MySQL account for my organization?
If you are not on a Gold plan or higher, you must request a MySQL account from PShift. To do so, just give us a call.
How do I use my MySQL account?
To manage your database, we recommend the freely-downloaded MySQL Control Center. You may use your MySQL account's information to login to the server. The tool allows you to view, create, edit, and delete tables and data within your database.
I am familiar with MySQL, can I obtain shell access to the MySQL server?
Yes, you can. Shell access to the server is possible by connecting to the server via SSH.
So I have a MySQL account, how do I put it to use in my webpages?
Many web scripting languages (such as PHP and PERL) can use MySQL databases. PHP is the most popular scripting language to use with MySQL, and many good tutorials exist on the web. To get started with PHP and MySQL, you might try the following:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
http://www.freewebmasterhelp.com/tutorials/phpmysql/1
Can I use my MySQL account with downloaded web applications?
Yes. Many popular web applications, ranging from portals to bulletin boards to photo galleries to production management tools exist that use MySQL databases. Many of these applications can be found with a simple web search, and there are two large repositories of open source applications:
http://www.sourceforge.net
http://www.freshmeat.net