centos6.6 下安装mysql5.7-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

centos6.6 下安装mysql5.7

简介: 背景 没啥好说的,就是需要搭建自己的测试数据库跟研发的数据隔离开来,需要怼mysql 这个方法只适合mysql5.7 # mysql5.6的有差异   步骤 1. 确认线上mysql的版本 SELECT VERSION(); 2.

背景

没啥好说的,就是需要搭建自己的测试数据库跟研发的数据隔离开来,需要怼mysql

这个方法只适合mysql5.7

# mysql5.6的有差异

 

步骤

1. 确认线上mysql的版本

SELECT VERSION();

2. 确认安装方式,其实yum命令也可以直接安装,厉害了,但这样安装的话,配置不方便,一般不推荐,直接用tar.gz包来安装吧

3 .创建源包目录

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

4. 下载源

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

5.解压

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

 

 

6.解压mysql包

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

 

7. 创建软链接

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

 

8. 创建数据库目录

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

 

9.MYSQL初始化

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

 

此处需要注意记录生成的临时密码,如上文:YLi>7ecpe;YP

 

10.SSL配置

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

 

11.修改配置文件,需要root权限

 

# 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

 

12.切换root用户(执行完后,退出到nemo用户)

创建目录  

mkdir -p /usr/local/mysql/bin

创建目录  

mkdir -p /usr/local/mysql/data

修改目录用户/目录组

chown -R jwen:jwen /usr/local/mysql

修改配置文件的用户与组:

chown jwen:jwen /etc/my.cnf

 

13.创建软连接

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

 

14.启动mysql

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

15.登录mysql

 ./mysql --user=root -p

--输入第7步生成的临时密码

 

16.修改密码

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

 

密码为rootP@123

 

17.修改root用户的权限

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

 

18.验证

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

 

 

19.创建用户

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;

这样就会有一个guest/guest的账号

 

20.  执行过程中请自己留意目录,哈哈哈 ,执行命令一般在mysql下的bin目录

 

虽千万人,吾往矣!

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章
最新文章
相关文章