• Home
  • Servers
  • Hosting Tutorials
    • cPanel&WHM
  • WordPress Tutorial
    • WordPress General
    • WooCommerce
    • Useful Plugin

Subscribe to Updates

Get the latest creative news from FooBar about art, design and business.

What's Hot

WordPress Two-Factor Authentication (2FA): what is it & using it on your site

January 26, 2023

The biggest source of WordPress vulnerabilities

January 26, 2023

15 ways to secure your WordPress site

January 19, 2023
Facebook Twitter Instagram
  • Home
  • Servers
    Featured
    Servers

    What Is Imunify360? How Does It Enhance Website Security?

    By The GeekJanuary 2, 20230
    Recent

    What Is Imunify360? How Does It Enhance Website Security?

    January 2, 2023

    How to set up a Raspberry Pi ownCloud server in 7 steps

    December 20, 2022

    How To Install Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7

    December 20, 2022
  • Hosting Tutorials
    1. cPanel&WHM
    Featured
    Hosting Tutorials

    What is Let’s Encrypt SSL certificate

    By The GeekDecember 26, 20220
    Recent

    What is Let’s Encrypt SSL certificate

    December 26, 2022

    What Is Web Hosting? What Is Shared Hosting?

    December 26, 2022

    How to install cPanel on CentOS 7

    December 22, 2022
  • WordPress Tutorial
    1. WordPress General
    2. WooCommerce
    3. Useful Plugin
    Featured
    Usefull Plugin

    WordPress Two-Factor Authentication (2FA): what is it & using it on your site

    By The GeekJanuary 26, 20230
    Recent

    WordPress Two-Factor Authentication (2FA): what is it & using it on your site

    January 26, 2023

    The biggest source of WordPress vulnerabilities

    January 26, 2023

    15 ways to secure your WordPress site

    January 19, 2023
Facebook Instagram
Horizen.ro – Tech Blog & Server environmentHorizen.ro – Tech Blog & Server environment
Subscribe
  • Home
  • Servers
    Featured
    Servers

    What Is Imunify360? How Does It Enhance Website Security?

    By The GeekJanuary 2, 20230
    Recent

    What Is Imunify360? How Does It Enhance Website Security?

    January 2, 2023

    How to set up a Raspberry Pi ownCloud server in 7 steps

    December 20, 2022

    How To Install Linux, Nginx, MySQL, PHP (LEMP) stack On CentOS 7

    December 20, 2022
  • Hosting Tutorials
    1. cPanel&WHM
    Featured
    Hosting Tutorials

    What is Let’s Encrypt SSL certificate

    By The GeekDecember 26, 20220
    Recent

    What is Let’s Encrypt SSL certificate

    December 26, 2022

    What Is Web Hosting? What Is Shared Hosting?

    December 26, 2022

    How to install cPanel on CentOS 7

    December 22, 2022
  • WordPress Tutorial
    1. WordPress General
    2. WooCommerce
    3. Useful Plugin
    Featured
    Usefull Plugin

    WordPress Two-Factor Authentication (2FA): what is it & using it on your site

    By The GeekJanuary 26, 20230
    Recent

    WordPress Two-Factor Authentication (2FA): what is it & using it on your site

    January 26, 2023

    The biggest source of WordPress vulnerabilities

    January 26, 2023

    15 ways to secure your WordPress site

    January 19, 2023
Horizen.ro – Tech Blog & Server environmentHorizen.ro – Tech Blog & Server environment
Home»cpanel&whm»Create MySQL Database and User via cPanel
cpanel&whm

Create MySQL Database and User via cPanel

The GeekBy The GeekDecember 22, 2022Updated:January 5, 2023No Comments2 Mins Read
Facebook Twitter Pinterest LinkedIn Tumblr Email
mysql create
Share
Facebook Twitter LinkedIn Pinterest Email

The MySQL Database Wizard is another useful tool that allows you to create a MySQL database and user via a web interface. If you are about to install a PHP-MySQL application and you do not have a database already created for your script, this tool will guide you through all the steps needed to create such.

To access the MySQL database Wizard, please scroll to the Databases section in your cPanel and click on the MySQL Database Wizard icon.

mysql database wizard

During the first step of your new database creation you will need to input the desired database name. Be advised that all cPanel databases are created with a prefix. This prefix represent your cPanel username and assures that your database name will be unique on the shared hosting environment even if you use a general database name such as test.

create database

For example, if your cPanel user is “myuser” and you input “database” as your database name, the result will be a database called “myuser_database“. You should take this under consideration when you configure your application or script to make sure that the correct settings are applied.

When you have the desired database name set, please click the Next Step button. During the next step of the process you will need to input your database username and password. This user will be the only one able to access the database. The username also follows the rule that its name is generated with a prefix, containing your cPanel username.

create user

For example, if your cPanel user is “myuser” and you input “user” as your database user, the newly created database user will be “myuser_user“.

To create the user click on the Create User button.

During the next step you should add privileges to your database user. Database user privileges sets the database actions that can be performed by this specific user. If you are about to setup and configure an application we recommend to apply All Privileges to make sure that your script will work properly.

add mysql privileges

When you are ready, click on the Next Step button on the bottom of the page. This will complete the process and you can now use your database name, user and password to install your application.

featured
Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
The Geek
  • Website

Related Posts

WordPress Two-Factor Authentication (2FA): what is it & using it on your site

January 26, 2023

The biggest source of WordPress vulnerabilities

January 26, 2023

15 ways to secure your WordPress site

January 19, 2023
Add A Comment

Leave A Reply Cancel Reply

Editors Picks

WordPress Two-Factor Authentication (2FA): what is it & using it on your site

January 26, 2023

The biggest source of WordPress vulnerabilities

January 26, 2023

15 ways to secure your WordPress site

January 19, 2023

What Is Imunify360? How Does It Enhance Website Security?

January 2, 2023
Top Reviews
Advertisement
Demo
Horizen.ro – Tech Blog & Server environment
Facebook Twitter Instagram Pinterest Vimeo YouTube
  • Home
  • Hosting Tutorials
  • Cpanel & WHM
  • Cookie Policy (EU)
© 2023

Type above and press Enter to search. Press Esc to cancel.

Manage Cookie Consent
We use technologies like cookies to store and/or access device information. We do this to improve browsing experience and to show personalized ads. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}