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