MySQL8.0.25安装（linux直装）设置开机启动修改密码具体操作

65 阅读 0 评论 43 点赞

我是靠谱客的博主清爽战斗机，最近开发中收集的这篇文章主要介绍MySQL8.0.25安装（linux直装）设置开机启动修改密码具体操作，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

1.先清理linux系统中存在的mysql

#!/bin/bash
rpm -qa|grep mysql
echo 请使用
echo rpm -e --nodeps mysql-libs-5.1.73-5.eXXXXX
echo 执行删除，确保上方展示内容全部删除。
echo ""
whereis mysql
echo 请使用
echo rm -rf XXX
echo 执行删除，确保上方展示内容全部删除。
echo ""
find / -name mysql
echo 请使用
echo rm -rf XXXXX
echo 执行删除，确保上方展示内容全部删除（不要误删自己传上去的文件）。
echo ""
ps -ef|grep mysql
echo 请使用
echo kill -9 XXXXX
echo 执行删除，确保上方展示内容全部删除。
echo ""

2.将my.cnf文件放入系统

# Example MySQL config file for small systems.  
#  
# This is for a system with little memory (<= 64M) where MySQL is only used  
# from time to time and it's important that the mysqld daemon  
# doesn't use much resources.  
#  
# MySQL programs look for option files in a set of  
# locations which depend on the deployment platform.  
# You can copy this option file to one of those  
# locations. For information about these locations, see:  
# http://dev.mysql.com/doc/mysql/en/option-files.html  
#  
# In this file, you can use all long options that a program supports.  
# If you want to know which options a program supports, run the program  
# with the "--help" option.  
 
# The following options will be passed to all MySQL clients  
[client]  
default-character-set=utf8  
#password    = 123456
port        = 3306 
socket      = /tmp/mysql.sock  
 
# Here follows entries for some specific programs  
 
# The MySQL server   
[mysqld]  
 
#配置mysql的文件夹 和 mysql data目录
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
default-storage-engine=INNODB  
character-set-server=utf8  
collation-server=utf8_general_ci  
port        = 3306 
socket      = /tmp/mysql.sock  
skip-external-locking  
key_buffer_size = 16K  
max_allowed_packet = 1M  
table_open_cache = 4 
sort_buffer_size = 64K  
read_buffer_size = 256K  
read_rnd_buffer_size = 256K  
net_buffer_length = 2K  
thread_stack = 128K  
 
# Don't listen on a TCP/IP port at all. This can be a security enhancement,  
# if all processes that need to connect to mysqld run on the same host.  
# All interaction with mysqld must be made via Unix sockets or named pipes.  
# Note that using this option without enabling named pipes on Windows  
# (using the "enable-named-pipe" option) will render mysqld useless!  
#   
#skip-networking  
server-id   = 1 
 
# Uncomment the following if you want to log updates  
#log-bin=mysql-bin  
 
# binary logging format - mixed recommended  
#binlog_format=mixed  
 
# Causes updates to non-transactional engines using statement format to be  
# written directly to binary log. Before using this option make sure that  
# there are no dependencies between transactional and non-transactional  
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM  
# t_innodb; otherwise, slaves may diverge from the master.  
#binlog_direct_non_transactional_updates=TRUE  
 
# Uncomment the following if you are using InnoDB tables  
#innodb_data_home_dir = /usr/local/mysql/data  
#innodb_data_file_path = ibdata1:10M:autoextend  
#innodb_log_group_home_dir = /usr/local/mysql/data  
# You can set .._buffer_pool_size up to 50 - 80 %  
# of RAM but beware of setting memory usage too high  
#innodb_buffer_pool_size = 16M  
#innodb_additional_mem_pool_size = 2M  
# Set .._log_file_size to 25 % of buffer pool size  
#innodb_log_file_size = 5M  
#innodb_log_buffer_size = 8M  
#innodb_flush_log_at_trx_commit = 1 
#innodb_lock_wait_timeout = 50 
 
[mysqldump]  
quick  
max_allowed_packet = 16M  
 
[mysql]  
no-auto-rehash  
# Remove the next comment character if you are not familiar with SQL  
#safe-updates  
 
[myisamchk]  
key_buffer_size = 8M  
sort_buffer_size = 8M  
 
[mysqlhotcopy]  
interactive-timeout

3.部署指令如下：

#!/bin/bash
groupadd mysql
useradd -r -g mysql mysql
rm -rf /usr/local/mysql
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -P /usr/local/
tar -xvJf /usr/local/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -C /usr/local
mv /usr/local/mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql
yum install  -y libaio-devel.x86_64
yum -y install numactl
rm -rf /usr/local/mysql/data
mkdir /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
cd /usr/local/mysql/bin && ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
echo ""
echo "注意观察上面有临时密码!"
echo ""
rm -rf /etc/my.cnf
cp /opt/my.cnf /etc/
/usr/local/mysql/support-files/mysql.server start
rm -rf /etc/init.d/mysql
rm -rf /usr/bin/mysql
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql restart

设置开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld

修改密码

echo 输入
echo mysql -u root -p
echo "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';"
echo 修改密码
echo 记得开放远程连接

具体操作

echo "use mysql;"
echo "update user set user.Host='%' where user.User='root';"
echo "flush privileges;"

clear.sh

#!/bin/bash
rpm -qa|grep mysql
echo 请使用
echo rpm -e --nodeps mysql-libs-5.1.73-5.eXXXXX
echo 执行删除，确保上方展示内容全部删除。
echo ""
whereis mysql
echo 请使用
echo rm -rf XXX
echo 执行删除，确保上方展示内容全部删除。
echo ""
find / -name mysql
echo 请使用
echo rm -rf XXXXX
echo 执行删除，确保上方展示内容全部删除（不要误删自己传上去的文件）。
echo ""
ps -ef|grep mysql
echo 请使用
echo kill -9 XXXXX
echo 执行删除，确保上方展示内容全部删除。
echo ""

deploy.sh

#!/bin/bash
groupadd mysql
useradd -r -g mysql mysql
rm -rf /usr/local/mysql
#wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -P /usr/local/
tar -xvJf /usr/local/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -C /usr/local
mv /usr/local/mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql
yum install  -y libaio-devel.x86_64
yum -y install numactl
rm -rf /usr/local/mysql/data
mkdir /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
cd /usr/local/mysql/bin && ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
echo ""
echo "注意观察上面有临时密码!"
echo ""
rm -rf /etc/my.cnf
cp /opt/my.cnf /etc/
/usr/local/mysql/support-files/mysql.server start
rm -rf /etc/init.d/mysql
rm -rf /usr/bin/mysql
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql restart

# 设置开机启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld

# 修改密码
echo 输入
echo mysql -u root -p
echo "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';"
echo 修改密码
echo 记得开放远程连接
# 具体操作
echo "use mysql;"
echo "update user set user.Host='%' where user.User='root';"
echo "flush privileges;"