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