Buy .LK Domain Name - Click Here

How to Create MySQL Database and MySQL User?

Login to cPanel > MySQL Databases.

MySQL Databases

After that give a Database Name and add it.

Add a MySQL DB

As the next step, create MySQL Username and MySQL Password.

MySQL Username

While creating the MySQL Username and password, copy the values into somewhere else. So, as the next step, set permissions to that user to mysql database.

Select the MySQL Username from the User Dropdown and select MySQL Database from the Database Dropdown and press Add button.

Click All Privileges, and click on the Make Changes button. You are done. Now you have a MySQL Database, MySQL Username, and MySQL Password. MySQL Host is "yourdomain.com" or "localhost". Use those for your MySQL Configurations. If you want to connect that Username, you would need Remote MySQL Connection and you can connect via an external application also.

  • 46 Users Found This Useful
  • MySQL, Database, Create DB
Was this answer helpful?

Related Articles

 Enable Remote MySQL Database Connection

If you need to connect to the MySQL Database from External Application, you need to enable...