mysqli_real_connect() (HY0001698) Access denied for user 'root'@'localhost'

Опубликовано: 20 Август 2020
на канале: Technical Skills Linux
1,088
17

mysqli_real_connect() (HY0001698) Access denied for user 'root'@'localhost'

#How to enable root login ubuntu 18.04

Step:
sudo mysql

SELECT user,plugin,host FROM mysql.user WHERE user = 'root';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abc@123&';

FLUSH PRIVILEGES;

If my video is helpful to you then please like and subscribe

Thank you for watching my video