Linux （centos7 ）安装mysql（安装版）

一，首先到官网下载吧：

https://dev.mysql.com/downloads/file/?id=469456

二，解压：

#tar -xvf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar

解压后有如下的转速：

[root @ hostaa mysql_rpm] #ls -l 
总用量1141908
-rw-r - r-- 1 root root 584652800 5月13 01:02 mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
- rw-r - r-- 1 7155 31415 25079412 3月20 17:40 mysql-community-client-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 277784 3月20 17:40 mysql-community-common-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 3777808 3月20 17:40 mysql-community-devel-5.7.18- 1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 45493312 3月20 17:40 mysql-community-embedded-5.7.18-1.el7.x86_64.rpm
-rw-r - r - 1 7155 31415 23924496 3月20 17:40 mysql-community-embedded-compat-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 126060264 3月20 17:40 MySQL的社区-嵌入式devel的-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 2237888 3月20 17:40 mysql-community-libs-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 2113196 3月20 17:40 mysql-community-libs-compat-5.7.18-1.el7.x86_64.rpm
-rw-r-r-- 1 7155 31415 54661812 3月20 17:40 mysql-community-minimal-debuginfo -5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 169622200 3月20 17:41 mysql-community-server-5.7.18-1.el7.x86_64.rpm
-rw -r - r-- 1 7155 31415 14501488 3月20 17:41 mysql-community-server-minimal-5.7.18-1.el7.x86_64.rpm
-rw-r - r-- 1 7155 31415 116887988 3月20 17:41 mysql-community-test-5.7.18-1.el7.x86_64.rpm

三，卸载MariaDB的  

Centos7以上版本自带的数据库为mariadb，和mysql版本冲突，需要对其进行卸载：

rpm -qa | grep mariadb   //查询rpm安装包

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

四，按顺序进行安装：（不用全部安装，只安装必要的就可以）

这里要注意安装顺序，否则会报依赖包的错

rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm
# rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm
# rpm -ivh mysql-community-devel-5.7.20-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm

# rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm

如提示缺失libaio

# yum install libaio

五，配置mysql

  mysqld --initialize-insecure --user=mysql    创建 data目录

  systemctl start mysqld.service  启动

 mysql_secure_installation   //安全配置向导 

[root@server1 ~]# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
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 MySQL
root user without the proper authorisation.
Set root password? [Y/n] <– 是否设置root用户密码，输入y并回车或直接回车
New password: <– 设置root用户的密码
Re-enter new password: <– 再输入一次你设置的密码
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] <– 是否删除匿名用户,生产环境建议删除，所以直接回车
… Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <–是否禁止root远程登录,根据自己的需求选择Y/n并回车,建议禁止
… Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] <– 是否删除test数据库,直接回车
- Dropping test database…
… Success!
- Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] <– 是否重新加载权限表，直接回车
… Success!
Cleaning up…
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

六，配置远程登录及权限

在本机先使用root用户登录mysql：
 mysql -u root -p "root"
 mysql>use mysql
 mysql>UPDATE user SET host = '%' where user = 'root';  //允许远程机器连接 
进行授权操作：
 mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
重载授权表：
 mysql>FLUSH PRIVILEGES;