Difference between revisions of "MySQL Manager"

From Help
Jump to: navigation, search
(Created page with '<br> 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…')
 
Line 1: Line 1:
−
<br> Database Manager is a web based MySQL client that allows you to create and manipulate MySQL databases.
+
== Overview  ==
  
−
Database Manager is best used for creating databases. For populating a database, you should consider using a script(PHP, ColdFusion) or CGI.  
+
Database Manager is a web based MySQL client that allows you to create and manipulate MySQL databases.
 +
 
 +
Database Manager is 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/  
 
You can find more information about MySQL database at: http://www.mysql.com/  
  
−
<br> '''Setting your Database Manager password'''
+
== Adding a Database User ==
−
 
 
−
<br> 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.
 
−
 
 
−
&nbsp;&nbsp;&nbsp;&nbsp; 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.
 
−
 
 
−
<br>
 
−
 
 
−
'''Changing your Database Manager password'''
 
−
 
 
−
<br> 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.
+
<span style="color: black; font-size: 10pt; mso-fareast-font-family: 'times new roman'; mso-bidi-font-family: arial; mso-ansi-language: en-ca; mso-fareast-language: en-ca">To add a database user:</span>
  
−
&nbsp;&nbsp;&nbsp;&nbsp; Click "Cancel" to dismiss any changes.  
+
#<span style="color: black; font-size: 10pt; mso-fareast-font-family: 'times new roman'; mso-bidi-font-family: arial; mso-ansi-language: en-ca; mso-fareast-language: en-ca">In the Users and Databases list, click '''Add Database User'''.</span>
 +
#<span style="color: black; font-size: 10pt; mso-fareast-font-family: 'times new roman'; mso-bidi-font-family: arial; mso-ansi-language: en-ca; mso-fareast-language: en-ca">In the Add New Database Username dialog, enter the password for the new user name.</span>
 +
#<span style="color: black; font-size: 10pt; mso-fareast-font-family: 'times new roman'; mso-bidi-font-family: arial; mso-ansi-language: en-ca; mso-fareast-language: en-ca">Click '''Apply'''.</span>
 +
#Click '''Close'''.
  
−
<br> '''Creating a database'''
+
== Creating a New Database  ==
  
−
<br> 1.To create a database, under the Databases section click "Add Database".&nbsp;
+
To create a new database:
  
−
2.Enter the name of the database you want to create.  
+
#In the Users and Databases list, click the user name for which you want to create a new database.  
−
 
+
#In the Login Settings section, enter your password and click '''Login'''.
−
3.Click the "Accept" button to save the changes.<br>  
+
#In the MySQL Commands section, click '''Create'''.  
−
 
+
#Click '''Database'''.
−
&nbsp;&nbsp;&nbsp; Click "Cancel" to dismiss any changes.  
+
#Enter a database name.
 +
#Click '''Build Query'''.
 +
#Click '''Run Query'''.<br>A dialog opens, displaying a list of pirvileges granted to the new database.
  
 
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).  
 
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:  
+
&nbsp;&nbsp;&nbsp;&nbsp; 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  
+
&nbsp;&nbsp; customers_mycar_com  
  
−
<br>  
+
== Deleting a Database<br> ==
  
−
'''Deleting a database'''
+
To delete a database:
  
−
<br>
+
#In the Users and Databases list,click the&nbsp;red icon beside the database you want to delete.
 +
#Click '''Apply'''.&nbsp;
 +
#Click '''Cancel '''if you do not want to delete the selected database.
  
−
1.Click on the red icon beside the database you wish to delete.
+
== Managing your Database  ==
  
−
2.Click "Yes" when prompted to confirm deletion of the chosen database.
+
To change&nbsp;your password:
  
−
3.Click "No" if you do not want to delete the chosen database.  
+
#In the Users and Databases list,click the&nbsp;user name of the database for which you want to change the password.  
 +
#Select the '''Yes, I want to change the password for the selected user '''checkbox.
 +
#Enter a new password.
 +
#Confirm the new password.
 +
#Click '''Apply'''.
  
−
<br>
+
'''Note''' that this password is only for database administration.  
−
 
 
−
'''Connecting to your database'''  
 
−
 
 
−
<br> 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 "-").  
 
  
−
<br> ''Password:'' The password will be the same as your Database Manager password.
+
<br>
  
−
<br> ''Database name:'' It will be the complete name of database as outlined in Creating a database.
+
To connect to your database:
  
−
Please contact technical support for your MySQL server name (host name).  
+
*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).
  
−
<br>  
+
<br>
  
 
[[Category:Setup]]
 
[[Category:Setup]]

Revision as of 16:36, 4 November 2011

Overview

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

Database Manager is 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/

Adding a Database User

To add a database user:

  1. In the Users and Databases list, click Add Database User.
  2. In the Add New Database Username dialog, enter the password for the new user name.
  3. Click Apply.
  4. Click Close.

Creating a New Database

To create a new database:

  1. In the Users and Databases list, click the user name for which you want to create a new database.
  2. In the Login Settings section, enter your password and click Login.
  3. In the MySQL Commands section, click Create.
  4. Click Database.
  5. Enter a database name.
  6. Click Build Query.
  7. Click Run Query.
    A dialog opens, displaying a list of pirvileges granted to the new database.

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

To delete a database:

  1. In the Users and Databases list,click the red icon beside the database you want to delete.
  2. Click Apply. 
  3. Click Cancel if you do not want to delete the selected database.

Managing your Database

To change your password:

  1. In the Users and Databases list,click the user name of the database for which you want to change the password.
  2. Select the Yes, I want to change the password for the selected user checkbox.
  3. Enter a new password.
  4. Confirm the new password.
  5. Click Apply.

Note that this password is only for database administration.


To connect to your database:

  • 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).


Retrieved from "http://websupportwiki.com/en/index.php?title=MySQL_Manager&oldid=579"