安装Mariadb
1.yum install maridb mariadb-server
2. chmod 777 /etc/my.cnf
3. systemctl start mariadb;开启服务
4. systemctl enable mariadb;开机启动
5. systemctl status mariadb,查看状态
[root@myhost etc]# systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since 二 2020-07-07 16:08:22 CST; 9min ago
Main PID: 3111 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─3111 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─3212 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/myhost.er...
7月 07 16:08:19 myhost mariadb-prepare-db-dir[3076]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mariadb-prepare-db-dir[3076]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mariadb-prepare-db-dir[3076]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
7月 07 16:08:19 myhost mariadb-wait-ready[3112]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mariadb-wait-ready[3112]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mysqld_safe[3111]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mysqld_safe[3111]: Warning: World-writable config file '/etc/my.cnf' is ignored
7月 07 16:08:19 myhost mysqld_safe[3111]: 200707 16:08:19 mysqld_safe Logging to '/var/lib/mysql/myhost.err'.
- mysql_secure_installation 回车
Enter current password for root (enter for none):
OK, successfully used password, moving on…
设置密码
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
7.mysql -uroot -p 输入密码
8. GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘passwd’ WITH GRANT OPTION;
9. flush privileges;