MariaDB学习笔记

 

1、CentOS 7安装MariaDB

yum install mariadb-server

 

2、新安装的MariaDB初始密码为空，可直接输入

mysql -u root -p

回车进入

[root@xxx xxx]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

3、MariaDB 的默认数据存放在 /var/lib/mysql/ 目录下

From: https://www.mayanpeng.cn/archives/69.html

4、MariaDB启动、停止、查看状态命令

启动

systemctl start mariadb.service

停止

systemctl stop mariadb.service

查看状态

systemctl status mariadb.service

From: https://blog.csdn.net/ymaini/article/details/82258028

5、MariaDB启动报错

以查看mariadb的日志文件，查看错误原因

cd /var/log/mariadb/
vi mariadb.log

From: https://blog.csdn.net/twypx/article/details/81450240

6、配置文件位置

/etc/my.cnf

/etc/my.cnf.d/client.cnf

From: https://baijiahao.baidu.com/s?id=1645005043180459694

/etc/my.cnf

7、MariaDB重装

CentOS 7.x 卸载删除MariaDB，重新安装

https://blog.csdn.net/chengyuqiang/article/details/80210416

8、MariaDB初始登陆报错 ERROR 1045 (28000) 的解决办法

https://www.linuxidc.com/Linux/2017-03/141240.htm