How to access MySQL when I delete the root user on openSUSE 11?
- by Negin Nicki
Unfortunately I deleted MySQL users with the command
delete from mysql.user
and now I can't access MySQL. I tried looking at MySQL - ERROR 1045 - Access denied, but it is not proper for me because I don't have any user for MySQL.
I uninstalled and reinstalled MySQL but I can't access MySQL. What should I do? I wanted to have phpMyAdmin without login and I ruined the whole thing.
After uninstalling and having no result, I tried to delete the directories of MySQL and again installing them but again no result and now I have this error:
Error 2002:can't connect to local mysql server through socket /var/lib/mysql/mysql.sock
I don't have any user to reset the password of, but if I have by reinstalling which I don't know how to connect to MySQL.
I tried MySQL -u root
I tried MySQL
I tried mysqld-safe and etc in the link