MySQl not connecting

[AlternativeWeb]

I'm having issues connecting to the databases.

I tired to reboot the server, but still wont connect to the MySQL database.
I can view normal HTML pages, but sites that require MySQl just won't load.

I tired the command "/etc/init.d/mysqld restart" which it did without any errors, but the sites still won't connect for some reason.

Any suggestions what I could do to correct this?

 

[onel0ve]

are you using any panel like cpanel , kloxo ,virtualmin ??

 

[AlternativeWeb]

I'm using Kloxo

 

[onel0ve]

kloxo :facepalm:

post here its output
cat /var/log/mysqld.log

 

[AlternativeWeb]

Yeah, I know lol, i'm stuck with kloxo it for now.

I ran the "cat /var/log/mysqld.log" command, but it was scrolling errors from sites i deleted 2 years ago and kept scrolling.. . it looked like it would had took forever to see the most recent log.

I end up canceling it and deleted the log file for the first time.
I lowered the max connection allowed and now it's up and working again.
What's weird is even after the reboot earlier, it still wasn't connecting.

i don't know, but when/if it happens again, i'll be sure to come back on here with the error log message.

Thanks for the assist!

 

[mmuyskens]

try tailing the end;


tail -n 10 /var/log/mysqld.log

 

[M0neyMan]

+ 1....but try with more lines...replace 10 with 100

also, is it a local connection?

tail -n 100 /var/log/httpd/error.log
would also be helpful

 

[simoestcoool]

try this one :

 Service Mysqld stop

mysqld_safe --skip-grant-tables &

 

[Veer]

Same happened with mine 4 days ago.

This happens sometimes if your hdd is full, mysql will fail to start even after 100 attemts of whatever command you apply.