mysql5.7
1.bin/mysqld --defaults-file=./my.cnf --initialize-insecure --user=root
2.bin/mysqld_safe --defaults-file=./my.cnf --user=root &
=================配置文件==========================
[client]
port = 3316
socket = /tmp/mysql/mysql57.sock
# 设置mysql客户端的字符集
default-character-set=utf8
[mysqld]
skip-grant-tables
basedir = /usr/local/mysql57
datadir = /usr/local/mysql57/data
port = 3316
# server_id = .....
socket = /tmp/mysql/mysql57.sock
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
pid-file=/usr/local/mysql57/mysql57.pid
log-error=/usr/local/mysql57/data/error57.log
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
=================配置文件==========================
================脚本=====================
[mysql5.7ServerStart.sh]
cd /usr/local/mysql57/
bin/mysqld_safe --defaults-file=/usr/local/mysql57/my.cnf --user=root & > /dev/null 2>&1
[mysql5.7ServerStop.sh]
cd /usr/local/mysql57/
bin/mysqladmin --defaults-file=/usr/local/mysql57/my.cnf -u root -p shutdown
[mysql5.7ShellStart.sh]
cd /usr/local/mysql57/
bin/mysql --defaults-file=./my.cnf -u root -p
修改用户密码:
使用mysql中的mysql数据库: mysql> use mysql;
修改密码: update user set authentication_string = password("root123") where user="root" ;
刷新数据库: flush privileges;
创建用户同时授权:
grant all privileges on gqp.* to 'cuggqp'@'%' identified by 'cuggqp3336';
flush privileges;
mysq5.6
1../scripts/mysql_install_db --user=root --datadir=/usr/local/mysql56/data --basedir=/usr/local/mysql56
2.bin/mysqld_safe --defaults-file=/usr/local/mysql56/my.cnf --user=root &
=================配置文件==========================
[client]
port = 3306
socket = /tmp/mysql/mysql56.sock
# 设置mysql客户端的字符集
default-character-set=utf8
[mysqld]
skip-grant-tables
basedir = /usr/local/mysql56
datadir = /usr/local/mysql56/data
port = 3306
# server_id = .....
socket = /tmp/mysql/mysql56.sock
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
pid-file=/usr/local/mysql56/mysql56.pid
log-error=/usr/local/mysql56/data/error56.log
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
=================配置文件==========================