1、安装MariaDB
sudo apt install mariadb-server mariadb-client
装完之后肯定是慌乱状态,root用户不给登陆了,在命令行输入
mysql -u root
反馈这个错误
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
这个时候你肯定会:
sudo cat /etc/mysql/debian.cnf
看一下,会反馈如下信息:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
确实没密码啊,怎不让我登陆。。。。。,安全机制,从debian9的某个版本开始,不允许使用root用户登陆mariadb数据库了,解决方法很简单,建立一个自己的超级用户,用这个用户登陆即可,或者是:
sudo mysql -u root
在mariadb的控制台执行:
CREATE USER 'pmauser'@'%' IDENTIFIED BY '123456';