View Single Post
  #1  
Old 1st December 2010, 16:22
sellotape sellotape is offline
Member
 
Join Date: Oct 2010
Location: Maltby, UK
Posts: 65
Thanks: 12
Thanked 4 Times in 3 Posts
Default Unable to login to MYSQL as root

Hi there.

I can't login as root - I know that my login details are correct but when I login it says permission denied.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ISPConfig3.03 reports an error in red in the system log as...
2010-12-01 00:34 192.168.1.69 Error Unable to connect to the database:

I tried changing my root password by starting mysqld in safe mode as advised here...
Quote:
# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("your password here") WHERE User="root";
mysql> exit

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start
However I get this message...

Code:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0
I can login to the existing databases in ISPConfig 3.03 but when I attempt to create a new database - ISPConfig states it's all good to go but I am unable to login at all.

I'm not sure what to do next!

Thanks


Ash

Last edited by sellotape; 1st December 2010 at 16:33.
Reply With Quote
Sponsored Links