mysql 安装 和 配置 在 centos 7，mysqlcentos

mysql 安装 和 配置 在 centos 7，mysqlcentos

MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可。 MariaDB完全兼容MySQL。

下面的介绍来自 mariadb 网站：

MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, Facebook and Google.

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.

安装：

#yum install  mariadb mariadb-server mariadb-devel

如果上面的不成功，可尝试

#yum install mysql mysql-server mysql-devel

查看安装情况：

#mysql --version

配置：

连接 mysql

#mysql -u root -p

这会产生错误

启动 mysql 服务

#systemctl start mariadb

自启动 mysql 服务

#systemctl enable mariadb

证实

#systemctl list-unit-files --type=service |grep mariadb

连接 mysql

mysql

创建 mysql 新用户，默认为 root 用户，密码为空

mysqladmin -u test -p 111

mysql 常用工具

show databases;

use a_database;

create database a_database_name;

show tables;

describe a_table;

select a_column from a_table;

drop a_table;

drop a_database;

quit;

exit;