How to create MySQL Database in localhost or cPanel ? : MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. MySQL written in c, c++. For more information about MySQL you can visit official site of MySQL : https://www.mysql.com/
We do store our site data on on hosting servers and we do connect or manage through MySQL. Now we are going to learn how to create database in MySQL and connect with site.
How to create MySQL Database in localhost or cPanel ?
To create Database on MySQL is very easy but you have to do very carefully. You have to concentrate about correct spellings. If one single mistake on spelling cannot conect our Database with the site. Let’s create a Database
01: Log in your cPanel.
02 : Go to database and click on MySQL® Database Wizard.
Step 02 : Set Database Name
Step 03 : Create User
01 : Set Username for database admin
02 : Set Strong password for admin log in access.
03 : click on Create User
Now you can simply choose ALL PRIVILEGES. and click on Next Step.
Congratulations ! Now your database have been created.
How to contact database with WordPress Websites ?
You have to enter your database details correctly when you are going to setup WordPress.
For How to install WordPress and How to connect Database and WordPress please read this article: How to install WordPress in cPanel ? – WEBnerd Zone
How to edit MySQL Database in localhost or cPanel ?
If you need to configure or edit Database like change database name, change username, add user, change password etc. You may do from MySQL® Databases section in cPanel. From this tab you may also create new database. and you can see your database size.
Thank You fore regarding this my article if you have any confusion and Feedback for my work please leave a comment below in comment section. Please come back to this site regularly for learn about blogging/website building.