This isnt a problem with the previous VPS with apache problems this is with a dedicated i have
Basically i get this when i try to get into phpmyadmin through cPanel:
Warning: session_write_close(): open(/tmp/sess_b0d1d437b3642a3eea91e5d99a21e47e, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44
Warning: session_write_close(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101
I ran that in phpmyadmin and it gives: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1
The original version was 4.1.21 and is now MYSQL 5
Sorry, should have stated that is a shell script, not a MySQL command. I think by default it gets installed in /usr/bin, so to run it from a shell you would just issue "/usr/bin/mysql_fix_privilege_tables"
If it's not there, you can find it using:
find / -name mysql_fix_privilege_tables
Enterprise Network Engineer :: Hosting Hobbyist :: Master of Procrastination
"The really cool thing about facts is they remain true regardless of who states them."