MySQL 5 - 8 各版本快速安装脚本内容

技术2022-07-13 140

MySQL 5.5.62

#如果之前有MYSQL 那么先停服务 /etc/init.d/mysqld stop #如果之前已经装过MYSQL 那么先备份数据目录 tar -jcvf mysql.tar.bz2 /var/lib/mysql #卸载之前已经安装过的MYSQL软件RPM rpm -qa|grep mysq| xargs rpm -e --nodeps #下载MYSQL 5.5.62 wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-common-5.5.62-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-compat-5.5.62-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-5.5.62-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-client-5.5.62-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-server-5.5.62-2.el6.x86_64.rpm #安装 rpm -ivh mysql-community-libs-compat-5.5.62-2.el6.x86_64.rpm mysql-community-client-5.5.62-2.el6.x86_64.rpm mysql-community-common-5.5.62-2.el6.x86_64.rpm mysql-community-libs-5.5.62-2.el6.x86_64.rpm mysql-community-server-5.5.62-2.el6.x86_64.rpm 修改/etc/my.cnf 中的 datadir 到你要的目录 mkdir /@@datadir chown mysql:mysql /@@datadir mysql_install_db chown -R mysql:mysql /@@datadir mysqld_safe & mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql'); FLUSH PRIVILEGES; exit /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql -uroot -pmysql

MySQL 5.6.46

#如果之前有MYSQL 那么先停服务 /etc/init.d/mysqld stop #如果之前已经装过MYSQL 那么先备份数据目录 tar -jcvf mysql.tar.bz2 /var/lib/mysql #卸载之前已经安装过的MYSQL软件RPM rpm -qa|grep mysq| xargs rpm -e --nodeps #下载MYSQL 5.6.46 wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-common-5.6.46-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-compat-5.6.46-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-5.6.46-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-client-5.6.46-2.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-server-5.6.46-2.el6.x86_64.rpm #安装 rpm -ivh mysql-community-libs-compat-5.6.46-2.el6.x86_64.rpm mysql-community-libs-5.6.46-2.el6.x86_64.rpm mysql-community-client-5.6.46-2.el6.x86_64.rpm mysql-community-common-5.6.46-2.el6.x86_64.rpm mysql-community-server-5.6.46-2.el6.x86_64.rpm 修改/etc/my.cnf 中的 datadir 到你要的目录 mkdir /@@datadir chown mysql:mysql /@@datadir mysql_install_db chown -R mysql:mysql /@@datadir mysqld_safe & mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql'); FLUSH PRIVILEGES; exit /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql -uroot -pmysql

MySQL 5.7.28

>#如果之前有MYSQL 那么先停服务 /etc/init.d/mysqld stop #如果之前已经装过MYSQL 那么先备份数据目录 tar -jcvf mysql.tar.bz2 /var/lib/mysql #卸载之前已经安装过的MYSQL软件RPM rpm -qa|grep mysq| xargs rpm -e --nodeps #下载MYSQL 5.7.28 wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-common-5.7.28-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-compat-5.7.28-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-5.7.28-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-client-5.7.28-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-server-5.7.28-1.el6.x86_64.rpm rpm -ivh mysql-community-common-5.7.28-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.28-1.el6.x86_64.rpm mysql-community-libs-5.7.28-1.el6.x86_64.rpm mysql-community-client-5.7.28-1.el6.x86_64.rpm mysql-community-server-5.7.28-1.el6.x86_64.rpm 修改/etc/my.cnf 中的 datadir 到你要的目录 mkdir /@@datadir chown mysql:mysql /@@datadir mysqld --initialize chown -R mysql:mysql /@@datadir mysqld_safe --skip-grant-tables & mysql UPDATE mysql.user SET authentication_string = PASSWORD('mysql') , password_expired = 'N' WHERE User = 'root' AND Host = 'localhost'; FLUSH PRIVILEGES; exit /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql -uroot -pmysql

MySQL 8.0.17

>>#如果之前有MYSQL 那么先停服务 /etc/init.d/mysqld stop #如果之前已经装过MYSQL 那么先备份数据目录 tar -jcvf mysql.tar.bz2 /var/lib/mysql #卸载之前已经安装过的MYSQL软件RPM rpm -qa|grep mysq| xargs rpm -e --nodeps #下载MYSQL 8.0.17 wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-common-8.0.17-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-libs-8.0.17-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-client-8.0.17-1.el6.x86_64.rpm wget --no-check-certificate https://zcdn.askmaclean.com/mysql-community-server-8.0.17-1.el6.x86_64.rpm rpm -ivh mysql-community-client-8.0.17-1.el6.x86_64.rpm mysql-community-common-8.0.17-1.el6.x86_64.rpm mysql-community-libs-8.0.17-1.el6.x86_64.rpm mysql-community-server-8.0.17-1.el6.x86_64.rpm 修改/etc/my.cnf 中的 datadir 到你要的目录 mkdir /@@datadir chown mysql:mysql /@@datadir mysqld --initialize chown -R mysql:mysql /@@datadir mysqld_safe --skip-grant-tables & mysql UPDATE mysql.user SET authentication_string=null WHERE User='root'; FLUSH PRIVILEGES; exit; /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql'; FLUSH PRIVILEGES; exit; mysql -uroot -pmysql

Processed: 0.008, SQL: 9