Advertisement
Guest User

Untitled

a guest
Sep 9th, 2017
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. #1045 Cannot log in to the MySQL server
  2. -- PHPMyAdmin
  3.  
  4. [xerrao@VicsVPS mysql-gui-tools-5.0]$ mysql -u xerrao -p
  5. Enter password:
  6. ERROR 1045 (28000): Access denied for user 'xerrao'@'localhost' (using password: YES)
  7. -- MySQL cli
  8. -- MySQL GUI tools
  9.  
  10. Any created users can not log in, only root. Tried "FLUSH PRIVILEGES;", with result of:
  11. 110215 20:39:33 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
  12.  
  13. When using CLI, root needs to have a password specified or else it can not log in:
  14. [root@VicsVPS init.d]# mysql
  15. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  16.  
  17. However, using mysql cli on the system account "xerrao" will log into "xerrao@localhost" (i think)
  18.  
  19. [xerrao@VicsVPS mysql-gui-tools-5.0]$ mysql
  20. Welcome to the MySQL monitor. Commands end with ; or \g.
  21. Your MySQL connection id is 237
  22. ...
  23. mysql> \s
  24. ...
  25. Current user: xerrao@localhost
  26. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement