How to create MySQL Database and User

Our Linux Hosting provides MySQL database. You can create your MySQL database through your cPanel. Here's the step by step :
- Login to your cPanel? (You can login through your client area or with URL (http://domain.com/cpanel)
- Go to "Databases" menu, then click "MySQL Databases" sub-menu

- You'll see database page. Enter the name of the database that you want to create, then click "Create Databases" button


For database username, you can also create on this page
- Enter the user database name along with the password (you can click "Password Generator" button to use complex password), then click "Create User" button


To access your database with user you've created, you need assign the user to the database first. Here's the step by step :
- Select the user name and database in the dropdown menu, then click "Add" button
- On next page, you'll see "Manage User Privileges" page. Checklist All Previleges and click "Make Changes" button.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to manage your MySQL Database

If you've created your database, you can manage your database through pypmyadmin.On cPanel you...

How to remote MySQL Database

If you want to remote your MySQL Database use third party tools such MySQL Front, navicat, etc...