Creating MySQL User and Database Tutorial

MySQL Database Wizard tool you can easily create a MySQL user and a database and then assign the user to the database

Creating MySQL User and Database Tutorial



This tutorial covers the following topics:

This tutorial explains how to create a new MySQL user and database.



PART 1: How to create a MySQL user and database using the MySQL Database Wizard

STEP 1: By using the MySQL Database Wizard tool you can easily create a MySQL user and a database and then assign the user to the database. To access the tool, access your cPanel and click on the tool icon.


STEP 2: On the page that opens provide the desired MySQL database. Note that the database will always start with username_ prefix, where username is your cPanel user. Once ready, click the Next Step button.


STEP 3: On the next page you should provide the desired MySQL username and the password for it. Here the username is always prefixed with the cPanel username, similar to the database. When ready click the Create User button.


STEP 4: The user will be created for you and on the next page you are prompted to specify the desired permissions that the user has to the database. Choose the desired permissions and click the Next Step button.


STEP 5: That's it! Once the page loads you will see a confirmation message informing you of the successful completion of the operations.




PART 2: How to create a new MySQL Database

STEP 1: To create a MySQL database you can use the MySQL Databases tool in cPanel.



STEP 2: In the Create a New Database section add the desired name of the database and click the Create Database button.


STEP 3: On the page that loads you will see a confirmation message about the successful creation of the database.




PART 3: How to create a new MySQL User

STEP 1: To create a new MySQL user you can again use the MySQL Databases tool in cPanel. In the Add a New User section provide the desired username and a password for it. Then click the Create a User button.


STEP 2: On the page that loads you will see a confirmation message about the successful creation of the user.




PART 4: How to add an existing MySQL user to a database

STEP 1: In order for a MySQL user to be used to manage a certain database, the user permissions for that database must be set. You can manage the MySQL user privileges from the MySQL Databases tool in cPanel.

From the Add a User to a Database section choose the desired user from the User: drop-down and the database from the Database: drop-down. Then click the Add button.


STEP 2: On the page that opens, choose the desired privileges the user should have to the database and click the Make Changes button.


STEP 3: A new section will appear confirming the successful change.


COMMENTS

BLOGGER: 1
  1. Nice Templates. If you need More Free Blogger Templates. Then you can Visit my Blogger Templates site. Nayeem Free Template

    ReplyDelete

shopify
Themeforest
Godaddy
Themeforest
Godaddy
Name

Ads-Blogger,13,Blog,12,Blog-Blogger,6,Blog-Wordpress,1,Blogger,30,CMS,4,Joomla,9,Magento,8,Opencart,5,Premium-Blogger,8,Project-C-And-Cplus,7,Templates-HTML,6,Wordpress,48,
ltr
item
Blogger Templates, Wordpress Themes, Joomla Templates, Magento Themes Free And Paid Download: Creating MySQL User and Database Tutorial
Creating MySQL User and Database Tutorial
MySQL Database Wizard tool you can easily create a MySQL user and a database and then assign the user to the database
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2qIf9nLP1vTNt1ZHcmdDPVMCKlEOtMeyhvUdXvV0BX31SoSsYy_uYltqX1OtGS4uxu-LHYCIRn-5tc4vUnxnzuLKgJ1o0899NfL6WYY97nm_G-KfvTU3k3kd9n8T0amDr12Ke4OOiV2XI/s1600/Creating+MySQL+User+and+Database+Tutorial.jpg
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2qIf9nLP1vTNt1ZHcmdDPVMCKlEOtMeyhvUdXvV0BX31SoSsYy_uYltqX1OtGS4uxu-LHYCIRn-5tc4vUnxnzuLKgJ1o0899NfL6WYY97nm_G-KfvTU3k3kd9n8T0amDr12Ke4OOiV2XI/s72-c/Creating+MySQL+User+and+Database+Tutorial.jpg
Blogger Templates, Wordpress Themes, Joomla Templates, Magento Themes Free And Paid Download
https://www.utsthemesblog.com/2020/04/creating-mysql-user-and-database.html
https://www.utsthemesblog.com/
https://www.utsthemesblog.com/
https://www.utsthemesblog.com/2020/04/creating-mysql-user-and-database.html
true
8263452242709770316
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content