How to Create Mysql Database using SSH in WHM

Shishupal Kumar

• March 12, 2018 07:43

So, I have a WHM installed on CENTOS and want to create a database using SSH What I have found is these Commands but When I enter the first command it shows like this "/usr/local/cpanel/cpanel" exited with status 1 (EPERM). at bin/apitool.pl line 161. 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

• 

  cPanelMichael

  • March 12, 2018 16:06

  When I enter the first command it shows like this "/usr/local/cpanel/cpanel" exited with status 1 (EPERM). at bin/apitool.pl line 161.

  
  Hello, Can you verify your cPanel license is valid? You can do so by running the following command: /usr/local/cpanel/cpkeyclt
  Thank you.

  0
• 

  Shishupal Kumar

  • March 14, 2018 10:15

  It is expired. That's why i am using SSH? SO, I even not can create a database using SSH? I have already paid for some months and today when i need to create a database, I can't because I have to pay for this month to use it. WHM is full of features but I am not happy with the pricing modal. Please update me if I can create a database without license activation or i have to manually move to another control panel.

  0
• 

  cPanelMichael

  • March 14, 2018 17:10

  Hello, Features associated with cPanel & WHM are only designed to function properly when the cPanel license is valid. This includes our API functions. You would have to manually create the database and database users directly with MySQL: MySQL :: MySQL 5.7 Reference Manual :: 3.3 Creating and Using a Database Thank you.

  0
• 

  Shishupal Kumar

  • March 15, 2018 13:23

  You are indirectly referring me to Move to another Control Panel like Plesk or VestaCp. Thank you. will move for sure. :) Thank you for support.

  0
• 

  cPanelMichael

  • March 15, 2018 15:04

  Hi @Shishupal Kumar, cPanel & WHM servers require a paid license in order to function. If you are concerned about billing or payments, please feel free to reach out to our Customer Service Department directly at cs@cpanel.net and they can help answer any questions or concerns you have about pricing or renewal terms. Thank you.

  0

Please sign in to leave a comment.