How to Create a MySQL Database Using the cPanel API

Skip ad
9 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

Inmotionhosting
Published
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 password=P@s$w0rd123!
(Replace "exampl3" with your cPanel username, "db_user" with the name you would like to give to the database user, and "P@s$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 Access 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:
► https://www.inmotionhosting.com/support/website/how-to-create-a-mysql-database-using-the-cpanel-api/

Related Guides:
How to Connect to your Server with SSH:
► https://www.inmotionhosting.com/support/server/ssh/how-to-login-ssh/

How to Login to cPanel:
► https://www.inmotionhosting.com/support/edu/cpanel/how-to-log-into-cpanel/

#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 optimized hosting plans, visit us at:
► https://www.inmotionhosting.com/
Category
InMotion Hosting
Tags
MySQL, Database, cPanel
Be the first to comment