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…')
 
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
−
<br> Database Manager is a web based MySQL client that allows you to create and manipulate MySQL databases.
+
=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 best used for creating databases. For populating a database, you should consider using a script(PHP, ColdFusion) or CGI.
+
==Creating Database Users==
  
−
You can find more information about MySQL database at: http://www.mysql.com/
+
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.
  
−
<br> '''Setting your Database Manager password'''  
+
==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.
  
−
<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.  
+
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'''.
  
−
2. Enter a password in the "Password" textbox .  
+
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'''.
  
−
3. Enter it again into the “Confirm password” textbox.  
+
TO DELETE USER ACCESS:
 +
#Click the Settings  icon and select '''Delete User'''.
 +
#In the Delete User dialog, click '''Yes'''.
  
−
4. Select a database type from the drop down menu. There are 2 choices available: MySQL4 and MySQL5.
+
=Database Management=
 +
==Creating Databases==
  
−
5. Click the "Accept" button to save the changes.  
+
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'''.
  
−
&nbsp;&nbsp;&nbsp;&nbsp; Click "Cancel" to dismiss the changes made.  
+
==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.  
  
−
'''Note''' that this password is only for database administration.  
+
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'''.
  
−
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.  
+
TO DELETE A DATABASE:
 +
#Click the '''Settings''' icon and select '''Delete Database'''.
 +
#In the Delete Database dialog, click '''Yes'''.
  
−
<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.
 
−
 
−
&nbsp;&nbsp;&nbsp;&nbsp; Click "Cancel" to dismiss any changes.
 
−
 
−
<br> '''Creating a database'''
 
−
 
−
<br> 1.To create a database, under the Databases section click "Add Database".&nbsp;
 
−
 
−
2.Enter the name of the database you want to create.
 
−
 
−
3.Click the "Accept" button to save the changes.<br>
 
−
 
−
&nbsp;&nbsp;&nbsp; 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
 
−
 
−
<br>
 
−
 
−
'''Deleting a database'''
 
−
 
−
<br>
 
−
 
−
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.
 
−
 
−
<br>
 
−
 
−
'''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> ''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"