Assign and Un-assign MySQL Users in LPCP

From Lunarpages Web Hosting Wiki
Jump to: navigation, search

From the LPCP web hosting control panel, you can easily assign and remove users to and from databases as you need to. In this tutorial, we will be be going over the steps you need to take to get both types of tasks done.

How to Assign a User to a MySQL Database

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

Assign-mysql-user-lpcp.png

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.

Remove-database-lpcp.png

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 user name. 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.

Share |
Want to read this in another language?