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 ?CR mysql .

#chgrp ?CR 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 ?Cp

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