【MYSQL安装】mysql 5.6在centos6.4上的安装

时间:2021-02-26 10:23:49

1.卸载系统自带的mysql

[root@zhangmeng ~]# rpm -qa |grep mysql
mysql
-libs-5.1.66-2.el6_3.x86_64
[root@zhangmeng
~]#
[root@zhangmeng
~]# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64;
error: Failed dependencies:
libmysqlclient.so.
16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.
16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
mysql
-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
[root@zhangmeng
~]#
[root@zhangmeng
~]# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 --nodeps;
[root@zhangmeng
~]#
[root@zhangmeng
~]#
[root@zhangmeng
~]# rpm -qa |grep mysql

2.下载mysql安装包,需要安装wget用 yum -y install wget

[root@zhangmeng ~]# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
-bash: wget: command not found
[root@zhangmeng
~]#
[root@zhangmeng
~]#
[root@zhangmeng
~]# yum -y install wget
Loaded plugins: fastestmirror
Determining fastest mirrors
* base: mirrors.cn99.com
* extras: mirrors.cn99.com
* updates: mirrors.sohu.com
base
| 3.7 kB 00:00
extras
| 3.4 kB 00:00
updates
| 3.4 kB 00:00
updates
/primary_db | 2.5 MB 00:08

3.再次下载

[root@zhangmeng ~]# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
--2017-08-18 11:49:03-- http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com... 104.102.164.25
Connecting to repo.mysql.com
|104.102.164.25|:80... connected.
HTTP request sent, awaiting response...
200 OK
Length:
5824 (5.7K) [application/x-redhat-package-manager]
Saving to:
?.ysql-community-release-el6-5.noarch.rpm?

100%[==============================================>] 5,824 --.-K/s in 0.001s

2017-08-18 11:49:03 (9.44 MB/s) - ?.ysql-community-release-el6-5.noarch.rpm?.saved [5824/5824]

[root@zhangmeng
~]# ls
anaconda
-ks.cfg install.log.syslog
install.log mysql-community-release-el6-5.noarch.rpm
[root@zhangmeng
~]#

4.安装

[root@zhangmeng ~]# rpm -ivh mysql-community-release-el6-5.noarch.rpm 
Preparing... ########################################### [
100%]
1:mysql-community-release########################################### [100%]
[root@zhangmeng
~]#
[root@zhangmeng
~]# rpm -qa |grep -i mysql
mysql
-community-release-el6-5.noarch

5.安装mysql数据库

[root@zhangmeng ~]# yum install mysql-community-server -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.cn99.com
* extras: mirrors.cn99.com
* updates: mirrors.sohu.com
mysql
-connectors-community | 2.5 kB 00:00
mysql
-connectors-community/primary_db | 16 kB 00:00
mysql
-tools-community | 2.5 kB 00:00
mysql
-tools-community/primary_db | 36 kB 00:00
mysql56
-community | 2.5 kB 00:00
mysql56
-community/primary_db | 190 kB 00:00
Setting up Install Process
......
......
========================================================================================
 Package                    Arch       Version              Repository             Size
========================================================================================
Installing:
 mysql-community-server     x86_64     5.6.37-2.el6         mysql56-community      55 M
Installing for dependencies:
 libaio                     x86_64     0.3.107-10.el6       base                   21 k
 mysql-community-client     x86_64     5.6.37-2.el6         mysql56-community      18 M
 mysql-community-common     x86_64     5.6.37-2.el6         mysql56-community     308 k
 mysql-community-libs       x86_64     5.6.37-2.el6         mysql56-community     1.9 M
 numactl                    x86_64     2.0.9-2.el6          base                   74 k
 perl                       x86_64     4:5.10.1-144.el6     base                   10 M
 perl-DBI                   x86_64     1.609-4.el6          base                  705 k
 perl-Module-Pluggable      x86_64     1:3.90-144.el6       base                   41 k
 perl-Pod-Escapes           x86_64     1:1.04-144.el6       base                   33 k
 perl-Pod-Simple            x86_64     1:3.13-144.el6       base                  213 k
 perl-libs                  x86_64     4:5.10.1-144.el6     base                  579 k
 perl-version               x86_64     3:0.77-144.el6       base                   52 k

Transaction Summary
========================================================================================
Install      13 Package(s)

