I was attempting to allow remote logins to MySQL, so i changed
/etc/mysql/my.cnf to bind to
0.0.0.0 instead of
127.0.0.1 (I was gonna put it right back, I promise!), but it didn't work so I attempted to change user root's host to * (which i later realized should have been %). Anyway, I'm now unable to login to the MySQL server even locally, unless I try to log in without a password, in which case it lets me in, but when I try to execute any commands it informs me that I'm not authorized to do that and that I'm user
''@'localhost'. I've shut down the server and run it with
--skip-grant-tables, which lets me log in as root and I can actually do stuff, but I'm not sure how to get normal, local passworded root logins back. I just checked and my PHP app (which has it's own set of credentials) works fine. And yes, I put the bind back to
127.0.0.1. In case it isn't obvious I'm pretty new to MySQL.
Server is running Ubuntu 12.04 LTS.
EDIT: To be clear, I'm not currently running it with