I don't know what I have done, really yesterday everything seems to be working as I wanted but it seems that there's something going on, I cannot no longer login to mysql and I haven't not forgot the password, I have created another user yesterday called example1 gave him all the privileges, by mistake I think I deleted the root user but everything was working yesterday, I could login with example1
today it's a different story, I deleted a big table this morning and from there everything is going wrong!
I'm not able to login to my mysql using any method, I uninstalled mysql
yum remove mysql yum remove mysql-server yum remove mysql-libs
and reinstalled it
yum install mysql mysql-server mysql-devel
the problem is still there, so reinstalling it didn't work I have to fix the problem
what's the problem?
I just wanted to tell you guys that i did reinstall it before i ask the question so you don't suggest that i reinstall it lol and I'm not ready to reinstall the OS because there are too many things there
and now the problem, I'm not sure what it is exactly otherwise I'd fix it myself, so I'm having the same problem as this guy but I tried every solution suggested and none works
you know most of the time it says
Access denied for user 'root'@'x.x.x.x' (using password: NO) and if i try to connect to the db it says YES, can i reset everything and start over?
If you need further info tell me, I'm using centos 5 64 bit