|
From: Thomas <tp_...@ho...> - 2006-05-22 16:23:45
|
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 |