|
How to create a user for a MySQL Database
When ever you have any type of MySQL database, you will need to assign a user to be able to access the database. If you would like to create a user and give them access to the database, please do the following:
- Click MySQL Databases
- Scroll down until you see the Current Users section
- under this section and to the right of “User name:”, please provide a user name for a database
- Please note that that full database user will be “cpaneluser_databaseuser”
- To the right of “Password:”, please type the password for which you would like to create for this database user.
- Click Create User
You have now created a database user. You now need to give the user privilages for your specified database.
- In the drop down menu to the right of “User:”, Please select the user for which you would like give privileges to.
- To the right of “Database:”, please select a database for which you would like the user to have privileges to.
- Under privileges please choose what type of privileges you would like the user to have.
- Click “Add User To Database” Button. You have now created a new database with a privileged user. You can now input the information into a PHP script or another script to access it locally
You have now just given a user permissions to a database.
|
