1.查看是否已有mysql数据库:
#rpm -qa |grep mysql
命令返回空,说明没有安装成功。
2.安装mysql
yum install mysql*
安装完成后,却发现只安装了JDBC和ODBC驱动。
3.安装MariaDB数据库
yum install mariadb*
(在Centos7中用MariaDB代替了mysql数据库。)
4.启动mariadb:
systemctl start mariadb
5.操作mariadb数据库:(密码是空的,在输入密码的位置,直接回车,按enter键)
[root@yl-web yl]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.41-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
rows in set (0.00 sec)
MariaDB [(none)]>
附录:
mariadb数据库常用命令如下:
systemctl start mariadb #启动
MariaDBsystemctl stop mariadb #停止
MariaDBsystemctl restart mariadb #重启
MariaDBsystemctl enable mariadb #设置开机启动