MySQL problem

[Secret Agent]

Mysql giving the usual error


I cannot access phpmyadmin naturally, changed root password and got this error:

Mysql password change failed!!
A forced reset will now be attempted

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=root --host=localhost --password=v --database=mysql
Please check the above output and try again.


I chmod 1777 /tmp

I changed local password fo rmysql

I removed " from username/password from /root/.my.cnf also and restarted mysql,
got this error:


/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").


I did /scripts/updatenow and /scripts/upcp --force (CURRENT)

mysql.sock is already in /tmp and /var/lib/mysql as well

I did not bother with /scripts/mysqlup --force because the few times I've ran that in the past it wiped out databases

Nothing works.

Please help

[Secret Agent]

Fixed

/scripts/securetmp

I had that done, but had to undo / redo for whatever reason

[Secret Agent]

Ridiculous!

Its not working again!

I didn't touch anything after I ran the above and now its broken

[Secret Agent]

I restart mysql in ssh, it works fine and able to login to phpmyadmin

I restart in whm, it screws up everything

root@server [/scripts]# service mysql stop
No mysqld pid file found. Looked for /var/lib/mysql/server.domain.com.pid.

[Secret Agent]

Ok...

WHILE mysql restarts in WHM, I can squeeze into phpmyadmin, when it finishes restarting and gives the error, I get access denied in phpmyadmin

[eos1]

phpMyAdmin from WHM and cPanel ---> just a blank page !?

FreeBSD
10.4.0-EDGE_47

[B12Org]

check the error logs - sounds like mysql is failing after the service starts. You may be able to find the reason in the logs. Or at least a point to the right direction

[Jeffa]

You will probably find when you try to run mysql you also get
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

I've tried everything, inculding ln -s, permissions etc, removing all mysql products and reinstalling.. Nothing works.. Mysql looks very much like it hangs too...

-Jeffa