鱼C论坛

 找回密码
 立即注册

centos7.0+mysql5.6+mysql5.7

已有 218 次阅读2019-8-16 14:25 |个人分类:Linux| mysql

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 
=================配置文件==========================




路过

鸡蛋

鲜花

握手

雷人

全部作者的其他最新日志

评论 (0 个评论)

facelist

您需要登录后才可以评论 登录 | 立即注册

小黑屋|手机版|Archiver|鱼C工作室 ( 粤ICP备18085999号-1 | 粤公网安备 44051102000585号)

GMT+8, 2024-3-28 17:54

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

返回顶部