Для MySQL 5.7
update user set authentication_string=password('PaSsWoRd') where user='root';
Для MySQL 8.x
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PaSsWoRd!';
Смена пароля MySQL
Добавить комментарий
Для MySQL 5.7
update user set authentication_string=password('PaSsWoRd') where user='root';
Для MySQL 8.x
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PaSsWoRd!';