Re: [webmin-l] MySQL - Root question

[Scott M. <srm...@in...>]

Perfect - that did it - thank you very much.

Scott

----- Original Message ----- 
From: "Thomas" <tp_...@ho...>
To: <web...@li...>
Sent: Monday, May 22, 2006 10:23 AM
Subject: RE: [webmin-l] MySQL - Root question


> The users are listed once for each location they are GRANT'ed access. You
> can go directly to the server, access mysql and enter a GRANT command
> something like this and you will restore root.
>
> mysql -u root -p
>
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
>  IDENTIFIED BY 'whateverthepasswordis' WITH GRANT OPTION;
>
> Thomas
>
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...] On Behalf Of Scott 
> Miller
> Sent: Monday, May 22, 2006 11:43 AM
> To: web...@li...
> Subject: [webmin-l] MySQL - Root question
>
> Stupid Me - I was having a problem with a php script connecting to my 
> MySQL
> DB on another server, so I went into MySQL via Webmin, and clicked on User
> Permissions.  From there, root was listed twice (which it should be from
> what I understand), and I clicked on user: root  Hosts:  localhost  and
> changed Hosts from "localhost" to "any".  Now, I am locked out of MySQL 
> via
> Webmin.  My script seems to be working fine, but if anyone knows how to
> "un-do" what I did so I can get back into MySQL via Webmin, it would be
> appreciated.
>
> Thanks,
> Scott
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> -
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job 
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> -
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list