{"id":9217,"date":"2021-04-19T15:00:24","date_gmt":"2021-04-19T15:00:24","guid":{"rendered":"https:\/\/oxhosting.com\/blog\/2021\/04\/19\/how-to-produce-a-mysql-database-making-use-of-the-cpanel-api\/"},"modified":"2021-04-19T15:00:24","modified_gmt":"2021-04-19T15:00:24","slug":"how-to-produce-a-mysql-database-making-use-of-the-cpanel-api","status":"publish","type":"post","link":"https:\/\/oxhosting.com\/blog\/2021\/04\/19\/how-to-produce-a-mysql-database-making-use-of-the-cpanel-api\/","title":{"rendered":"How to Produce a MySQL Database Making use of the cPanel API"},"content":{"rendered":"<p><iframe loading=\"lazy\"  width=\"580\" height=\"385\" src=\"https:\/\/www.youtube.com\/embed\/LjamqoV4EqA?rel=0&#038;cc_load_policy=1&#038;modestbranding=1\" frameborder=\"0\" allowfullscreen><\/iframe><br \/>\n<br \/>Find out how to make the most of the command line to create a MySQL Database using the cPanel API. Here are the instructions that are used in the online video:<br \/>\nCreate the database: uapi &#8211;person=exampl3 Mysql develop_database name=db_title<br \/>\n(Switch &#8220;exampl3&#8221; with your cPanel username and &#8220;db_name&#8221; with the identify you would like to give to the databases.)<\/p>\n<p>Create the databases consumer: uapi &#8211;consumer=exampl3 Mysql build_user identify=db_user password=P@s$w0rd123!<br \/>\n(Replace &#8220;exampl3&#8221; with your cPanel username, &#8220;db_consumer&#8221; with the name you would like to give to the databases person, and &#8220;P@s$w0rd123!&#8221; to the password you would like to assign to this user.)<\/p>\n<p>Assign the database person privileges to access the database: uapi &#8211;consumer=exampl3 Mysql set_privileges_on_database person=db_person databases=db_title privileges=ALL<br \/>\n(Exchange &#8220;exampl3&#8221; with your cPanel username, &#8220;db_person&#8221; with your databases person, and &#8220;db_title&#8221; with the identify of the database.)<\/p>\n<p>00:00 Intro<br \/>\n00:23 Login to your server by way of SSH<br \/>\n00:27 Generate a MySQL Databases<br \/>\n00:34 Build a Databases User<br \/>\n00:41 Give the Consumer Acces to the Database<br \/>\n01:04 Check out the New Databases in cPanel<br \/>\n01:10 Outro<\/p>\n<p>\u25ba Master additional in our whole manual &#8211; How to Develop a MySQL Databases Employing the cPanel API:<\/p>\n<p>Similar Guides:<br \/>\n\u25ba How to Connect to your Server with SSH: <\/p>\n<p>\u25ba How to Login to cPanel:<\/p>\n<p>\u25ba You can also locate out a lot more by heading to our Site Classification: <\/p>\n<p>#MySQL #Databases #cPanel<\/p>\n<p>About Us:<\/p>\n<p>InMotion Hosting was started in 2001 and delivers particular and enterprise web internet hosting for everybody! For extra details about our WordPress optimized hosting ideas, stop by us at <\/p>\n<p>\u25ba<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Find out how to make the most of the command line to create a MySQL Database using the cPanel API. Here are the instructions that&#8230;<\/p>\n","protected":false},"author":215,"featured_media":9218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[22,3009,4980],"_links":{"self":[{"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/posts\/9217"}],"collection":[{"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/users\/215"}],"replies":[{"embeddable":true,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=9217"}],"version-history":[{"count":0,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/posts\/9217\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/media\/9218"}],"wp:attachment":[{"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=9217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=9217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oxhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=9217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}