Jose: It looks like you can log in to the mysql client as root. Do you have permission to change the password once you're logged in?
[EMAIL PROTECTED] jusoz]$ mysql -u root -p Enter password: Welcome to the MySQL monitor... mysql>USE mysql; Database changed. mysql>UPDATE user SET Password = PASSWORD( 'xxxx' ) WHERE User = 'root'; Query OK, 0 rows affected (0.03 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql>FLUSH PRIVILEGES; Query OK, 0 rows affected (0.05 sec) mysql> quit; Then see if logging in as expected works: [EMAIL PROTECTED] jusoz]$ mysql -u root -pxxxx Wes On Sun, 29 Aug 2004 14:26:10 +0200, jose usoz <[EMAIL PROTECTED]> wrote: > Hello, > these are my first days with mySQL. Yesterday all is well. Today i > changed some permissions in the databases and groups. I think i have > returned to the original permissions, but i not have any permission with > the user root. Is possible to restore this user?: > > **login with my passw -> > [EMAIL PROTECTED] jusoz]$ mysql -u root -pxxxx > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > YES) > > **login without passw-> > [EMAIL PROTECTED] jusoz]$ mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 15 to server version: 4.0.18 > > **changing the passw -> > [EMAIL PROTECTED] jusoz]$ mysqladmin -u root -h localhost password "xxxx" > mysqladmin: unable to change password; error: 'Access denied for user: > '@localhost' to database 'mysql'' > > Thanks, > jose. > > -- > Jose Usoz / Cromosfera > http://www.cromosfera.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
