MySQL Manager - Revision history

Sbabin at 21:58, 26 September 2016

2016-09-26T21:58:55Z

WikiSysop at 21:36, 4 November 2011

2011-11-04T21:36:30Z

WikiSysop: Created page with '
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…'

2011-03-15T17:51:38Z

Created page with ' 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…'

New page

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

 

[[Category:Setup]]

@@ Line 1: / Line 1: @@
-== Overview  ==
+=Introduction=
-Database Manager is a web based MySQL client that allows you to create and manipulate MySQL databases.
+==Creating Database Users==
-Database Manager is used for creating databases. For populating a database, you should consider using a script(PHP, ColdFusion) or CGI.
+TO CREATE A DATABASE USER:
-You can find more information about MySQL database at: http://www.mysql.com/
+==Managing Users==
-== Adding a Database User  ==
+TO MANAGE PRIVILEGES FOR AN EXISTING USER:
-<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>
+TO CHANGE A USER’S PASSWORD:
-#<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>
+TO DELETE USER ACCESS:
-#<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>
+#Click the Settings  icon and select '''Delete User'''.
-#<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>
+#In the Delete User dialog, click '''Yes'''.
-== Creating a New Database  ==
+=Database Management=
-To create a new database:
+TO CREATE A NEW DATABASE:
-#In the Users and Databases list, click the user name for which you want to create a new database.
+==Managing Your Database==
-#In the Login Settings section, enter your password and click '''Login'''.
+MySQL Manager has integrated a connection to phpMyAdmin to help you use and manage your SQL server. Once you have created your user and database, your manage database function will open phpMyAdmin in separate window.
-#In the MySQL Commands section, click '''Create'''.
+'''Note''': Before opening your server in phpMyAdmin, we will:
-#Click '''Database'''.
+*Check to see if phpMyAdmin has been installed.
-#Enter a database name.
+*If phpMyadmin is not found, it will automatically install the software in a /public/phpmyadmin directory.
-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).
+TO MANAGE A DATABASE:
-&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:
+TO DELETE A DATABASE:
 [[Category:Setup]]

@@ 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.
 You can find more information about MySQL database at: http://www.mysql.com/
-<br> '''Setting your Database Manager password'''
+== Adding a Database User  ==
-. ” 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>
-<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:
-.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'''.
-.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.
 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 on the red icon beside the database you wish to delete.
+== Managing your Database  ==
-.Click "Yes" when prompted to confirm deletion of the chosen database.
+To change&nbsp;your password:
-.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.
-<br>
+'''Note''' that this password is only for database administration.
-<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:
 <br>
 [[Category:Setup]]

MySQL Manager - Revision history

Sbabin at 21:58, 26 September 2016

WikiSysop at 21:36, 4 November 2011

WikiSysop: Created page with ' 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…'

WikiSysop: Created page with '
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…'