Learn how to utilize the command line to create a MySQL Database using the cPanel API. Here are the commands that are used in the video:
Create the database: uapi –user=exampl3 Mysql create_database name=db_name
(Replace “exampl3” with your cPanel username and “db_name” with the name you would like to give to the database.)
Create the database user: uapi –user=exampl3 Mysql create_user name=db_user [email protected]$w0rd123!
(Replace “exampl3” with your cPanel username, “db_user” with the name you would like to give to the database user, and “[email protected]$w0rd123!” to the password you would like to assign to this user.)
Assign the database user privileges to access the database: uapi –user=exampl3 Mysql set_privileges_on_database user=db_user database=db_name privileges=ALL
(Replace “exampl3” with your cPanel username, “db_user” with your database user, and “db_name” with the name of the database.)
00:00 Intro
00:23 Login to your server via SSH
00:27 Create a MySQL Database
00:34 Create a Database User
00:41 Give the User Acces to the Database
01:04 View the New Database in cPanel
01:10 Outro
► Learn more in our full guide – How to Create a MySQL Database Using the cPanel API:
Related Guides:
► How to Connect to your Server with SSH:
► How to Login to cPanel:
► You can also find out more by going to our Website Category:
#MySQL #Database #cPanel
About Us:
InMotion Hosting was founded in 2001 and provides personal and business web hosting for everyone! For more information about our WordPress optimized hosting plans, visit us at
►
source
