How to create MySQL database in the Cpanel
by cyberspro
- Login to cPanel.
- Under Databases, click MySQL Databases.
- Type a name for the database in the Database field
- Click Create Database.
- Click Go Back.
Create database username and password
- Click MySQL Users just below your database name
- Enter a username and password and click create. (To get a generated strong password, click the Generate Password button)
- Click Go Back.
Adding the user to the database
- Below MySQL users there is Add User To Database
- Select user and the database
- Click add
- On the next page Manage User Privileges (if you are new just select all Privileges)
- Click make changes.
Accessing phpmyadmin
- Login to cPanel.
- Under Databases, click MySQL Databases.
- Click phpmyadmin..
Congratulations on creating the database, user and password, adding privileges and accessing phpmyadmin.
Category:
Website Hosting
Leave a Reply