MySQL-5.7.28二进制安装

最新推荐文章于 2024-07-04 02:10:07 发布

不想敲代码的运维

最新推荐文章于 2024-07-04 02:10:07 发布

阅读量375

点赞数 1

分类专栏：数据库DBA 文章标签： mysql linux 数据库

本文链接：https://blog.csdn.net/qq_16942727/article/details/104258614

版权

数据库DBA 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

安装条件

#卸载系统默认自带数据库
[root@localhost ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
[root@localhost ~]# rpm -ef mariadb-libs-5.5.64-1.el7.x86_64 --nodeps
[root@localhost ~]# rpm -qa |grep mariadb

MySQL部署

[root@localhost ~]# cd /opt/
[root@localhost opt]# wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# ls
mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# tar xf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@localhost opt]# mv /usr/local/mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost opt]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
[root@localhost opt]# source /etc/profile

创建MySQL用户

[root@localhost opt]# useradd -s /sbin/nologin mysql -M

初始化数据

[root@localhost opt]# mkdir /usr/local/mysql/data
#--initialize是开启临时密码、安全策略
[root@localhost opt]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@localhost opt]# chown -R mysql.mysql /usr/local/mysql/

配置文件

[root@localhost opt]# vim /etc/my.cnf
[mysqld]
user=mysql
bind-address=0.0.0.0
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
server_id=1
[mysql]
socket=/tmp/mysql.sock

添加systemd管理启动

[root@localhost opt]# vim /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
[root@localhost opt]# systemctl start mysqld.service
[root@localhost opt]# systemctl enable mysqld.service

设置root登录密码

[root@localhost ~]# mysqladmin password '000000'
[root@localhost ~]# mysql -uroot -p000000
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.28 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>