mysql: still can't login after root password reset
please help - I've managed to forget my root password and could not log into mysql. I then:
1. stopped mysqld, and restarted with --skip-grant-tables.
2. changed the root password by updating mysql.user
3. flushed privileges
4. restarted mysqld
when trying to start with 'mysql -u root mysql' i get logged in but whenever I try to do something I get
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
when trying to start with 'mysql -p -u root mysql' so i get prompted for my password and i type it in, i get:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
please help this thing is driving me up the wall. as you've probably seen above i'm no mysql expert.