## 二进制安装 http://www.mirrorservice.org/sites/ftp.mysql.com/Downloads/MySQL-5.7/ mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar wget http://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz ``` tar zxf mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.31-linux-glibc2.5-x86_64 /data/mysql mkdir /data/mysql/logs groupadd mysql useradd –g mysql –s /sbin/nologin chown –R mysql:mysql /data/mysql/ echo “export PATH=/data/mysql/bin:$PATH” >> /etc/profile source /etc/profile 配置my.cnf 初始化数据库 ./scripts/ mysql_install_db 删除数据库空帐号，设置密码 set password for root@"127.0.0.1"=password("123456"); flush privileges; ``` ## Mysql5.7初始密码及改密码及重置密码 ``` mysqld --initialize --user=mysql --basedir=/mnt/mysql/ --datadir=/mnt/mysql/data/ 5.7初始化 grep 'temporary password' /var/log/mysqld.log ALTER USER 'root'@'localhost' IDENTIFIED BY 'Qb!bZ_~2buXr7'; ALTER USER 'root'@'%' IDENTIFIED BY 'Qb!bZ_~2buXr7'; update user set host='10.%' where user='root' Qb#!b&Z$_~2)buXr5F 重置密码 配置文件添加skip-grant-tables=1，重启，无密码登录 mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> update user set authentication_string=password('nHH29kEA7') where user='root'; Query OK, 4 rows affected, 1 warning (0.02 sec) Rows matched: 4 Changed: 4 Warnings: 1 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit 去除skip-grant-tables=1 重启 ``` ## ubuntu下mysql5.7安装 [https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/](https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/) ubuntu 安装 ``` 使用apt-get install mysql-server 发现版本是5.6的，需要的是5.7的 于是使用apt-get remove mysql-server 同时查找所有mysql名字一起删除 下载最新的 wget http://dev.mysql.com/get/mysql-apt-config_0.8.2-1_all.deb Next, install it using dpkg sudo dpkg -i mysql-apt-config_0.8.2-1_all.deb sudo apt-get update sudo apt-get install mysql-server #但是有问题，查询半天才知道头一步的卸载不正确 sudo apt-get autoremove mysql-server --purge # 卸载mysql所有文件 sudo rm /var/lib/mysql/ -R # 删除数据库目录 sudo rm /etc/mysql/ -R #删除启动脚本、配置文件等 sudo apt-get remove apparmor # 这个apparmor是在装mysql-server时装上的，和安全有关 dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P # 清理残余mysql文件 然后重复上面的下载.deb，dpkg安装，更新 路径/etc/mysql/mysql.conf.d/mysqld.cnf是真实的配置文件路径 # 安装的mysql5.7.25默认无密码登录 use mysql; update user set authentication_string=PASSWORD("密码") where user='root'; update user set plugin="mysql_native_password"; flush privileges; ``` # centos 7.4安装mysql5.7 ## Enable to use MySQL 5.7 ``` /etc/yum.repos.d/mysql-community.repo [mysql57-community] name=MySQL 5.7 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ enabled=1 gpgcheck=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql yum repolist enabled | grep mysql yum install mysql-community-server -y ``` ## centos 6 安装mysql5.7 ``` 1. download yum repo wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm 2. install yum repo yum -y localinstall mysql57-community-release-el6-7.noarch.rpm 3. verify yum repo yum repolist enabled | grep "mysql.*-community.*" 3a. to enable/disable a particular release # yum-config-manager --disable mysql57-community # yum-config-manager --enable mysql56-community 4. install yum -y install mysql-community-server service mysqld start service mysqld status mysql --version 5. securing the installation grep 'temporary password' /var/log/mysqld.log mysql_secure_installation --> follow the prompts remove anonymouse users disallow root remote login 6. Enjoy mysql -u root -p 12345 ``` ## centos 7 安装mysql5.7 ``` wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm yum localinstall mysql57-community-release-el7-11.noarch.rpm yum repolist enabled | grep "mysql.*-community.*" yum install mysql-community-server ``` ## ubuntu 18.04 安装mysql5.7 `apt update && sudo apt install mysql-server` 可以选择运行`sudo mysql_secure_installation`进行安全配置 ## ubuntu 18.04 mysql 5.7.28切换存储路径 ``` # 修改主配置文件存储路径 vim /etc/mysql/mysql.conf.d/mysqld.cnf cp -r /var/lib/mysql/* /data/mysql chown -R mysql.mysql /data/mysql # vim /etc/apparmor.d/usr.sbin.mysqld # Allow data dir access # /var/lib/mysql/ r, # /var/lib/mysql/** rwk, /data/mysql/ r, /data/mysql/** rwk, systemctl restart apparmor systemctl restart mysql ``` # ubuntu 20.04 安装mysql5.7 两种方法，二进制和直接安装 ``` wget https://repo.mysql.com//mysql-apt-config_0.8.12-1_all.deb dpkg -i mysql-apt-config_0.8.12-1_all.deb # 选择ubuntu bionic，回车后出现mysql-8.0-->点击这项回车-->就可以选择mysql5.7，再回车-->选择ok再回车 apt update # 提示没有公钥，安装 sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29 # 安装后再次执行 apt update # 查看有没有mysql5.7 apt-cache policy mysql-server # 根据查询出的mysql具体版本，填写，安装 sudo apt install mysql-client=5.7.42-1ubuntu18.04 sudo apt install mysql-server=5.7.42-1ubuntu18.04 ```