Softaculous

Topic : Error: Unable to create database

Posted By: teochristian on July 26, 2013, 7:02 am

I have a VPS with NGINX, I've installed Webuzo but when i try to create a database i get this error: "Unable to create database". What happend?

Thank you

Posted By: valley on July 26, 2013, 7:37 am | Post: 1

Hi,

Is your MySQL service running ? You can restart the service from the Webuzo Enduser Panel, under the Services Menu.

Here is the guide:
http://webuzo.com/wiki/Restart_services

If you still face any issues, please open a Support Ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.
Support : https://www.softaculous.com/support/open.php

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

Posted By: teochristian on July 26, 2013, 8:16 am | Post: 2

Thank you! I have sent the ticket, and I'm waiting for a response from you.

Thank you!

Posted By: valley on July 26, 2013, 8:19 am | Post: 3

Sir it seems you had deleted the file at /var/webuzo/my.conf which caused the issue.

We have replied to your support ticket and your issue has been resolved.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

Posted By: teochristian on July 26, 2013, 8:58 am | Post: 4

Thanks, I've checked and it works, I've updated my ticket with a problem of my PHPMyAdmin. Thank you!

Posted By: awanxp on February 25, 2014, 4:41 am | Post: 5

same problem with me, i have sent a ticket yeseterday and still waiting a reply..

Waiting your help

-----------------------
CONTOH SURAT

Posted By: valley on February 25, 2014, 5:24 am | Post: 6

Quote From : awanxp February 25, 2014, 4:41 am

same problem with me, i have sent a ticket yeseterday and still waiting a reply..

Waiting your help

Changing the contents of the file /var/webuzo/my.conf does not change the password for the root user to MySQL server.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

Posted By: awanxp on February 25, 2014, 5:53 am | Post: 7

Quote From : valley February 25, 2014, 5:24 am

Quote From : awanxp February 25, 2014, 4:41 am

same problem with me, i have sent a ticket yeseterday and still waiting a reply..

Waiting your help

Changing the contents of the file /var/webuzo/my.conf does not change the password for the root user to MySQL server.

thx for replied my ticked,
i was editing /var/webuzo/my.conf back to the original content, but it does not solve my problem (Unable create database in end user panel)

i hope we can discuss more obout my problem via ticked..

-----------------------
CONTOH SURAT

Posted By: khsprince on September 17, 2014, 3:09 pm | Post: 8

Hi,

new user if face this issue go to your webuzo panel and click on change password icon just change your login password problem solved.

Posted By: valley on September 17, 2014, 3:11 pm | Post: 9

Quote From : khsprince September 17, 2014, 3:09 pm

Hi,

new user if face this issue go to your webuzo panel and click on change password icon just change your login password problem solved.

Changing the password from the Webuzo Enduser Panel does not change the password to the MySQL server's root user's password.

Invalid information provided :xd:

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

Posted By: iyang on March 17, 2016, 8:05 am | Post: 10

just reset the password, You can follow the below mentioned steps to reset MySQL password:

1. Firstly Stop MySQL service, using the command:

service mysqld stop

2. Start MySQL with option:

/usr/local/apps/mysql/bin/mysqld --skip-grant-tables

3. Login to MySQL as:

mysql -u root

4. Change database to mysql as:

use mysql;

5. Update root user password as:

update user set password=password('NEWPASSWORD') where user='root' and host='localhost' limit 1;

note: NEWPASSWORD should be replaced with desired password, everything else stays the same...

6. Exit from mysql, using the command:

exit;

7. Stop all MySQL service as:

killall mysqld

8. Start MySQL service normally as:

service mysqld restart

9. Check whether new password is working fine by loging in as:

mysql -u root -p

note: After this MySQL will prompt you for password. Please enter the NEWPASSWORD set by you above.

10. Update /var/webuzo/my.conf with the new working password.

Posted By: wapumts on September 28, 2020, 11:24 pm | Post: 11

i migrated from cpanel to webuzo

i can't create database
i can't create user database

i can't log into phpmyadmin

what to do ?

Posted By: salman on October 24, 2020, 3:26 pm | Post: 12

Hi,

Sorry for the delay.

Please open a support ticket with us and submit the credentials so we shall check the issue for you.