Total download size: 86 M
Installed size: 373 M
Downloading Packages:
(1/13): libaio-0.3.107-10.el6.x86_64.rpm                         |  21 kB     00:00     
(2/13): mysql-community-client-5.6.37-2.el6.x86_64.rpm           |  18 MB     00:17     
(3/13): mysql-community-common-5.6.37-2.el6.x86_64.rpm           | 308 kB     00:01     
(4/13): mysql-community-libs-5.6.37-2.el6.x86_64.rpm             | 1.9 MB     00:03     
(5/13): mysql-community-server-5.6.37-2.el6.x86_64.rpm           |  55 MB     00:49     
(6/13): numactl-2.0.9-2.el6.x86_64.rpm                           |  74 kB     00:00     
(7/13): perl-5.10.1-144.el6.x86_64.rpm                           |  10 MB     00:04     
(8/13): perl-DBI-1.609-4.el6.x86_64.rpm                          | 705 kB     00:00     
(9/13): perl-Module-Pluggable-3.90-144.el6.x86_64.rpm            |  41 kB     00:00     
(10/13): perl-Pod-Escapes-1.04-144.el6.x86_64.rpm                |  33 kB     00:00     
(11/13): perl-Pod-Simple-3.13-144.el6.x86_64.rpm                 | 213 kB     00:00     
(12/13): perl-libs-5.10.1-144.el6.x86_64.rpm                     | 579 kB     00:00     
(13/13): perl-version-0.77-144.el6.x86_64.rpm                    |  52 kB     00:00     
----------------------------------------------------------------------------------------
......
......
Installed:
  mysql-community-server.x86_64 0:5.6.37-2.el6                                          

Dependency Installed:
  libaio.x86_64 0:0.3.107-10.el6                                                        
  mysql-community-client.x86_64 0:5.6.37-2.el6                                          
  mysql-community-common.x86_64 0:5.6.37-2.el6                                          
  mysql-community-libs.x86_64 0:5.6.37-2.el6                                            
  numactl.x86_64 0:2.0.9-2.el6                                                          
  perl.x86_64 4:5.10.1-144.el6                                                          
  perl-DBI.x86_64 0:1.609-4.el6                                                         
  perl-Module-Pluggable.x86_64 1:3.90-144.el6                                           
  perl-Pod-Escapes.x86_64 1:1.04-144.el6                                                
  perl-Pod-Simple.x86_64 1:3.13-144.el6                                                 
  perl-libs.x86_64 4:5.10.1-144.el6                                                     
  perl-version.x86_64 3:0.77-144.el6                                                    

Complete!
[root@zhangmeng ~]#

6.查看安装后的mysql

[root@zhangmeng ~]# rpm -qa |grep -i mysql
mysql
-community-release-el6-5.noarch
mysql
-community-common-5.6.37-2.el6.x86_64
mysql
-community-server-5.6.37-2.el6.x86_64
mysql
-community-libs-5.6.37-2.el6.x86_64
mysql
-community-client-5.6.37-2.el6.x86_64
[root@zhangmeng
~]#

 7.将mysql设置为开机启动

[root@zhangmeng ~]# chkconfig --list |grep mysqld
mysqld
0:off 1:off 2:off 3:on 4:on 5:on 6:off
[root@zhangmeng
~]#
[root@zhangmeng
~]# chkconfig mysqld on
[root@zhangmeng
~]#
[root@zhangmeng
~]# chkconfig --list |grep mysqld
mysqld
0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@zhangmeng
~]#

8.重启mysql服务

[root@zhangmeng ~]# mysqladmin -u root password 'root'
mysqladmin: connect to server at
'localhost' failed
error:
'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@zhangmeng
~]#
[root@zhangmeng
~]#
[root@zhangmeng
~]#
[root@zhangmeng
~]# service mysqld restart
Stopping mysqld: [ OK ]
......
......

9.配置mysql root 用户密码

[root@zhangmeng ~]# mysqladmin -u root password '123456'
Warning: Using a password on the command line interface can be insecure.
[root@zhangmeng
~]#

10.修改 mysql root 用户密码,下面新密码是以明文形式显示,故提示警告,建议采用密文形式

Warning: Using a password on the command line interface can be insecure.警告:在命令行界面上使用密码可能是不安全的。
[root@zhangmeng ~]# mysqladmin -uroot -p123456 password abc123
Warning: Using a password on the command line interface can be insecure.
[root@zhangmeng
~]#

11.登录mysql,查看root账号信息,修改密码后,再次查看root账号信息

[root@zhangmeng ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
id is 7
Server version:
5.6.37 MySQL Community Server (GPL)

Copyright (c)
2000, 2017, 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
>
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
>mysql> select Host,User,Password from user where User='root';
+-----------------------+------+-------------------------------------------+
| Host                  | User | Password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *6691484EA6B50DDDE1926A220DA01FA9E575C18A |
| zhangmeng.example.com | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
+-----------------------+------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql> update user set password =password(123456) where user='root';
Query OK, 4 rows affected (0.28 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select Host,User,Password from user where User='root';
+-----------------------+------+-------------------------------------------+
| Host                  | User | Password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| zhangmeng.example.com | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 127.0.0.1             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| ::1                   | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------------------+------+-------------------------------------------+