随笔 - 6  文章 - 129  trackbacks - 0
<2021年4月>
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

常用链接

留言簿(14)

随笔档案(6)

文章分类(467)

文章档案(423)

相册

收藏夹(18)

JAVA

搜索

  •  

积分与排名

  • 积分 - 736993
  • 排名 - 57

最新评论

阅读排行榜

评论排行榜

原文:http://blog.csdn.net/u013980127/article/details/52261400

1. 下载安装包

http://dev.mysql.com/downloads/mysql/5.7.html#downloads 
mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz

2. 检查库文件是否存在,如有删除。

[root@slave ~]# rpm -qa | grep mysql 
mysql-libs-5.1.71-1.el6.x86_64
[root@slave ~]# rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps
[root@slave ~]# rpm -qa | grep mysql
  • 1
  • 2
  • 3
  • 4

3. 检查mysql组和用户是否存在,如无创建。

[root@slave ~]# cat /etc/group | grep mysql 
[root@slave ~]# cat /etc/passwd | grep mysql
// useradd -r参数表示mysql用户是系统用户,不可用于登录系统。
[root@slave ~]# groupadd mysql
[root@slave ~]# useradd -r -g mysql mysql
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

4. 解压TAR包,更改所属的组和用户

[root@slave zkpk]# cd /usr/local/ 
[root@slave local]# tar -xf mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
[root@slave local]# mv mysql-5.7.14-linux-glibc2.5-x86_64 mysql
[root@slave local]# ll
total 628304 drwxr-xr-x. 2 root root 4096 Sep 23 2011 bin drwxr-xr-x. 2 root root 4096 Sep 23 2011 etc drwxr-xr-x. 2 root root 4096 Sep 23 2011 games drwxr-xr-x. 2 root root 4096 Sep 23 2011 include drwxr-xr-x. 8 root root 4096 Sep 27 2014 jdk1.7.0_71 drwxr-xr-x. 8 root root 4096 Apr 11 2015 jdk1.8.0_45 drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib drwxr-xr-x. 2 root root 4096 Sep 23 2011 lib64 drwxr-xr-x. 2 root root 4096 Sep 23 2011 libexec drwxr-xr-x. 9 7161 31415 4096 Jul 12 21:03 mysql -rw-r--r--. 1 zkpk zkpk 642694570 Aug 20 00:57 mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz drwxr-xr-x. 2 root root 4096 Sep 23 2011 sbin drwxr-xr-x. 5 root root 4096 Jul 30 21:17 share drwxr-xr-x. 2 root root 4096 Sep 23 2011 src
[root@slave local]# rm mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
rm: remove regular file `mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz'? y
[root@slave local]# chown -R mysql:mysql mysql/
[root@slave local]# cd mysql/
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23

5. 安装和初始化数据库

配置OS

sudo vim /etc/security/limits.conf  
mysql hard nofile 65535
mysql soft nofile 65535
  • 1
  • 2
  • 3
  • 4

安装与初始化DB

[root@slave mysql]# bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ 
2016-08-20 01:18:44 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-08-20 01:18:47 [WARNING] The bootstrap log isn't empty:
2016-08-20 01:18:47 [WARNING] 2016-08-19T17:18:44.728642Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2016-08-19T17:18:44.729178Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2016-08-19T17:18:44.729183Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

如果改变默认安装路径,则需要 
1. /etc/my.cnf、/etc/init.d/mysqld中修改: 
basedir=’/apps/mysql’ datadir=’/apps/mysql/data’ 
2. 创建ln: 
mkdir -p /usr/local/mysql/bin

[root@slave mysql]# cp -a ./support-files/my-default.cnf /etc/my.cnf 
[root@slave mysql]# cp -a ./support-files/mysql.server /etc/init.d/mysqld
  • 1
  • 2
[root@slave mysql]# cd bin/ 
[root@slave bin]# ./mysqld_safe --user=mysql &
[1] 2966
[root@slave bin]# 2016-08-19T17:24:36.174662Z mysqld_safe Logging to '/usr/local/mysql/data/slave.err'. 2016-08-19T17:24:36.207209Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
[root@slave bin]#
[root@slave bin]#
[root@slave bin]#
[root@slave bin]#
[root@slave bin]# /etc/init.d/mysqld restart
Shutting down MySQL..2016-08-19T17:25:18.416810Z mysqld_safe mysqld from pid file /usr/local/mysql/data/slave.pid ended [ OK ] Starting MySQL. [ OK ] [1]+ Done ./mysqld_safe --user=mysql [root@slave bin]#
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16

设置开机启动

[root@slave bin]# chkconfig --level 35 mysqld on
  • 1

6. 初始化密码

[root@slave bin]# cat /root/.mysql_secret 
# Password set for user 'root@localhost' at 2016-08-20 01:18:44
eqW;ehX;>-YG
[root@slave bin]# ./mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.14 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD = PASSWORD('123456'); Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22

7. 添加远程访问权限

mysql> use mysql;  Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A   Database changed mysql> update user set host = '%' where user = 'root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1  Changed: 1  Warnings: 0   mysql> select host, user from user; +-----------+-----------+ | host      | user      | +-----------+-----------+ | %         | root      | | localhost | mysql.sys | +-----------+-----------+  //重启生效 /etc/init.d/mysqld restart
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21

8. 修改字符集

[root@slave mysql]# vim /etc/my.cnf   [mysqld] ...略 character-set-server=utf8  //重启生效 /etc/init.d/mysqld restart
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

9. linux下mysql配置文件my.cnf详解

http://www.cnblogs.com/captain_jack/archive/2010/10/12/1848496.html

10. 卸载MySQL

# 1. 停止服务 /etc/init.d/mysqld stop  
# 2. 停止并删除开机启动 chkconfig mysqld off chkconfig --del mysqld
# 3. 删除MySQL目录 rm -rf /usr/local/mysql rm -f /etc/my.cnf rm -f /etc/init.d/mysqld rm -f /root/.mysql_secret
# 4. 删除用户和用户组 userdel -r mysql


posted on 2018-03-22 10:22 Ke 阅读(55) 评论(0)  编辑  收藏 所属分类: linux