Linux中安装mysql，详细步骤。请参考，每一步亲力亲为

在路径/usr/local/下新建mysql文件夹

mkdir mysql

然后通过ftp进行mysql压缩包的上传

进行解压：

tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

对mysql文件夹重新命名

 mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql-5.7.26

 检查mysql组和用户是否存在，如果没有则创建

cat /etc/group|grep mysql

groupadd mysql

useradd -r -g mysql mysql　　#useradd -r参数表示mysql用户是系统用户，不可用于登录系统

创建data目录

cd /mysql-5.7.26

mkdir data

 将/usr/local/mysql/mysql-5.7.26的所有者及所属组改为mysql

chown -R mysql.mysql /usr/local/mysql/mysql-5.7.26

配置my.cnf

vi /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql/mysql-5.7.26
datadir=/usr/local/mysql/mysql-5.7.26/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/mysql-5.7.26/data/mysqld.log
pid-file=/usr/local/mysql/mysql-5.7.26/data/mysqld.pid
character_set_server=utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
explicit_defaults_for_timestamp=true
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

~                                                                                                                                                
~                                                                                                                                                
~                                                                                                                                                
~                                                                                                                                                
~                                                                                                                                                
~                                                                                                                                                
~                                                                                                                                                
~        

初始化MySQL

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7.26/ --datadir=/usr/local/mysql/mysql-5.7.26/data/

 如果报错：./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or 就安装libaio

 yum install libaio

查看临时密码：

cat /usr/local/mysql/mysql-5.7.26/data/mysqld.log

把启动脚本放到开机初始化目录

cp support-files/mysql.server /etc/init.d/mysql

 启动mysql

service mysql start

更改密码

进入

cd /usr/local/mysql/mysql-5.7.26

输入命令：

./bin/mysql -u root -p

输入刚才的密码

输入SQL：

mysql> SET PASSWORD = PASSWORD('admin');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;  

添加远程访问权限:

use mysql                                           
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;    

输入quit或者exit即可退出mysql

重启使之生效

service mysql restart

查看mysql运行：

ps -ef|grep mysql

添加需要监听的端口：

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

链接测试：

.

进行虚拟机重新启动：

 

以下进行加入服务

 

1、将服务文件拷贝到init.d下，并重命名为mysql

cp /usr/local/mysql/mysql-5.7.26/support-files/mysql.server /etc/init.d/mysqld

2、赋予可执行权限

chmod +x /etc/init.d/mysqld

3、添加服务

chkconfig --add mysqld

4、显示服务列表

chkconfig --list

如果看到mysql的服务，并且3,4,5都是开的话则成功，如果是关，则键入

chkconfig --level 345 mysqld on

5、重启电脑

reboot