Difference between revisions of "MySQL Manager"

From Help
Jump to: navigation, search
 
Line 1: Line 1:
−
== Overview ==
+
=Introduction=
 +
MySQL Manager allows you to manage the imports and exports for existing Microsoft SQL Server databases. With MySQL Manager, you ca do the following:
 +
*Create/manage MySQL users
 +
*Create/manage MySQL databases
 +
*View details about their databases such as database usage (how many are included/used)
 +
   
 +
=User Management=
  
−
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:
 +
#Click '''Users'''.
 +
#Click '''Add User'''.
 +
#In the Add New User dialog, enter a password for the new user and click '''Next'''. The username will be automatically generated when the user is created. '''Note''': The password mist contain at least 8 characters, including 1 letter and 1 number.
 +
#In the Add User to Database dialog, do one of the following:
 +
#*Select an existing database from the drop-down.
 +
#*Add a new database by entering its name in the Create new database field.
 +
#Click '''Submit'''. A confirmation dialog will display the new user’s username.
  
−
You can find more information about MySQL database at: http://www.mysql.com/
+
==Managing Users==
 +
MySQL Manager allows you to manage user settings from the User dashboard. In the right-hand column, a settings icon provides options to assign users to databases, manage permissions, change their password or delete user access.
 +
This section provides instructions to complete the following tasks:
 +
*Add a new user
 +
*Manage Privileges
 +
*Change a User’s Password
 +
*Delete User Access
 +
 +
TO ADD A USER TO AN EXISTING DATABASE:
 +
#Click the Settings  icon and select Add to Database.
 +
#In the Add to Database dialog, select an existing database from the drop-down and click '''Yes'''. A confirmation dialog displays the successful database assignment.
  
−
== Adding a Database User  ==
+
TO MANAGE PRIVILEGES FOR AN EXISTING USER:
 +
#Click the '''Settings''' icon and select Manage Privileges.
 +
#In the Manage Privileges dialog, select an existing database from the drop-down and modify any of the following privileges:
 +
#*Create Temporary Table
 +
#*Lock Tables
 +
#*Create View
 +
#*Show View
 +
#*Select
 +
#*Insert
 +
#*Update
 +
#*Delete
 +
#*Create
 +
#*Drop
 +
#*Index
 +
#*Alter
 +
#Click '''Save'''.
  
−
<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:
 +
#Click the '''Settings''' icon and select Change Password.
 +
#In the Change Password dialog, complete the following:
 +
#*Enter a new password
 +
#*Enter the password in confirm password field. '''Note''': The password mist contain at least 8 characters, including 1 letter and 1 number.
 +
#Click '''Yes'''.
  
−
#<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'''.
−
#Click '''Close'''.
 
  
−
== Creating a New Database  ==
+
=Database Management=
 +
==Creating Databases==
  
−
To create a new database:
+
TO CREATE A NEW DATABASE:
 +
#Click '''Databases'''.
 +
#In the Add New Database dialog, enter a name for the database and click Next.
 +
#In the Add User to New Database dialog, do one of the following:
 +
#*Select an existing User from the drop-down.
 +
#*Enter a password to create a new user.
 +
#Click '''Submit'''.
  
−
#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.  
−
#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).  
+
TO MANAGE A DATABASE:
 +
#Click the '''Settings''' icon and select Manage Database.
 +
#Manage SQL server through phpMyAdmin.
 +
 +
TO RESTORE A DATABASE:
 +
#Click the '''Settings''' icon and select Restore Database.
 +
#In the Restore dialog, do the following:
 +
#*Select a time period from the drop-down.
 +
#*Select a target database from the drop-down.
 +
#Click '''Yes'''.
  
−
&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:
 +
#Click the '''Settings''' icon and select '''Delete Database'''.
 +
#In the Delete Database dialog, click '''Yes'''.
  
−
&nbsp;&nbsp; customers_mycar_com
 
  
−
== Deleting a Database<br> ==
 
