CentOS7 安装MariaDB
1 2 |
yum install mariadb mariadb-server |
1 2 3 4 5 |
systemctl start mariadb #启动mariadb systemctl enable mariadb #设置开机自启动 mysql_secure_installation #设置root密码等相关 mysql -uroot -p #测试登录 |
创建远程用户
1 2 3 4 |
> GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; > flush privileges; |
Leave a Comment