manjaro mariadb配置踩坑

//安装mariadb
sudo pacman -S mariadb mariadb-clients

//初始化数据库
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

//启动
sudo systemctl start mysqld
//改密码
mysqladmin -u root password 'root'//报错

//修改配置文件
 sudo nano /etc/my.cnf 
//添加以下配置跳过配置
[mysqld]
skip-grant-tables

//重启
systemctl restart mariadb.service

//直接回车进入
mysql -u root -p

use mysql

set password for 'root'@'localhost'=password('123456')//如果报错，先进行下一步刷新再返回来设置，设置完之后再刷新一次
//ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

//刷新一下再执行上边设置密码就可以了
flush privileges ;

退出注掉配置文件中的跳过密码再重启

//设置开机启动
sudo systemctl enable mysqld