Jump to: Index | MySQL | Connecting to MySQL This article explains how to connect to the Labyrinth Data Services MySQL server using the command-line MySQL client. If you are having trouble using another client, contact Support and we will be happy to help you. MySQL is a very fast database server that allows you to store information in a structured and easy-to-access format. It is usually used as a backend for PHP or Python scripts running on your hosted webspace. We provide a number of MySQL databases with each hosting plan. To use MySQL, you must first create a database using the Management Interface. The Creating Databases page contains information on how to do this. MySQL access is provided on the standard port 3306. To connect to a MySQL database that you have created, type the following and press enter: mysql -h mysql.labyrinthdata.net.au -u USERNAME --database DATABASE -p where USERNAME is your username, and DATABASE is the name of the database you wish to connect to. For example: mysql -h mysql.labyrinthdata.net.au -u joesmith --database mydatabase -p You will be then prompted for your password; type it in and press enter. A prompt should appear: mysql> You have logged in to the database server and can begin entering queries. For information on how to use the MySQL prompt, have a look at the following tutorials, or the MySQL reference manual:
|
|||||
|
|||||
