Authentication screw up
I'm running 3.23.58 on a Red Hat Fedora Core 1 box with the latest updates, (as of a couple days ago). I was using webmin to change the permissions on the database so I could access it from another box. Now, no matter who or what I log in as I can't access anything. If I try to go to the command prompt and use mysql or mysqladmin I get access deniged for user @localhost. No root or anything like that. I don't know where I screwed up, but I obviously screwed up something. Any ideas out there on how I can get back in control of this situation? Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Authentication screw up
Nicholas Fitzgerald wrote: go to the command prompt and use mysql or mysqladmin I get access deniged for user @localhost. No root or anything like that. I don't know where I screwed up, but I obviously screwed up something. Any ideas out there on how I can get back in control of this situation? Shutdown mysqld, and restart mysqld with the --skip-grant-tables option. Now you will be able to connect as root without specifying a password. Once you've connected, give the command flush privileges to make Mysql start using the grant tables. Then you can add or edit records in the mysql.user table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]