MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护。MariaDB完全兼容MySQL,包括API和命令行。
1. 切换成为root
[dc2-user@didiyun ~]$ sudo su [root@didiyun dc2-user]#
2.安装Mariadb
[root@didiyun dc2-user]# yum install mariadb-server mariadb
3. 启动mariadb
[root@didiyun dc2-user]# systemctl start mariadb
4. 验证是否启动
[root@didiyun dc2-user]# systemctl status mariadb
● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: active (running) since Tue 2018-04-17 10:43:02 CST; 41s ago Process: 2330 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS) Process: 2251 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS) Main PID: 2329 (mysqld_safe) CGroup: /system.slice/mariadb.service ├─2329 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─2491 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql... Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: MySQL manual for more instructions. Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: Please report any problems at http://mariadb.org/jira Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: The latest information about MariaDB is available ...g/. Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: You can find additional information about the MySQ...at: Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: http://dev.mysql.com Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: Consider joining MariaDB's strong and vibrant community: Apr 17 10:43:00 didiyun mariadb-prepare-db-dir[2251]: https://mariadb.org/get-involved/ Apr 17 10:43:00 didiyun mysqld_safe[2329]: 180417 10:43:00 mysqld_safe Logging to '/var/log/mariadb/mar...og'. Apr 17 10:43:00 didiyun mysqld_safe[2329]: 180417 10:43:00 mysqld_safe Starting mysqld daemon with data...ysql Apr 17 10:43:02 didiyun systemd[1]: Started MariaDB database server. Hint: Some lines were ellipsized, use -l to show in full.
5. 进入数据库,首次进入无密码
[root@didiyun dc2-user]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
6. 关于密码和远程访问设置,请参看mysql帮助文档。