Create new mysql Databases command/shell?

January 11, 2017 21:58

Hello, You can use the following UAPI function to create a database via the command line: UAPI Functions - Mysql::create_database - Software Development Kit - cPanel Documentation Let us know if you have any questions. Thanks!

0

kiopeed

January 12, 2017 04:39

welcome mr.cPanelMichael I do not know to use this site in my order UAPI Functions - Mysql::create_database - Software Development Kit - cPanel Documentation Please I want to know simply orders I need a job Example prefer pictures 1- codex.wordpress.org/images/a/ae/cpanel-createdb-step1.png 2- codex.wordpress.org/images/2/24/cpanel-createdb-step2.png 3- codex.wordpress.org/images/5/5b/cpanel-createdb-step3.png Please I want the work of this command line Please I want it here, please, for example,
/scripts/pkgacct username
Thank You mr. cPanelMichael

0

cPanelMichael

January 12, 2017 13:41

Hello, Could you elaborate a little more on which part of the document you'd like help with? For instance, you can browse to: UAPI Functions - Mysql::create_database - Software Development Kit - cPanel Documentation Then, look under "Examples" and expand "Command Line" to see an example of how to run it as a command. You can also create database users and add database users to databases: UAPI Functions - Mysql::create_user - Software Development Kit - cPanel Documentation UAPI Functions - Mysql::set_privileges_on_database - Software Development Kit - cPanel Documentation Thank you.

0

kiopeed

January 14, 2017 07:37

I apologize mr cPanelMichael I do not understand What can I type here command uapi --user=username Mysql create_database name=newdb uapi --user=username Mysql create_user name=dbuser password=12345luggage uapi --user=username Mysql set_privileges_on_database user=dbuser database=mydb privileges=DELETE,UPDATE,CREATE,ALTER ?? How can type here at command Is there an example of, for example, Sorry for the inconvenience please help me I want, for example, I set up a database named (avengers) and i have domin Name example.com I have created this free domain experience How can I create the database as I mentioned to you that name is also mentioned in the previous I want you to, for example, an example uapi --avengers=avengers Mysql create_database avengers=newdb I want you to correct code

0

cPanelMichael

January 16, 2017 14:14

Is there an example of, for example, Sorry for the inconvenience please help me I want, for example, I set up a database named (avengers) and i have domin Name example.com I have created this free domain experience How can I create the database as I mentioned to you that name is also mentioned in the previous I want you to, for example, an example uapi --avengers=avengers Mysql create_database avengers=newdb I want you to correct code

Hello @kiopeed, Let's say the cPanel account username is 'cpuser123', and you want to create a database named 'avengers' under this cPanel account. In this case, you'd access SSH as root and enter the following command:
uapi --user=cpuser123 Mysql create_database name=avengers
Next, you'd run the following command to create the MySQL user:
uapi --user=cpuser123 Mysql create_user name=dbuser password=12345luggage
Simply replace 'dbuser' and '12345luggage' in the above command with the database username and password of your preference. Finally, add the user to the database with this command:
uapi --user=cpuser123 Mysql set_privileges_on_database user=dbuser database=avengers privileges=ALL%20PRIVILEGES
Replace "ALL%20PRIVILEGES" with the the specific privileges that match your preference, as documented at: UAPI Functions - Mysql::set_privileges_on_database - Software Development Kit - cPanel Documentation Information on accessing your server via SSH is available at: SSH Access - Documentation - cPanel Documentation Let us know if this helps. Thank you.

0

kiopeed

January 17, 2017 13:33

Li shows an error Hosting data is user is :avengers Through it :
uapi --user=avengers Mysql create_database name=avengers
[PHP][root@host ~]# uapi --user=avengers Mysql create_database name=avengers Failed to close read filehandle from "/usr/local/cpanel/cpanel": at /usr/local/cpanel/Cpanel/XML.pm line 97. "/usr/local/cpanel/cpanel" exited with status 1 (EPERM). at bin/apitool.pl line 147. [root@host ~]#[/PHP] I do not know what this error

0

cPanelMichael

January 23, 2017 17:49

Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.

0

kiopeed

January 24, 2017 15:12

I was not able to get to open a support ticket Possible direct link i not can get frome this link How to Open a Technical Support Ticket - cPanel Knowledge Base - cPanel Documentation

0

cPanelMichael

January 24, 2017 15:57

I was not able to get to open a support ticket Possible direct link i not can get frome this link

0

kiopeed

January 25, 2017 14:13

i done open at

0

cPanelMichael

January 30, 2017 12:11

Hello, To update, it looks like the commands are now working well after addressing an issue with the license on the system. Thank you.

0

Create new mysql Databases command/shell?

Comments

Didn't find what you were looking for?