ERROR 1045: Access denied for user: 'root@localhost'
Hi guys,When I type mysql on the shell as root , I am getting the error "1045: Access denied for user: 'root@localhost' (Using password: YES) "
I have tried the above steps by restarting the mysql with the --skip-grant-tables access :
root@abc [/var/lib/mysql/mysql]# /etc/rc.d/init.d/mysql start --skip-grant-tables;
root@abc [/var/lib/mysql/mysql]# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
I have checked the /.my.cnf file and the file is on the root folder.
Any advice will be appreciate .