RE: [webmin-l] MySQL - Root question

[Thomas <tp_...@ho...>]

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