Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #1045 Cannot log in to the MySQL server
- -- PHPMyAdmin
- [xerrao@VicsVPS mysql-gui-tools-5.0]$ mysql -u xerrao -p
- Enter password:
- ERROR 1045 (28000): Access denied for user 'xerrao'@'localhost' (using password: YES)
- -- MySQL cli
- -- MySQL GUI tools
- Any created users can not log in, only root. Tried "FLUSH PRIVILEGES;", with result of:
- 110215 20:39:33 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
- When using CLI, root needs to have a password specified or else it can not log in:
- [root@VicsVPS init.d]# mysql
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- However, using mysql cli on the system account "xerrao" will log into "xerrao@localhost" (i think)
- [xerrao@VicsVPS mysql-gui-tools-5.0]$ mysql
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 237
- ...
- mysql> \s
- ...
- Current user: xerrao@localhost
- ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement