VMWare linux mysql 5.7.13安装配置教程

# mkdir /tools# cd /tools

#wget http://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

# tar -xzf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

# cd /# mkdir data# cd /data# mkdir mysql

# groupadd mysql# useradd -r -s /sbin/nologin -g mysql mysql -d /tools/mysql-5.7.13-linux-glibc2.5-x86_64

#cd/tools/mysql-5.7.13-linux-glibc2.5-x86_64#pwd#chown –R mysql .#chgrp –R mysql .#chown -R mysql /data/mysql

# bin/mysqld --initialize --user=mysql --basedir=/tools/mysql-5.7.13-linux-glibc2.5-x86_64 --datadir=/data/mysql

#bin/mysql_ssl_rsa_setup --datadir=/data/mysql

# cd support-files

# cp my-default.cnf /etc/my.cnf# cp mysql.server /etc/init.d/mysql

# vim /etc/init.d/mysql

# vim /etc/my.cnf

# bin/mysqld_safe --user=mysql &

bin/mysql --user=root –p

mysql> set password=password('123456'); --输入新密码

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';mysql> flush privileges;

mysql> use mysql;mysql> select host,user from user;mysql> exit;

# vim /etc/profile

# source /etc/profile

# chmod 755 /etc/init.d/mysql# chkconfig --add mysql# chkconfig --level 345 mysql on