CentOS下yum安装Mariadb

最新推荐文章于 2025-02-26 16:54:46 发布

原创最新推荐文章于 2025-02-26 16:54:46 发布 · 951 阅读

0 ·

CC 4.0 BY-SA版权

CentOS下yum安装Mariadb

Note:

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

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

[monitor@iZ25yj7b8f3Z ~]$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.0.17-MariaDB MariaDB Server

Copyright (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)]> exit
Bye

参考:

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/