![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mariadb
习惯被淡忘
这个作者很懒,什么都没留下…
展开
-
解决mariadb无法修改root密码
操作系统:ubuntu 18.041.sudo systemctl stop mariadb2.sudo mysqld_safe --skip-grant-tables3.UPDATE mysql.user SET authentication_string = PASSWORD('new-password'), plugin = 'mysql_native_password' WHE...原创 2018-08-16 10:58:33 · 3562 阅读 · 0 评论 -
Mariadb 10.1配置远程访问
操作系统:ubuntu1.sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf注释掉bind-address=127.0.0.1这行2.GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;3.FLUSH PRIVILEGES...原创 2018-08-16 11:03:14 · 2309 阅读 · 0 评论