−
 
−
To delete a database:
 
−
 
−
#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.
 
−
 
−
== Managing your Database  ==
 
−
 
−
To change&nbsp;your password:
 
−
 
−
#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'''.
 
−
 
−
'''Note''' that this password is only for database administration.
 
−
 
−
<br>
 
−
 
−
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).
 
−
 
−
<br>
 
  
 
[[Category:Setup]]
 
[[Category:Setup]]

Latest revision as of 16:58, 26 September 2016

Introduction

MySQL Manager allows you to manage the imports and exports for existing Microsoft SQL Server databases. With MySQL Manager, you ca do the following:

  • Create/manage MySQL users
  • Create/manage MySQL databases
  • View details about their databases such as database usage (how many are included/used)

User Management

Creating Database Users

TO CREATE A DATABASE USER:

  1. Click Users.
  2. Click Add User.
  3. In the Add New User dialog, enter a password for the new user and click Next. The username will be automatically generated when the user is created. Note: The password mist contain at least 8 characters, including 1 letter and 1 number.
  4. In the Add User to Database dialog, do one of the following:
    • Select an existing database from the drop-down.
    • Add a new database by entering its name in the Create new database field.
  5. Click Submit. A confirmation dialog will display the new user’s username.

Managing Users

MySQL Manager allows you to manage user settings from the User dashboard. In the right-hand column, a settings icon provides options to assign users to databases, manage permissions, change their password or delete user access. This section provides instructions to complete the following tasks:

  • Add a new user
  • Manage Privileges
  • Change a User’s Password
  • Delete User Access

TO ADD A USER TO AN EXISTING DATABASE:

  1. Click the Settings icon and select Add to Database.
  2. In the Add to Database dialog, select an existing database from the drop-down and click Yes. A confirmation dialog displays the successful database assignment.

TO MANAGE PRIVILEGES FOR AN EXISTING USER:

  1. Click the Settings icon and select Manage Privileges.
  2. In the Manage Privileges dialog, select an existing database from the drop-down and modify any of the following privileges:
    • Create Temporary Table
    • Lock Tables
    • Create View
    • Show View
    • Select
    • Insert
    • Update
    • Delete
    • Create
    • Drop
    • Index
    • Alter
  3. Click Save.

TO CHANGE A USER’S PASSWORD:

  1. Click the Settings icon and select Change Password.
  2. In the Change Password dialog, complete the following:
    • Enter a new password
    • Enter the password in confirm password field. Note: The password mist contain at least 8 characters, including 1 letter and 1 number.
  3. Click Yes.

TO DELETE USER ACCESS:

  1. Click the Settings icon and select Delete User.
  2. In the Delete User dialog, click Yes.

Database Management

Creating Databases

TO CREATE A NEW DATABASE:

  1. Click Databases.
  2. In the Add New Database dialog, enter a name for the database and click Next.
  3. In the Add User to New Database dialog, do one of the following:
    • Select an existing User from the drop-down.
    • Enter a password to create a new user.
  4. Click Submit.

Managing Your Database

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. Note: Before opening your server in phpMyAdmin, we will:

  • Check to see if phpMyAdmin has been installed.
  • If phpMyadmin is not found, it will automatically install the software in a /public/phpmyadmin directory.

TO MANAGE A DATABASE:

  1. Click the Settings icon and select Manage Database.
  2. Manage SQL server through phpMyAdmin.

TO RESTORE A DATABASE:

  1. Click the Settings icon and select Restore Database.
  2. In the Restore dialog, do the following:
    • Select a time period from the drop-down.
    • Select a target database from the drop-down.
  3. Click Yes.

TO DELETE A DATABASE:

  1. Click the Settings icon and select Delete Database.
  2. In the Delete Database dialog, click Yes.
Retrieved from "http://websupportwiki.com/en/index.php?title=MySQL_Manager&oldid=811"