找到一个非常好用的博客——非常感谢这位博主!!,结合自己的实战稍作调整。
一、下载使用mysql5.7 ->点击此处下载
检查系统中是否已经存在mysql,存在先卸载
[root@cc ~]# rpm -qa | grep mysql
[root@cc ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@cc ~]# yum -y remove mariadb-libs.x86_64
下载好通过xftp之类的远程传输软件上传到服务器端目录下,一般放在/usr/local/中
二、解压,安装
[root@cc ~]# tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ //解压
[root@cc ~]# cd /usr/local/
[root@cc local]# mv mysql-5.7.26-linux-glibc2.12-x86_64/ mysql //文件夹重命名,不然配置文件要写很长一段,xftp可以右键直接修改
[root@cc local]# cd mysql/
[root@cc mysql]# mkdir data //创建数据目录,xftp直接右键新建也可以
[root@cc mysql]# chown -R mysql.mysql /usr/local/mysql/ //修改所属主和所属组
[root@cc mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data //初始化
2019-06-26T07:12:23.842578Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-06-26T07:12:25.699399Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-06-26T07:12:25.920250Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-06-26T07:12:25.998106Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c03a1dc7-97e1-11e9-acca-000c29e6d627.
2019-06-26T07:12:26.041964Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-06-26T07:12:26.044143Z 1 [Note] A temporary password is generated for root@localhost: jcJ3Ncguf:ql //显示root@localhost第一次登录的随机密码,要记住!!!或者复制下来!!!
三、配置编辑配置文件/etc/my.cnf
[root@cc mysql]# vim /etc/my.cnf //没有vim 用vi也一样
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
socket=/usr/local/mysql/mysql.sock
character-set-server=utf8
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld.pid
[mysql]
socket=/usr/local/mysql/mysql.sock
[client]
socket=/usr/local/mysql/mysql.sock
四、配置环境变量,并刷新
[root@cc mysql]# vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
[root@cc mysql]# ./etc/profile.d/mysql.sh //两种刷新方式,还可以使用source /etc/profile.d/mysql.sh
五、生成启动脚本,并启动mysql
[root@cc mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@cc mysql]# chmod +x /etc/init.d/mysqld
[root@cc mysql]# vim /etc/init.d/mysqld
basedir=/usr/local/mysql //在第46~47行
datadir=/usr/local/mysql/data
[root@cc mysql]# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!
六、测试,修改root密码,并配置远程访问
[root@cc mysql]# mysql -uroot -p'jcJ3Ncguf:ql' //临时密码,一定要改!
mysql> ALTER USER root@localhost IDENTIFIED BY '123456' //修改为新密码
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> use mysql;//配置远程访问
mysql> select host,user from user;
mysql> update user set host='%' where user='root';
mysql> flush privileges;
mysql> exit //退出
Bye
[root@cc mysql]# mysql -uroot -p123456
mysql>