Categories
blog mysql

MySQL Access denied for user ‘root’@’localhost’

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt install mysql-server
Categories
blog mysql

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

sudo dpkg-reconfigure mysql-server-5.5

change the root password.

Categories
blog digitalocean mysql

digitalocean upgrade mysql server 5.6

sudo apt-get purge mysql-server*

and after that, I did this:

sudo apt-get install mysql-server-5.6 

 

 

 

 

Start:

sudo /etc/init.d/mysql start

Stop:

sudo /etc/init.d/mysql stop

Restart / reload configs:

sudo /etc/init.d/mysql restart

Check run status:

sudo /etc/init.d/mysql status