centos 6/7 tar包安装mysql 5.7
2023-09-14 09:08:39 时间
操作系统Centos 6.10 64位
Mysql 版本 5.7.27 , 从官网下载
- 该教程是Mysql shell安装脚本,脚本运行结束后需要重置密码,以及必要的授权操作等
- 该教程对外端口设置为50000
- 该教程Mysql 的BASE 路径是 /usr/local/mysql/app/mysql
- 该教程Mysql 的 DATA 路径是 /usr/local/mysql/data/
#!/bin/bash
yum install wget numactl libaio-devel -y
rpm -qa |grep mysql
mkdir /usr/local/mysql
mkdir -p /usr/local/mysql/app
mkdir -p /usr/local/mysql/data/
mkdir -p /usr/local/mysql/log/
cd /usr/local/src/
#wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
wget -O mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz http://download.zhufunin.com/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv /usr/local/src/mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql/app/mysql
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
cat > /etc/my.cnf <<EOF
[client]
default-character-set=utf8
socket=/tmp/mysql.sock
[mysqld]
#skip-name-resolve
port = 50000
socket = /tmp/mysql.sock
basedir = /usr/local/mysql/app/mysql
datadir= /usr/local/mysql/data/
character-set-server=utf8
skip-character-set-client-handshake=1
default-storage-engine=INNODB
max_allowed_packet = 500M
explicit_defaults_for_timestamp=1
log-output=FILE
general_log=0
general_log_file=/usr/local/mysql/log/general.log
slow_query_log = ON
slow_query_log_file = /usr/local/mysql/log/slow-query.log
long_query_time = 10
log-error = /usr/local/mysql/log/error.log
EOF
chown -R mysql:mysql /usr/local/mysql/
/usr/local/mysql/app/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql/app/mysql/ --datadir=/usr/local/mysql/data/
cp /usr/local/mysql/app/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod a+x /etc/init.d/mysqld
chkconfig --add mysqld
service mysqld start
ln -s /usr/local/mysql/app/mysql/bin/mysql /usr/local/bin/
echo 'export PATH=$PATH:/usr/local/mysql/app/mysql/bin/' >> /etc/profile
source /etc/profile
echo "***************************"
echo "***************************"
echo "Please read below carefully"
echo "***************************"
echo "***************************"
echo "You must change your root password before you do anythings"
echo "Below is your password"
echo "###########################"
tail -1000 /usr/local/mysql/log/error.log|grep 'temporary password'|awk -F ':' '{print $4}'|awk '{print $1}'|tail -1
echo "###########################"
echo "mysql -hlocalhost -uroot -p"
echo "ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourNewPassword';"
echo "***************************"
echo "After you changed your passowrd, you can change root access right by follow commands"
echo "***************************"
echo "use mysql;"
echo "select host,user from user where user='root';"
echo "create USER 'root'@'%' IDENTIFIED BY 'YourPassword';"
echo "grant all privileges on *.* to 'root'@'%' with grant option;"
相关文章
- 安装MySQL在Win10上快速又安全(win10安装mysql)
- MySQL中的 IF 条件语句的应用(mysql中if的用法)
- MySQL安装遇到的问题及解决方案(mysql安装出问题)
- MYSQL安装路径:精准设置指南(mysql的安装路径设置)
- MySQL 绿色安装:一步一步进行(mysql绿色安装)
- MySQL应用程序包安装与下载(mysql架包下载)
- MySQL绿色免安装:轻松搭建专业数据库环境(mysql绿色免安装)
- 存储MySQL数据库:键值存储的优势(mysql数据库键值)
- 使用yum快速安装MySQL数据库(mysql安装yum)
- MySQL查找最大ID的简单方法(mysql 取最大id)
- 如何更改MySQL的安装目录,避免默认安装路径可能会导致磁盘空间不足等问题。(更改mysql的安装目录)
- 架构优化:MySQL实体数据模型实践(实体数据模型mysql)
- MySQL 安装成功:激动人心的消息!(mysql 安装成功)
- MySQL无法添加汉字解决方法分享(mysql中不能添加汉字)
- MySQL中NULL属性为什么它重要(mysql中null属性)
- MySQL查询Oracle的全景观察(mysql查oracle)
- 2018年MySQL论坛 全新的技术研讨与交流(2018年mysql论坛)
- MySQL中如何判断空串(mysql中判断空串)
- MySQL视图详解如何创建和使用视图(mysql中创建视图讲解)
- MySQL的MSI安装程序下载及使用指南(mysql下载msi安装)
- MySQL 32位下载及安装教程(mysql下载32位教程)
- MySQL安装页面不显示的解决方法(mysql不弹出安装页面)
- 简单易懂的MySQL Yum源安装教程(mysql yum源安装)