修改MySQL/MariaDB数据库root用户名和密码 幻凌风关注IP属地: 陕西 2017.10.26 18:45:37字数225阅读3,298 MySQL 5.7以下版本更改密码:mysql -u root -p Enter password:*** mysql>use mysql; 选择数据库 Database changed mysql> update user set password=password("newPassword") where user='root'; 将...
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypassword'; 另外,MariaDB官网文档里的这个命令也不行(20220328更新:Mariadb 10.5以下命令可用): ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret"); 这两个命令都会报错: ERROR 1064 (42000)...