Páginas

martes, 18 de junio de 2019

Reset the MySQL ROOT Password in Ubuntu 16.04

Reset the MySQL ROOT Password in Ubuntu 16.04 (Tested in ysql-server-5.7):
sudo /etc/init.d/mysql stop
sudo mkdir /var/run/mysqld/
sudo chown mysql /var/run/mysqld/
sudo mysqld_safe --skip-grant-tables &
sudo mysql -u root
use mysql;
update user set authentication_string=PASSWORD("New_Passwore_Here") where User='root';
flush privileges;
exit;
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

No hay comentarios:

Publicar un comentario