Create and manage MySQL Databases using the Wizard in cPanel

Hi Everybody,

Follow this Simple Steps. Create and manage MySQL Databases using the Wizard in cPanel

1: You must Need C-Panel Login Details to access C-Panel. If you don’t have ask
from your Hosting Service Provider.
2: Login Your C-Panel
3: Create and manage MySQL Databases using the Wizard in cPanel

Now you will arrive at the MySQL Database Wizard page . Now Follow the below steps to Create and manage MySQL Databases

Step 1

Now we need to provide the name of the Database in the entry box titled ‘New Database’. This can be any name you choose but must only consist of letters and numerals. We’ll follow the video tutorial above and use the examples given there, so in this case we are using a database name of thenewdb. Click the ‘Next Step’ button to proceed.

Step 2

Now we arrive at the ‘Create Database Users’ page. Now that we have added the database using step 1, we must add one or more users to that database. A user does not necessarily represent an actual person, it is simply a username and password normally used in scripts to access, read and write to the database. Again, usernames can only consist of letter and/or numerals. So, following the video tutorial we enter the username and password in the entry boxes provided. In this case we are using quser as the username. Pay particular attention to the password strength meter when you provide the password, always attempt to achieve a strength of Very Strong to ensure a good level of security. Now click the ‘Next Step’ button.

Step 3

Now that we have created the database and user, we need to add the user to the database. On this page we can select the privileges that we want the user to have with the database. It is usual to have at least one user who has All Privileges to allow writing, reading and management of the database, so select All Privileges and then click the Next Step button to complete this stage.

We’ve now completed the MySQL Database Wizard. The database has been created, the user created and then added to the database. The next page confirms this information and gives us the opportunity to continue with the wizard to create another database.

If still Faced a Problem Click the Below url watch Video Tutorials

Thanks for Visit
http://linuxhostingtutorials.com

Create and manage MySQL Databases using the Wizard in cPanel