Topic: mySQL 'GRANT' privileges lost on root@localhost

[justjon]

Hi, I have a problem I have been unable to solve re mysql.  I have two root users listed in my priviliges.  One is root@server1 and has grant option.  The other root@localhost without grant option.  'Server1' is the name of the host server.

I can log in via phpmyadmin and through winscp/putty and directly on the server itself using user 'root' and 'password' but I cannot restore the GRANT option on the root@localhost.  All databases are functional and accessible with their own user rights.

Have I broken the server installation? or is there a fix for this.  It is preventing installation of further databases.

Any advice appreciated, many thanks

J

[justjon]

Problem solved - duplicate root user deleted and GRANT restored by direct table access.

[cactus]

I can log in via phpmyadmin and through winscp/putty and directly on the server itself using user 'root' and 'password'

You should never need to, if you login as root on the server shell you only need to type mysql to enter a mysql shell as root user, you most likely have been tempering with your root user (and password as well perhaps), please read up on MySQL and SME Server here: http://wiki.contribs.org/MySQL