| Step 1: Log into Cpanel then locate the database catagory and select MySQL® Databases. Step 2: There will be a box type the name of the database that you want to create. If you were successfull the following should appear: Step 3: To use the database it must have a mysql user attached to it to create a user you must navigate down to the MySQL Users area. In the username box you type the name of the MySQL user this can be anything but it is best to make it something descriptive so you know what the user is for. You must then create a password for the MySQL user this password can be anything but it is recomended to use the password generator to make a strong password. The MySQL user password is required for any application that wants to access the MySQL user. Step 4: Add the MySQL user to the MySQL database. To add a user to a database you must scroll down to the Add User to Database area. Once there you are presented with two drop down boxes. From the first one you must select the user that you want to add to a database and from the second you must select the database that you want the user added to after you do that you must click Add. Once you add the user to the database you get a screen where you select what powers you want the user to have for the database most of the time you would grant all privelages but there are times where you would grant less. Note: All databases and users are prefixed by your cpanel username. ex if your cpanel username was galah and you had a MySQL database you called clients and a user called management your MySQL database would be called galah_clients and your MySQL user would be called galah_management
|
