欢迎投稿

今日深度:

Mariadb 10.1配置远程访问,mariadb10.1

Mariadb 10.1配置远程访问,mariadb10.1


操作系统:ubuntu

1.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;

参考链接:

https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/

www.htsjk.Com true http://www.htsjk.com/mariadb/35639.html NewsArticle Mariadb 10.1配置远程访问,mariadb10.1 操作系统:ubuntu 1.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 OPTIO...
相关文章
    暂无相关文章
评论暂时关闭