SELECT VERSION();

mkdir -p /home/jwen/local/mysql-5.7.12

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-linux-glibc2.5-x86_64.tar

tar xvf mysql-5.7.12-linux-glibc2.5-x86_64.tar

tar -xzvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz

ln -s /home/jwen/local/mysql-5.7.12/mysql-5.7.12-linux-glibc2.5-x86_64 /home/jwen/local/mysql

mkdir -p /home/jwen/local/mysql/data/

./mysqld --initialize --user=jwen --basedir=/home/jwen/local/mysql --datadir=/home/jwen/local/mysql/data/

./mysql_ssl_rsa_setup --datadir=/home/jwen/local/mysql/data/

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

# vim /etc/init.d/mysql

basedir=/home/jwen/local/mysql

datadir=/home/jwen/local/mysql/data/

# vim /etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
port=3306
socket=/home/jwen/local/mysql/mysql.sock
#character-set-server=utf8
 
[mysqld]
 
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
 
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
 
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
 
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
socket=/home/jwen/local/mysql/mysql.sock
basedir=/home/jwen/local/mysql
max_allowed_packet=32M
explicit_defaults_for_timestamp=true
skip-ssl
secure-file-priv=NULL
back_log=300
max_connections=3000
max_connect_errors=100
table_open_cache=4096
external-locking=FALSE
###*** slow query parameters
long_query_time=6
slow_query_log
slow_query_log_file=/home/jwen/logs/mysql/slow.log
 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
 
[mysqldump]
quick
max_allowed_packet=32M
 
[mysqld_safe]
open-files-limit=8192
log-error=/home/jwen/logs/mysql/mysql_3306.err

mkdir -p /home/jwen/logs/mysql

ln -s /home/jwen/local/mysql/bin/mysqld /usr/local/mysql/bin/mysqld

 ./mysqld_safe  --defaults-file=/etc/my.cnf --datadir=/home/jwen/local/mysql/data/ --user=mysql &

 ./mysql --user=root -p

mysql> set password=password('rootP@123');

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

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

insert into `user` (`Host`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked`) values('%','guest','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0','0','mysql_native_password','*11DB58B0DD02E290377535868405F11E4CBEFF58','N','2016-05-10 10:16:27',NULL,'N');
commit;
flush privileges;
GRANT ALL PRIVILEGES ON *.* TO guest@'%' IDENTIFIED BY 'guest';
FLUSH PRIVILEGES;