mysql-二进制安装方式

1. 安装组件即依赖包

2. 创建用户

3. 关闭防火墙

mysql%E4%BA%8C%E8%BF%9B%E5%88%B6%E6%BA%90%E7%A0%81%E5%8C%85-toc" style="margin-left:120px;">4. 解压mysql二进制源码包

5. 创建文件夹并赋予权限

mysql%EF%BC%8C%E5%AE%89%E8%A3%85%E5%AE%8C%E6%88%90%E6%9C%80%E5%90%8E%E9%9D%A2%EF%BC%8C%E4%BC%9A%E6%9C%89%E4%B8%80%E4%B8%B2%E8%8B%B1%E6%96%87%EF%BC%8C%E9%82%A3%E6%98%AF%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%AF%86%E7%A0%81-toc" style="margin-left:120px;">6. 编译安装mysql，安装完成最后面，会有一串英文，那是登录数据库的密码

7. 设置配置文件

mysql%E6%B7%BB%E5%8A%A0%E8%BF%9B%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8F-toc" style="margin-left:120px;">8. 将mysql添加进环境变量

9. 复制文件并赋予权限

mysqld.service%E6%9C%8D%E5%8A%A1%E6%96%87%E4%BB%B6-toc" style="margin-left:120px;">10. 编辑生成mysqld.service服务文件

mysql-toc" style="margin-left:120px;">11. 开启mysql

mysql%E5%B9%B6%E4%BF%AE%E6%94%B9%E5%AF%86%E7%A0%81-toc" style="margin-left:120px;">12. 登录到mysql并修改密码

1. 安装组件即依赖包

yum install -y gcc gcc-c++ net-tools lrzsz libaio

2. 创建用户

useradd -M -s /sbin/nologin mysql

3. 关闭防火墙

systemctl stop firewalld
setenforce 0

mysql%E4%BA%8C%E8%BF%9B%E5%88%B6%E6%BA%90%E7%A0%81%E5%8C%85">4. 解压mysql二进制源码包

tar zxf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql

5. 创建文件夹并赋予权限

mkdir /usr/local/mysql/data
chown -R mysql.mysql /usr/local/mysql/d
chown -R mysql.mysql /usr/local/mysql/data/
cd /usr/local/mysql/bin/

mysql%EF%BC%8C%E5%AE%89%E8%A3%85%E5%AE%8C%E6%88%90%E6%9C%80%E5%90%8E%E9%9D%A2%EF%BC%8C%E4%BC%9A%E6%9C%89%E4%B8%80%E4%B8%B2%E8%8B%B1%E6%96%87%EF%BC%8C%E9%82%A3%E6%98%AF%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%AF%86%E7%A0%81">6. 编译安装mysql，安装完成最后面，会有一串英文，那是登录数据库的密码

./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data –initialize

root@localhost:这一串后面就是密码

h.uuplceh1Ir    //这是我的密码

7. 设置配置文件

vim /etc/my.cnf[client]
socket=/usr/local/mysql/data/mysql.sock[mysqld]
socket=/usr/local/mysql/data/mysql.sock
bind-address = 0.0.0.0
skip-name-resolve
port = 3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
max_connections=2048
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M

mysql%E6%B7%BB%E5%8A%A0%E8%BF%9B%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8F">8. 将mysql添加进环境变量

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
. /etc/profile

9. 复制文件并赋予权限

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

mysqld.service%E6%9C%8D%E5%8A%A1%E6%96%87%E4%BB%B6">10. 编辑生成mysqld.service服务文件

vim /lib/systemd/system/mysqld.service[Unit]
Description=mysqld
After=network.target[Service]
Type=forking
ExecStart=/etc/rc.d/init.d/mysqld start
ExecReload=/etc/rc.d/init.d/mysqld restart
ExecStop=/etc/rc.d/init.d/mysqld stop
PrivateTmp=true[Install]
WantedBy=multi-user.target

mysql">11. 开启mysql

systemctl daemon-reload
systemctl enable mysqld
systemctl start mysqld
netstat -nultp | grep 3306

mysql%E5%B9%B6%E4%BF%AE%E6%94%B9%E5%AF%86%E7%A0%81">12. 登录到mysql并修改密码

mysql -u root -ph.uuplceh1Ir
mysqladmin -u root -p'h.uuplceh1Ir' password 'ABCabc-123'