[TOC]
官方文档
文件说明
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!\n"
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!\nThis check is vital, quit forcely!\n"
12 exit 1
13 fi
14 fi
15 }
16
17 function process(){
18 echo -e "\n Processing......\n"
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 "\n 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
网友评论