How to create My SQL Database and User?
Firstly check out how to create and modify database on My SQL video Tutorial:
You need not require to worry about creating My SQL database with cPanel as it is already included in Hosting plan of Inway Hosting. Firstly log in to cPanel for creating My SQL database on your hosting account. You can do this either by clicking on cPanel button located in customer area –>> my account segment or by pasting direct link in the web browser.
Then “yourdomainname.com” has to be replaced with actual domain name or servername.com has to be replaced with host name of Inway hosting the server on which your account has been hosted. We provide unlimited hosting india
After logging into cPanel, you can access My SQL management screen and click on the corresponding my SQL database option shown below:
For creating a new database, enter your desired name in the New Database section and click on Create database button mentioned below:
After that you will receive a confirmation massage, which shows that your database has been created successfully.
Click on “Go back” button to revisit the Database management screen. My SQL database created will use your username as prefix – username_databasename and this name will be applicable for using applications also.
A detailed Tutorial on How to create a My SQL Username?
You can create a new user which can connect to newly developed database. For creating a new user, fill your username and password in the space provided as mentioned below in the given image:
Click on “save” button to save your My SQL username.
Please note that to all the databases and usernames created by you, cPanel username will be added as a prefix to them.
A Detailed Tutorial on How to add a User to My SQL Database?
After creating Database and Username, you can add some rights to the database for the User. Choose them from the respective Drop down menu under section of Add User to Database and click on Submit button.
In the next step, you will be redirected to the new page and will be prompted to select desired rights or privileges. Choose All Privileges and click on make changes icon.
Use My SQL Database Wizard
My SQL database wizard helps you in completing all the steps successfully. Once you click on it, you will be guided through all the detailed steps for creating a new My SQL database and adding a user to it successfully. We provide Cheap hosting India