Difference between revisions of "MySQL Manager"

Revision as of 12:51, 15 March 2011

Database Manager is a web based MySQL client that allows you to create and manipulate MySQL databases.

Database Manager is best used for creating databases. For populating a database, you should consider using a script(PHP, ColdFusion) or CGI.

You can find more information about MySQL database at: http://www.mysql.com/

Setting your Database Manager password

1. Click "Add User" in order to ad a new user.You will be prompted with a pop-up to set-up your password.

2. Enter a password in the "Password" textbox .

3. Enter it again into the “Confirm password” textbox.

4. Select a database type from the drop down menu. There are 2 choices available: MySQL4 and MySQL5.

5. Click the "Accept" button to save the changes.

     Click "Cancel" to dismiss the changes made.

Note that this password is only for database administration.

Click the "Databases" tab to start using Database Manager. You will be prompted to enter this password in order to log into Database Manager. Enter your Database Manager password in the "Enter Password" textbox and click the "Login" button to complete the operation.

Changing your Database Manager password

To change your Database Manager password at any time, under the "Users" section click on the blue icon besides a user. You will be prompted to enter a new password.

1. Enter your new password in the "New Password" textbox.

2. Enter your new password one more time in the "Confirm new password" textbox.

3. ” Click “Accept” to save the changes.

     Click "Cancel" to dismiss any changes.

Creating a database

1.To create a database, under the Databases section click "Add Database". 

2.Enter the name of the database you want to create.

3.Click the "Accept" button to save the changes.

    Click "Cancel" to dismiss any changes.

Your user name is appended to the end of every database name. The Total maximum length is 64 characters long and any "." (dot) or "-" (dash) in the database name is automatically converted to "_" (underscore).

For example if you choose "customers" as your database name and your domain is mycar.com, the complete database name will be:

customers_mycar_com

Deleting a database

1.Click on the red icon beside the database you wish to delete.

2.Click "Yes" when prompted to confirm deletion of the chosen database.

3.Click "No" if you do not want to delete the chosen database.

Connecting to your database

In order to connect to the database you have created, you need the following arguments to include in your application/script:

Database user name: [first 10 characters of domain name] + [random 6-digit number]

example: if the domain name was "bob.the-mechanic.com", then the databse username would be something like bobthemech386296. Note that all non-alpha characters were removed ("." and "-").

Password: The password will be the same as your Database Manager password.

Database name: It will be the complete name of database as outlined in Creating a database.

Please contact technical support for your MySQL server name (host name).