服务器安装二进制mysql5.7
# 一体化脚本
rpm -e | rpm -qa
groupadd mysql
useradd -g mysql mysql
tar -zxvf mysql-5.7.41-el7-x86_64.tar.gz -C /opt/
mv /opt/mysql-5.7.41-el7-x86_64 /usr/local/mysql
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
./mysqld_safe --user=mysql &
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
# 将mysqld服务加入到系统服务
chkconfig --add mysql
# 检查mysqld服务是否已经生效
chkconfig --list mysql
chkconfig mysql on
mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
cat /proc/version
rpm -qa|grep mysql
cd /usr/local/
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
tar -xvf mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
rm -rf mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.16-linux-glibc2.5-x86_64/ mysql
groupadd mysql
useradd -r -g mysql mysql
vim /etc/my.cnf
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql --initialize
cat /data/mysql/mysql.err
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
./mysql -uroot -P15027 -p
use mysql
alter user 'root'@'localhost' IDENTIFIED BY '123456';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# rpm安装方式
1
编辑 (opens new window)