Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: justjon on February 04, 2009, 09:03:59 PM

Title: mySQL 'GRANT' privileges lost on root@localhost
Post by: justjon on February 04, 2009, 09:03:59 PM

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

Title: Re: mySQL 'GRANT' privileges lost on root@localhost
Post by: justjon on February 04, 2009, 09:34:35 PM

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

Title: Re: mySQL 'GRANT' privileges lost on root@localhost
Post by: cactus on February 04, 2009, 10:50:47 PM

Quote from: justjon on February 04, 2009, 09:03:59 PM

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