mysql5.7.20+初始化_mysql5.7 部署, 初始化和创建实例

mysql5.7 部署, 初始化和创建实例

很简单的流程

环境信息:centos7.2

mysql5.7.21

1. 下载解压缩 mysql 包cd/usr/local/

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

tar xzvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

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

2. 初始化 mysql 基础环境信息

vim /etc/profilePATH=/home/mysql/bin:/home/mysql/lib:$PATH

exportPATH

exportMYSQL_HOME="/usr/local/mysql"

exportms="/usr/local/mysql"

3. 初始化配置实例配置文件mkdir-p/usr/local/mysql/data/mcdb

vi/usr/local/mysql/data/mcdb/my.cnf

[client]

port=3310

socket=/usr/local/mysql/data/mcdb/mysql.sock

[mysql]

no-auto-rehash

[mysqld]

user=mysql

port=3310

socket=/usr/local/mysql/data/mcdb/mysql.sock

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

pid-file=/usr/local/mysql/data/mcdb/mysql.pid

relay-log=/usr/local/mysql/data/mcdb/relay-bin

relay-log-info-file=/usr/local/mysql/data/mcdb/relay-log.info

server-id=12

[mysqld_safe]

log-error=/usr/local/mysql/data/mcdb/mysql.err

pid-file=/usr/local/mysql/data/mcdb/mysql.pid

4. 新建用户groupadd mysql

useradd mysql-g mysql

chown mysql:mysql/usr/loca/mysql-R

5. 初始化 mysql 实例

mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/mcdb --user=mysql --ldata=/usr/local/mysql

从返回信息最后一行获得密码, 举个栗子:

yUlta1lw*uwF

6. 启动该实例 mysql

mysqld_safe --defaults-file=/usr/local/mysql/data/mcdb/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/mcdb &

7. 登录 mysql

mysql -uroot -pyUlta1lw*uwF -S /usr/local/mysql/data/mcdb/mysql.sock

8. 设定密码mysql>SET PASSWORD=PASSWORD('sonyw320');

mysql>flush privileges;

9. 创建用户并开放远程登录权限

grant all privileges on *.* to 'bodie'@'%' identified by 'happybirthday' with grant option;

来源: http://www.bubuko.com/infodetail-2567573.html