mariaDB配置远程登录

javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql

文件位置： /etc/mysql/mariadb.conf.d/50-server.cnf
大概26行，注释掉 bind_address=127.0.0.1 行

javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql

create user 'root'@'%' identified by '密码';

javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql

FLUSH PRIVILEGES;

javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql

systemctl restart mysql