Unable to login to MYSQL as root
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...
I'm not sure what to do next!
Looks as if you dont have a root user in your mysql setup anymore. You can check this e.g. with the command:
SELECT * FROM mysql.user WHERE User="root"
Hi there Till.
Thanks for your help.
I wondered if user - root had been removed but don't remember removing it!
I am still quite new to command line and centos - can you tell me how I would go about recreating user root please?
Bearing in mind at present I am unable to login to MYSQL at all and only in safe mode.
|All times are GMT +2. The time now is 18:43.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.