MySQL databases

Creating MySQL databases

MySQL databases are created using AMS Control Panel. For complete steps, read Data access.

Managing your data

To connect to and manage your databases, you can do any of the following.

• Use a MySQL front-end application on your computer.
  There are many third-party applications you can install on your computer to manage your databases. You can find them by doing a web search for "mysql front-end". Here are a few popular ones:

  • SQLyog
  • Navicat
  • MySQL Maestro
• Use a web-based MySQL front-end such as phpMyAdmin.
  You can install this web-based interface in a folder on your website, allowing you to manage your databases from any web browser. Be sure to password-protect the folder to prevent unauthorized access.
• Use the interactive command-line client.
  If your website is hosted on Unix, you can use the interactive MySQL command-line client. To connect, log in to the Unix shell and issue the following command:
  mysql -p -u username databasename

  Replace "username" and "databasename" with your own database user name and database name. You'll be prompted to enter your database password. You can then issue standard SQL queries.

• Use database software like Microsoft Access and connect through ODBC.
  If you want to use database software such as Microsoft Access to link to your MySQL data, download the MySQL ODBC drivers and install them on your computer. The MySQL website provides a list of frequently asked questions to guide you through connecting with Access.