mysql tar包安装简记

简介

    mysql版本5.7.30.

详细配置

/etc/my.cnf

[mysqld]
basedir=/usr/local/soft/app/mysql-5.7.30/
#data目录创建好
datadir=/usr/local/soft/app/mysql-5.7.30/data
port=3306
character-set-server=utf8
#socket目录创建好
socket=/usr/local/soft/app/mysql-5.7.30/socket/mysql.sock

symbolic-links=0

[mysqld_safe]
#musql.log文件创建好
log-error=/usr/local/soft/app/mysql-5.7.30/log/mysql.log
#pid目录创建好
pid-file=/usr/local/soft/app/mysql-5.7.30/pid/mysql.pid

!includedir /etc/my.cnf.d

[client]
#socket目录创建好
socket=/usr/local/soft/app/mysql-5.7.30/socket/mysql.sock

步骤

1、解压 tar zxvf mysql.tar.gz

2、添加mysql用户组、用户 groupadd mysql ,useradd -r -g mysql mysql

3、修改/etc/my.cnf

4、进入bin目录 cd bin ，初始化mysql ./mysqld --defaults-flies=/etc/my.cnf --user=mysql --initialize

5、软连接启动 ln -s /user/local/soft/app/mysql/support-files/mysql.server /etc/init.d/mysql

6、客户端连接bin/mysql -uroot -p初始化的密码，修改密码 set password='123456'

7、查看是否放开远程访问 use mysql,select user,host from user,没放开update user set host='%' where user = 'root'

8、给root授权grant all privileges on *.* to root@'%' identified by '123456',flush pribileges