cPanel: Create new MySQL database and user

Please follow the steps below to create New User MySQL:

1. Login to your hosting control panel (EG. http://yourdomain.com/cpanel)
2. Click the MySQL Database icon under the "Database" section.
3. Under "Create New Database",

New Database: [FILL IN THE NAME OF THE DATABASE]

4. Click Create Database. to create the database, next is to create the database user.
5. At the section "MySQL User", under "Add New User" fill in the following.

Usename: [ENTER USERNAME]
Password: [PLEASE USE A STRONG PASSWORD]
Password (Again): [RE-ENTER THE PASSWORD AGAIN]

6. Click Create User.
7. Next to associate the user with the database.
8. At the section "Add User To Database", select the "User" and "Database" then click the Add button.
9. Next tick the checkbox "All Privileges" and click Make Changes to complete the steps.

Now, you can access your database via phpMyAdmin.

How to manage my MySQL databases?

You can also backup and restore your database via phpMyAdmin.

phpMyAdmin: Backup MySQL database
phpMyAdmin: Restore MySQL database

  • 8 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

Connection strings for MySQL

Connection string is a string that contains information about a data source and means of...

DirectAdmin: Backup MySQL database

Please follow the steps below to backup MySQL database in DirectAdmin control panel. * Please...

DirectAdmin: Restore MySQL database

Please follow the steps below to restore MySQL database in DirectAdmin control panel. * Please...

DirectAdmin: Creating MySQL database

Please follow the steps below to create MySQL database in DirectAdmin control panel. * Please...

SolidCP & MSPControl: Create MySQL database

Please follow the steps below to create your MySQL database. * Please replace yourdomain.com...