This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .
I know the password is correct as I can log in with root@localhost to the mysql server and can also create users. However, when I try to grant privileges to the newly created user I get the dreaded "Access denied for user root@localhost (using password: YES)" error message.
I wouldn't set a password for mysql that wasn't my root or main user password, but I still get this no matter what I try# mysql_upgrade -p
Phase 1/3: Fixing table and database names
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
FATAL ERROR: Upgrade failedI tried resetting the passwo
$ mysql -p -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Not sure what I'm doing wrong. My google-fu may be too week:
Please help as I am pulling my hair out once again after trying for over 15 months off and on to get a tv tuner working under linux. I have just received my new tuner card which I thought was supposed to be easy to run, a HVR-950Q, no luck yet.
But first I am trying to use something called mysql (new to me), for mythtv and [I] keep getting