You are here

MYSQL default root pass

3 posts / 0 new
Last post
nayax's picture
MYSQL default root pass


I keep getting :

mysql> GRANT ALL ON *.* TO 'user'@'localhost'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)   When trying to grant permissions for a remote user. I'm not sure what I'm doing wrong though. I can see the databases and browse them using the default "password" pass. But as for granting permissions it just doesnt work.   What am I missing?   Thanks    
smarsh's picture
Re: MYSQL default root pass


You set the mysql password on installation - example taken from the Red Hat installation bits:



Simon Fries
simon.fries's picture
MYSQL default root pass


I am not able to Login to mysql with root-user with the newest (VMWare or Hyper-V)-Image. We wanted to migrate opsview to an other host an to the newest version but i am not able to import the database on the new server because i don't know the root-pw. during installation I am never asked to set an root-pw.

Do i have to activate opsview before using a backup of the old system?

Regards, Simon