centos7安装mariadb

安装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'.

6. 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;