Create and Delete MySQL Users in LPCP

From Lunarpages Web Hosting Wiki

Jump to: navigation, search

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

How to Create a MySQL User

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

Image:newchange-db-user-pass-lpcp.png

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 user name in the text box marked for "Username" and that user name's password in the box labeled, "Password". Type the password again in the box marked for, "Re-enter New Password".

Please Note: DO NOT CHANGE the information in the text box next to where it says Hostname. Doing so could cause your database to not be setup correctly.

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.

Image:newcreate-db-user-lpcp2.png

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.

Please Note: Ignore the @IPADDRESS information when setting up database to be used with third party scripts or services you have installed on your account. For more information, please check out Connecting to Databases in LPCP.

How to Change a MySQL User's Password

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

Image:create-db-user-lpcpnew.png

Please Note: DO NOT CHANGE the information in the text box next to where it says Hostname. Doing so could cause your database to not be setup correctly.

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.

Share |
Want to read this in another language?
Personal tools