官方文档
文件说明
| Directory | Contents of Directory |
|---|---|
bin |
mysqld server, client and utility programs |
docs |
MySQL manual in Info format |
man |
Unix manual pages |
include |
Include (header) files |
lib |
Libraries |
share |
Error messages, dictionary, and SQL for database installation |
support-files |
Miscellaneous support files |
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chown mysql:mysql mysql-files
shell> chmod 750 mysql-files
shell> bin/mysqld --initialize --user=mysql
shell> bin/mysql_ssl_rsa_setup
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server
为了方便，建立了以下一系列shell命令(不敢妄称脚本)，当然，也就固化了安装目录为/usr/local/mysql/，数据文件位置/data。请根据需要修改或是直接拍命令。
[root@CentOS712 ~]# vim MySQL_install.sh
3 # Date: 07-05-2019
4 # Comment: install mysql 5.7.26 on el7
5 #********************
6
7 function precheck(){
8 if [ `cat /etc/system-release | awk -F'.' '{print $1}' | cut -d ' ' -f4` -eq 7 ];then
9 echo -e "Your system os is version 7......Succeed!
"
10 else if [ `cat /etc/system-release | awk -F'.' '{print $1}' | cut -d ' ' -f4` -eq 6 ];then
11 echo -e "Your system os is version 6......Failed!
This check is vital, quit forcely!
"
12 exit 1
13 fi
14 fi
15 }
16
17 function process(){
18 echo -e "
Processing......
"
19 useradd -r -u 600 mysql
20 mkdir /data
21 chown -R mysql. /data
22 tar -zxvf $1 -C /usr/local/
23 local var_one=`ls /usr/local/ | grep mysql`
24 ln -s /usr/local/${var_one} /usr/local/mysql
25 chown -R mysql. /usr/local/mysql
26 chown -R mysql. /usr/local/${var_one}
27 /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data
28 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
29 sed -i '45,48s/basedir=/&/usr/local/mysql/' /etc/init.d/mysqld
30 sed -i '45,48s/datadir=/&/data/' /etc/init.d/mysqld
31 echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile.d/mysql_env.sh
32 . /etc/profile.d/mysql_env.sh
33 echo -e "
Processing Down"
34 }
35
36
37 precheck
38 process $1
"MySQL_install.sh" 38L, 1272C
用法： ./MySQL_install.sh mysql-5.7.26-el7-x86_64.tar.gz
终端会显示临时密码
然后
[root@rhel] service mysqld start
[root@CentOS712 ~]# mysql -uroot -p
Enter password: 键入临时密码
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> set password=password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> q
Bye