mysql 5.7 install centos 6

需要从MySQL开发者网站下载Yum仓库文件

包括一些安全特性的更新。Yum同时也将确保导入相关依赖库，这些都将使我们的安装过程简单化

## mysql repo

http://dev.mysql.com/downloads/repo/yum/

# yum localinstallmysql-community-release-el6-*.noarch.rpm
    # rpm -qa|grep mariadb

## yum方式安装mysql-server数据库服务

# yum install mysql-community-server

## 初始化数据库

# mysql_install_db --datadir=/var/lib/mysql

## mysql_secret密码文件

```mysql
    # mysqld --initialize
    # cat /root/.mysql_secret
    # Password set for user 'root@localhost' at 2016-08-16 21:31:07 
    #i.p?qgzf#:d
```

## 所属用户及其所属组

# chown mysql:mysql /var/lib/mysql -R
    # service mysqld start
    # mysql -uroot -p  ## password #i.p?qgzf#:d
    # SET PASSWORD = PASSWORD('newpasswd');
    # set password for root@localhost = password('mysqlroot');
    # shell>/path/mysqladmin -u UserName -h Host password 'new_password' -p

mysql> select @@server_id;

```mysql
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)
```

mysql> select version();

```mysql
+------------+
| version()  |
+------------+
| 5.7.14-log |
+------------+
1 row in set (0.00 sec)
```