问题:ubuntu2404使用命令安装mysql8,默认root无密码,如何解决?
方法:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;
拓展:
php7.2连接不上mysql8,也是这样解决
参考:
https://blog.csdn.net/qq_47753695/article/details/140985952
问题:ubuntu2404使用命令安装mysql8,默认root无密码,如何解决?
方法:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;
拓展:
php7.2连接不上mysql8,也是这样解决
参考:
https://blog.csdn.net/qq_47753695/article/details/140985952