Author:  Mitch Keeler

The exciting new control panel, LPCP has fantastic controls when it comes to managing your MySQL databases.  Since many of our customers are still new to this interface, and the way to create, edit, assign and delete these MySQL databases I wanted to write up a tutorial to help make your lives even easier.

How to Create a MySQL Database

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Scroll down the next page to where it says, “Create New MySQL Database”.  In the empty text box, type the name of your database, and then hit the button under it that says, “Create”.

Once you have done that, you should be taken to a new page which tells you the database has been created successfully.

How to Delete a MySQL Database

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Now, scroll down to the section that is labeled, “MySQL Databases” and has database names and assigned users listed.  To delete a database click the link that says, “Delete” next to the database’s name.  Next, you’ll be asked to confirm the deletion, and then taken to a page which tells you the deletion was completed successfully.

How to Create MySQL User

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

On the next page, go down until you see a section labeled, “Create a New MySQL User”.  Here you will want to type in the username in the text box marked for “username” and that username’s password in the box labeled, “Password”.  Once you have done that, click on the button labeled, “Create”.

If successful, you will get a message that says the MySQL user was created.

How to Delete a MySQL User

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Now, on the next page, go down the the section that lists all the MySQL users you have created.  To delete one, click the link labeled, “delete” next to the user name you wish to remove.  Next, you’ll be asked to confirm the deletion, and then taken to a page which tells you the deletion was completed successfully.

How to Change a MySQL User’s Password

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Scroll down the page till you see the section titled, “Change MySQL User password”.  First you will want to select the user in question from the drop down box.  Next, you will want to type in the new password, and finally you will want to re-type the new password into the third check box.  Once that has been done, click the button labeled, “Change”.  Once that has been done successfully, you will get a message telling you that the password has been changed for that user.

How to Assign a User to a MySQL Database

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Around the bottom of the next page, you should see a section titled, “Grant access for MySQL User”.  Beside where it says, “Database Name” use the drop down selection box to choose the database you wish to modify. Beside where it says, “Database User” use the drop down selection box to choose the user you wish to modify.

Now select the privileges you want to give that user when accessing that MySQL database.  You have the option of:

• ALL (user gets all privileges to the database) – recommended
• WRITE (user manipulates only data – INSERT, DELETE, UPDATE, SELECT queries)
• READ (user can only read the data – SELECT quires only)

Once you have picked one of those three, hit the button labeled, “Grant”.  After doing so, you should get a message that the user has been assigned to the database successfully.

How to Un-assign a User to a MySQL Database

Click the “MySQL Manager” link in the left sidebar menu of LPCP.

Now, scroll down to the section that is labeled, “MySQL Databases” and has database names and assigned users listed. To un-assign a user, under the “Assigned users” list click the “Remove” link that matches up with the database’s username.  You will be asked to verify that you really want to un-assign that user from the database, and then you should get a message verifying that the user was indeed removed from the database in question.

That should just about cover all of your MySQL needs when working from within the MySQL Manager tool located within the LPCP control panel.  Remember, if you ever need any assistance, support is around to help you 24/7 so please feel free to contact them at any time with any question.

Also don’t forget to go check out our LPCP tutorials, tips and more on the Lunarpages web hosting wiki.