Error when try instaling zPanel on Centos

December 11, 2013 12.5k views
ebertonmoraes
By:
ebertonmoraes
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]
Log In to Comment
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
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
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
kamaln7 MOD December 11, 2013
That means MySQL isn't started. Try starting it: 
sudo service mysql start
Reply
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
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
kamaln7 MOD 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
Have another answer? Share your knowledge.