How to setup a database using the MySQL Database Wizard in cPanel

cPanel Paper Lantern MySQL series

1. How to setup a database using the MySQL Database Wizard in cPanel

This demo assumes you've already logged in to cPanel, and are starting on the home screen.
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Now let's learn how to setup a database using the MySQL Database Wizard.

Click the "MySQL Database Wizard" icon.
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Enter a name for the new database, then click "Next Step".
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Now we have to create a user for this database. Enter a username and create a password, then click "Create User".
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Click the "All Privileges" check box, then click "Next Step".
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

That's it! My MySQL database has been created, and the new user added to the database. The database name, username and password will all be needed for scripts that need to connect to the database.
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Now click the MySQL Databases icon on the main page.
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

Here you can see the new database you just setup.
FutureHosting Best Hosting in Ireland - How to setup a database using the MySQL Database Wizard in cPanel

This is the end of the tutorial. You now know how to setup databases using the MySQL Database Wizard.

Ця відповідь Вам допомогла?

 Роздрукувати цю статтю

Також прочитайте

How to repair a MySQL database in cPanel

cPanel Paper Lantern MySQL series 10. How to repair a MySQL database in cPanel This demo...

How to delete a MySQL database in cPanel

cPanel Paper Lantern MySQL series 3. How to delete a MySQL database in cPanel This demo assumes...

How to assign a user to a MySQL database in cPanel

cPanel Paper Lantern MySQL series 5. How to assign a user to a MySQL database in cPanel This...

How to create a MySQL database in cPanel

cPanel Paper Lantern MySQL series 2. How to create a MySQL database in cPanel This demo assumes...

How to check a MySQL database for errors in cPanel

cPanel Paper Lantern MySQL series 9. How to check a MySQL database for errors in cPanel This...