I installed the latest mySQL Ubuntu distribution on my Ubuntu 13.04. The installation of the localhost server was succesfull and was working fine for a while. After creating a couple models (with no data in and saving them in my /home/... folder) on the server through mySQL Workbench I couldn't connect to the server anymore. The Workbench indicates that the server is running, but there is no connection to the server. When trying to access the server through terminal I get the following message:
root@simo-N150-N210-N220:~# mysql -u root -p mysql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
After creating the two models on the server I also used the mdbtools to export some tabels from my old MS Access database (as CSV). This should not have any impact on mySQL server.
As far as I understand, the firewall hasn't blocked anything.
What can I do??
root@localhost
? Just as a note: the-p mysql
does not provide the passwordmysql
, but selects the databasemysql
. If you did specify the right password interactively, then you want to check your system logs for errors or do a password recovery.