Create MySQL database step-by-step Print

  • 0

To take advantage of the MySQL service you must first create a MySQL database. Depending on the skin used (in this example the X3 skin is used) you can do so by using the MySQL Database Wizard.

Click on the MySQL Database Wizarad icon and follow these 3 steps:

Step 1 ) Create a Database - enter the name of the MySQL database in the corresponding form field and click on the "Next Step" button

Step 2) Create Database Users - now you must create a MySQL user and set a password for that user - do so by entering the username and the password in the corresponding form fields; you can use the

"Generate Password" button to automatically generate a hard-to-guess password. The "Password strength" bar will measure the 'strength' of the password. When ready press the "Next Step" button.

Step 3) Add User to the Database - this step allows you to add the MySQL user to the MySQL database; note that you can select the privileges (level of access) that you wish assigned to that MySQL user. Usually "All Privileges" are be granted - they will allow this user to perform all possible actions with the database. Click on the "All Privileges" check-box and then press the "Next Step" button

On each step you will see the result of the taken action - the name of the MySQL database, the username of the MySQL user and the password used for this user. Make sure to save this information since you will need it for setting up the web-application you wish to run.

The strength of the password depends on the number and type of characters entered. For passwords always use at least 8 characters that should be a combination between upper and lower case letters, numbers and all allowed symbols.

cPanel allows you to add multiple MySQL users to the same MySQL database. This is useful whenever you wish to have users with different level of access or privileges.


Was this answer helpful?

« Back