本文共 2285 字,大约阅读时间需要 7 分钟。
为什么一定要手动安装MySQL那,使用系统的yum -y install mysql-server 他不香吗,但是默认安装的版本是(mysql-5.1.73-8.e16_8.x86_64)由于版本太低了好多等西都不能用,所以我今天给大家分享一下手动安装MySQL5.7.17(建议收藏)下载安装包:
方式一、 方式二、使用Linux下载wget进行下载我这里提供的是MySQL5.7.17wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
如果是在windows上下载的需要将下载好的压缩包上传到Linux上。
系统操作目录:
下载包地址:/export/sort
解压地址:/export/server 数据目录: /export/server/mysql-5.7.17/data 解压 :tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C ../server
检查MySQL是否有用户:cat /etc/group|grep mysql
创建MySQL用户和用户组: groupadd mysql useradd -r -g mysql mysqlchown -R mysql:mysql /export/server/mysql-5.7.17/
cp /export/server/mysql-5.7.17/support-files/mysql.server /etc/init.d/mysql
[mysqld]#设置mysql的安装目录basedir = /export/server/mysql-5.7.17#设置mysql数据库的数据存放目录datadir = /export/server/mysql-5.7.17/data#设置端口port = 3306socket = /tmp/mysql.sock#设置字符集character-set-server=utf8#日志存放目录log-error = /export/server/mysql-5.7.17/data/mysqld.logpid-file = /export/server/mysql-5.7.17/data/mysqld.pid#允许时间类型的数据为零(去掉NO_ZERO_IN_DATE,NO_ZERO_DATE)sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION#ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
./bin/mysqld --initialize --user=mysql --basedir=/export/server/mysql-5.7.17/ --datadir=//export/server/mysql-5.7.17/data/
查看 /export/server/mysql-5.7.17/data/mysqld.log
service mysqld start
mysql -uroot -p Jgth7g4n09?E进行修改密码mysql> set password=password('123456');mysql> grant all privileges on *.* to root@'%' identified by '123456';mysql> flush privileges;添加MySQL的远程mysql> use mysql;mysql> update user set host='%' where user = 'root';ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'mysql> flush privileges;重新启动MySQL service mysqld restart
在 /etc/profile.d/ 创建一个MySQL.sh
export MYSQL_HOME=/export/server/mysql-5.7.17export PATH=$PATH:$MYSQL_HOME/bin
修改完成后:source /etc/profile
1、查看有那个端口可以进行外部访问
firewall-cmd --list-ports
2、将MySQL端口添加进行外部访问
firewall-cmd --add-port=3306/tcp --permanent
转载地址:http://lokzi.baihongyu.com/