|
phpMyAdmin not working - can't login
|
Posts: 26
Group: Registered
Joined: Jun 2006
Status:
Offline
Reputation: 0
|
phpMyAdmin not working - can't login
Welcome to phpMyAdmin 2.8.0.2
Wrong username/password. Access denied.
I get this message when I try logging into phpMyAdmin. This is a recent problem, and updating the root MySQL password, Update Server Software,
Update System Software in Cpanel didn't fix it.
Any ideas on ways to remedy this?
Thanks 
06-23-2006 10:46 PM
|
|
|
 |
Posts: 214
Group: Administrators
Joined: May 2006
Status:
Offline
Reputation: 0
|
RE: phpMyAdmin not working - can't login
Either mysql would be down or you might be entering the wrong password. That's the only possibility I can think of.
06-24-2006 01:39 PM
|
|
|
|
Posts: 26
Group: Registered
Joined: Jun 2006
Status:
Offline
Reputation: 0
|
RE: phpMyAdmin not working - can't login
The way it worked in the past was if I was logged into Cpanel as root, then opened phpMyAdmin through Cpanel, it would stay logged in as root. But now it says wrong username/password.
MySQL isn't down, because my databases are working.
06-24-2006 09:04 PM
|
|
|
|
Posts: 214
Group: Administrators
Joined: May 2006
Status:
Offline
Reputation: 0
|
RE: phpMyAdmin not working - can't login
Try another reset of MySQL root password. Have you upgraded MySQL recently?
Well, if that doesn't helps, a ticket for cpanel support should be in place ..
06-25-2006 01:17 PM
|
|
|
|
Posts: 26
Group: Registered
Joined: Jun 2006
Status:
Offline
Reputation: 0
|
RE: phpMyAdmin not working - can't login
this is what it gives me when I try to 'reset local mysql root password':
Waiting for mysql to restart.....This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.
Running the script with the --verbose option may give you some information
of what went wrong.
If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
Done
Changing Password....Done
Reloading Mysqld...
Done
Waiting for mysql to terminate.....
Restarting MySQL ....Starting MySQL[ OK ] Done
The MySQL root password has been changed.
06-26-2006 01:29 PM
|
|
|
|
Posts: 26
Group: Registered
Joined: Jun 2006
Status:
Offline
Reputation: 0
|
 RE: phpMyAdmin not working - can't login
I got it working again...
somehow /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php got revereted back to the default settings, so I had to change these to lines to go with my current system:
$cfg['Servers'][$i]['socket'] = '/mnt/drive2/var/lib/mysql/mysql.sock'; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')
06-27-2006 12:32 AM
|
|
|
|
Posts: 26
Group: Registered
Joined: Jun 2006
Status:
Offline
Reputation: 0
|
RE: phpMyAdmin not working - can't login
well I can log in now...but when I go to any database, it says:
No tables found in database.
but they are there, and working...phpMyAdmin just can't see them...
06-27-2006 02:56 AM
|
|
|
|
