CentOS下yum安装Mariadb

来源：互联网发布：mac 磁盘找不到原身编辑：程序博客网时间：2024/05/16 10:21

CentOS下yum安装Mariadb

Note:

在安装完毕后, 要给远程连接权限

而这个命令是需要在进入Mariadb里面的, 也就是这样

[monitor@iZ25yj7b8f3Z ~]$ mysql -u root -pEnter password: Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 12Server version: 10.0.17-MariaDB MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '111111' WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)MariaDB [(none)]> flush privileges;Query OK, 0 rows affected (0.00 sec)MariaDB [(none)]> exitBye

参考:

mariadb配置允许远程访问方式 - 逆水寒龙 - 博客园
http://www.cnblogs.com/24la/p/mariadb-remoting-access.html

为 MariaDB 配置远程访问权限 - MariaDB Knowledge Base
https://mariadb.com/kb/zh-cn/configuring-mariadb-for-remote-client-access/

0 0