How To Create Mysql Database On Shared Hosting Cpanel - FreeCodeBlog

Last updated: Jun 30, 2022

Do you want to create a MySQL database in cpanel? Yes. Want to use MySQL database information in PHP, Laravel website? Yes. Okay before deploy PHP, laravel website on shared hosting cpanel you need to create MySQL database on cpanel. Now are you ready to create MySQL database on cpanel? Yes. Good, In MySQL database creating tutorial, I will explain how we can create MySQL database on shared hosting cpanel. You may need to test and modify the PHP version to create a cPanel MySQL database. Now start scrolling to create a MySQL database in cpanel by filling in or creating a new database, new user, add user to database.

 

How To Create Mysql Database On Shared Hosting Cpanel
How To Create Mysql Database On Shared Hosting Cpanel

 

1. C-Panel Dashboard.

If you want to create a database on cpanel then please login your shared hosting cpanel dashboard. you can easily login cpanel dashboard using username and password.

 

2. Change PHP Version.

Find Select PHP Version: After login on cpanel dashboard you need to find select php version to change php version. now click on select php version and change php version. I will recommend you to use latest version of php. for more information you can read how to check and change PHP version on shared hosting cpanel tutorial

 

3. Find MySQL® Databases.

Now you need to find MySQL® Databases on cpanel. Click on MySQL® Databases to create new database, user.

 

4.Create New Database: You need to create new database by filling name. If you have a created database on cpanel shared hosting then go to add new user step. fill database create input like “example”.

Modify Databases: You can modify database after created new database.

Check Database: You can easily check your created database by click on check database. you will see database tables list after click on check database button.

Repair Database: You can easily repair your created database by click on repair database.

Delete Database: Delete created database by click on delete button from cpanel database list.

 

5.Add New User: You need to create new user before create a database. If you have a created user on cpanel shared hosting then skip this step.

Username: You need to fill username to create new user.

Password: Fill password input filed. Use a strong password on password fill. if you need to generate a strong, secure password then see password generator online tool tutorial.

Password (Again): Please fill password and password again filed same password. don't use different password on password and password again filed.

Create User: Now click on create user button. It will create a new user. Your user will like “username_user”. don't forget to copy username and password privately.

 

6. Add User To Database: After created database and user you need to add user to database.

User: Select created user. click on dropdown menu and select created user.

Database: Select created database. click on dropdown menu and select created database.

 

Now you will use database information on any PHP script website.

 

Okay so this is for today. See you again next tutorials. Thanks

Post Tags
Post Writer
masum7323
Masum Biswas (@masum7323)

My name is Masum Biswas. I'm a full stack developer. I live in Bangladesh and I love to write tutorials and tools that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, MySQL, VueJS, Tailwind CSS and Bootstrap from the early stage.

Follow Me On
Related Posts
How To Import Mysql Database Table On Cpanel

Want to import MySQL database table on cpanel? Yes. Do you have any existing database? Yes. Good, If you have an existing MySQL database with table... Read More

Configure Laravel Project After Deploy On Shared Hosting Cpanel

Did you deploy the Laravel project to the shared hosting cpanel? Yes. Good, Have you configured the Laravel project after deploying on the shared h... Read More

How To Create Repository On Cpanel

Cpanel git version control! Yes. You should create repository on cpanel to use git version on your website. Want to connect GitHub repositories wit... Read More

Create A Email Account From Cpanel For Laravel Email Verification

Want to create an email account from cpanel? Yes!. Okay But why? Because I want to verify laravel email verification. Okay If you want to send a la... Read More

Deploy Laravel Project On Digital Ocean Full Explanation

Laravel is one of the best framework that builds web application in PHP. It ensures a pleasing journey for the developer with satisfactory function... Read More