CentOS7.3安装mysql数据库

Love The Way You Lie 2022-02-14 13:19 273阅读 0赞

CentOS7.3安装mysql数据库  
Mysql数据库安装  
1.环境  
操作系统：CentOS 7.3

软件：MySQL 5.7

下载链接：[https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86\_64.tar.gz][https_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz]

2.开始安装  
2.1．安装依赖包  
\[root@i-679DDF88 ~\]\# yum install -y cmake make gcc gcc-c++ libaio ncurses ncurses-devel

2.2 创建mysql用户  
\[root@i-679DDF88 ~\]\# groupadd mysql

\[root@i-679DDF88 ~\]\# useradd -g mysql mysql -s /sbin/nologin

2.3 解压复制安装包  
\[root@i-679DDF88 ~\]\# wget [https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86\_64.tar.gz][https_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz]

\[root@i-679DDF88 ~\]\#tar zxf mysql-5.7.24-linux-glibc2.12-x86\_64.tar.gz

\[root@i-679DDF88 ~\]\# mv mysql-5.7.24-linux-glibc2.12-x86\_64 /usr/local/mysql

2.4修改目录权限  
\[root@i-679DDF88 ~\]\#chown –R mysql:mysql /usr/local/mysql

2.5 初始化数据库  
\[root@i-679DDF88 ~\]\# cd /usr/local/mysql/

\[root@i-679DDF88 mysql\]\# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

这里会生成一个临时密码

2.6生成key  
\[root@i-679DDF88 mysql\]\# bin/mysql\_ssl\_rsa\_setup --datadir=/usr/local/mysql/data

2.7 再次修改mysql目录权限  
\[root@i-679DDF88 local\]\# chown -R mysql:mysql /usr/local/mysql

2.8 修改配置文件  
\[root@i-679DDF88 mysql\]\# vim /etc/my.cnf

\[mysqld\]

character\_set\_server=utf8

init\_connect='SET NAMES utf8'

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock

# 不区分大小写 #

lower\_case\_table\_names = 1

# 不开启sql严格模式 #

sql\_mode = "STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION"

log-error=/var/log/mysqld.log

pid-file=/tmp/mysqld.pid

default\_password\_lifetime=0

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4\_unicode\_ci

init\_connect='SET NAMES utf8mb4'

max\_connections = 5000

max\_connect\_errors = 1000

max\_allowed\_packet = 128M

innodb\_buffer\_pool\_size = 10240M

innodb\_log\_file\_size = 1024M

lower\_case\_table\_names=1

event\_scheduler=ON

skip\_name\_resolve

back\_log=300

user=mysql

server-id=1038003

log-bin=mysql-bin

expire\_logs\_days = 5

binlog\_format = ROW

replicate-wild-ignore-table = information\_schema.%

replicate-wild-ignore-table = mysql.%

replicate-wild-ignore-table = performance\_schema.%

log\_bin\_trust\_function\_creators=1

sync\_binlog = 1

innodb\_flush\_log\_at\_trx\_commit=2

innodb\_file\_per\_table=1

auto\_increment\_increment=2

auto\_increment\_offset=2

# 密码过期时间，默认为180天，0为永不过期 #

default\_password\_lifetime=0

2.9添加系统服务  
\[root@i-679DDF88 mysql\]\# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

\[root@i-679DDF88 mysql\]\#chkconfig --add mysqld

\[root@i-679DDF88 mysql\]\#chkconfig --level mysqld 12345 on

2.10 创建连接文件  
\[root@i-679DDF88 mysql\]\# ln -s /usr/local/mysql/bin/mysql /usr/bin

2.11 启动服务  
\[root@i-679DDF88 mysql\]\# /etc/init.d/mysqld start

2.12 连接数据库修改密码  
\[root@i-679DDF88 mysql\]\# mysql –uroot -p

alter user user() identified by "newpassword";

3.FAQ  
1.查看数据库提示ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

修改密码即可解决  
原文地址[https://www.cnblogs.com/caiqilang/p/10553848.html][https_www.cnblogs.com_caiqilang_p_10553848.html]

[https_cdn.mysql.com_Downloads_MySQL-5.7_mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz]: https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
[https_www.cnblogs.com_caiqilang_p_10553848.html]: https://www.cnblogs.com/caiqilang/p/10553848.html