linux在线安装mysql-5.7.26
在线下载mysql5.7压缩包
[ root@localhost / ] # wget https: / / dev. mysql. com/ get/ Downloads/ MySQL- 5.7 / mysql- 5.7 .26 - linux- glibc2. 12 - x86_64. tar. gz
解压mysql5.7压缩包
[ root@localhost / ] # tar - xvf mysql- 5.7 .26 - linux- glibc2. 12 - x86_64. tar. gz
移动mysql5.7压缩包
[ root@localhost / ] # mv mysql- 5.7 .26 - linux- glibc2. 12 - x86_64 / usr/ local/
改名
[ root@localhost / ] # cd / usr/ local/
[ root@localhost local] # mv mysql- 5.7 .26 - linux- glibc2. 12 - x86_64/ mysql- 5.7 .26
创建mysql组和用户
[ root@localhost local] # groupadd mysql
[ root@localhost local] # useradd - r - g mysql mysql
创建mysql data目录赋予权限
[ root@localhost local] # mkdir - p / data/ mysql #创建目录
[ root@localhost local] # chown mysql: mysql - R / data/ mysql #赋予权限
配置mysql配置文件(根据自己需求更改)
[ root@localhost / ] # vim / etc/ my. cnf
[ mysqld]
bind- address= 0.0 .0 .0
port= 3306
user= mysql
basedir= / usr/ local/ mysql- 5.7 .26
datadir= / data/ mysql
socket= / tmp/ mysql. sock
log- error= / data/ mysql/ mysql. err
pid- file= / data/ mysql/ mysql. pid
#character config
character_set_server= utf8mb4
symbolic- links= 0
explicit_defaults_for_timestamp= true
lower_case_table_names = 1
sql_mode = NO_ENGINE_SUBSTITUTION , STRICT_TRANS_TABLES
初始化
[ root@localhost local] # cd / usr/ local/ mysql- 5.7 .26 / bin/
[ root@localhost bin] # . / mysqld -- defaults- file= / etc / my . cnf -- basedir= / usr/ local/ mysql- 5.7 .26 / -- datadir= / data/ mysql/ -- user= mysql -- initialize
查看初始密码(root: 后的一串字符是密码)
[ root@localhost bin] # cat / data/ mysql/ mysql. err
将mysql.server放置到/etc/init.d/mysql中
[ root@localhost bin] # cp / usr/ local/ mysql- 5.7 .26 / support- files/ mysql. server / etc/ init. d/ mysql
启动mysql
[ root@localhost bin] # service mysql start
修改密码
[ root@localhost bin] # . / mysql - u root - p #bin目录下
mysql> SET PASSWORD = PASSWORD ( '123456' ) ;
mysql> ALTER USER 'root' @'localhost' PASSWORD EXPIRE NEVER ;
mysql> FLUSH PRIVILEGES ;
退出后重登mysql,执行如下(解决navicat连接不上mysql)
mysql> exit
[ root@localhost bin] # . / mysql - u root - p #bin目录下
mysql> use mysql #访问mysql库
mysql> update user set host = '%' where user = 'root' ; #使root能再任何host访问
mysql> FLUSH PRIVILEGES ;
设置软连接
mysql> exit
[ root@localhost bin] # ln - s / usr/ local/ mysql- 5.7 .26 / bin/ mysql / usr/ bin
配置完后可在任意目录执行登录:mysql - u root - p
注意事项
记得开放3306 端口哦