linux 离线安装mysql

下载安装包

http://dev.mysql.com/downloads/mysql/#downloads

网盘连接

  链接：https://pan.baidu.com/s/1UmLw1ajdc2jYsL0jPSK4Aw 
提取码：9cta

解压包 

[root@host /]# cat /etc/group | grep mysql
mysql:x:1001:
[root@host /]# cat /etc/passwd | grep mysql
mysql:x:987:1001::/home/mysql:/bin/bash

 tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz 

将解压后的文件夹移动到/usr/local下并重命名

mv mysql-5.7.29-linux-glibc2.12-x86_64 mysql

mv mysql /usr/local

创建mysql 的 data目录

mkdir /usr/local/mysql/data/

将mysql及其下所有的目录所有者和组均设为mysql

chown -R mysql:mysql /usr/local/mysql/

新建my.cnf文件,文件路径为/etc/my.cnf

 

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
init-connect='SET NAMES utf8'
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
max_connections=50
character-set-server=utf8
default-storage-engine=INNODB

添加执行权限

chmod +x /usr/local/mysql/bin/*

 初始化mysql,默认没有密码

cd /usr/local/mysql
bin/mysqld --initialize-insecure --user=mysql  --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

修改mysql相关文件夹权限 

chown -R root:root /usr/local/mysql/

chown -R mysql:mysql /usr/local/mysql/data/

启动mysql 

cd /usr/local/mysql/support-files
./mysql.server start

 登录

cd /usr/local/mysql/bin

./mysql -u root -p

选择数据库 

use mysql

修改密码

update user set authentication_string=password('设置的密码') where user='root';

设置外网可以访问

cd /usr/local/mysql/bin/
./mysql -uroot -p

选择数据库
use mysql;

查看mysql可以访问的地址
select host,user from user;
如果user为root，host为localhost的话，说明mysql只允许本机连接，那么外网，本地软件客户端就无法连接了。
调整方法：
update user set host='%' where user ='root';
flush privileges;

cd /usr/local/mysql/support-files
#状态
./mysql.server status
#启动
./mysql.server start
#关闭
./mysql.server stop