Question

Error when try instaling zPanel on Centos

Posted December 11, 2013 13.4k views
When i try acces, give me the error: Critical Error: [0100] - Unable to connect or authenticate to the ZPanel database (zpanel_core). We advice that you contact the server administrator to ensure that the database server is online and that the correct connection parameter are being used. I'm trying start mysql server but no succes... [root@HoostLinux01 ~]# sudo service mysqld start Another MySQL daemon already running with the same unix socket. Starting mysqld: [FAILED]
Add a comment
ebertonmoraes
By:
ebertonmoraes
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
7 answers
kyl2113 December 11, 2013
check that the mysql user account you've configured zPanel to use has the correct privileges and is allowed to connect on localhost. You can do this in the terminal with the command 'mysql -u -p ', replacing and with the same credentials you configured zPanel with. Also, I'd recommend NOT using zPanel, as it's a security trainwreck.
Reply Report
kyl2113 December 11, 2013
my mistake, it seems DO community questions doesn't like anything between > and < signs. the command is 'mysql -u username -p password', replacing 'username' and 'password' with the credentials you configured zPanel with
Reply Report
ebertonmoraes December 11, 2013
Hello Two4, thank your for help.
I have this error in therminal:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Before attempting to install zPanel, I had the same error trying to install phpMyAdmin:
phpMyAdmin - Erro
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
The server is not responding (or the local server's socket is not correctly configured).
Reply Report
kamaln7 December 11, 2013
That means MySQL isn't started. Try starting it: 
sudo service mysql start
Reply Report
admin427417 January 18, 2014
Destroy it and start over, Ive wiped a few droplets that Ive screwed up all by myself and Zpanel hasnt failed me yet. Very clear instructions here. http://docs.zpanelcp.com/?node=24
Reply Report
me216474 January 25, 2014
The Zpanel will appear to be working fine, if I reboot the box through my command line,

shutdown -r now

It happens every morning, I wake up and see all my websites hosted on the zpanel droplet gets crashed, with the below ERROR message.

Critical Error: [0100] - Unable to connect or authenticate to the ZPanel database (zpanel_core).


Any help would be appreciated.
Reply Report
kamaln7 January 26, 2014
Try upgrading your droplet or adding swap: https://www.digitalocean.com/community/articles/how-to-add-swap-on-centos-6.
How To Add Swap on CentOS 6
by Etel Sverdlov
Linux swaps allow a system to harness more memory than was originally physically available. Here's how to set up a linux swap file on CentOS 6
Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help