在centos中安装mysql_在centos中安装mysql详细步骤说明

Last login: Sun Dec 24 04:55:59 2017

1、安装依赖

[root@node001 ~]# yum install -y perl

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

base | 3.7 kB 00:00

extras | 3.4 kB 00:00

updates | 3.4 kB 00:00

Setting up Install Process

Package 4:perl-5.10.1-144.el6.x86_64 already installed and latest version

Nothing to do

2、 卸载旧版本的mysql及插件

[root@node001 ~]# rpm -qa | grep mysql

mysql-5.1.73-8.el6_8.x86_64

mysql-libs-5.1.73-8.el6_8.x86_64

mysql-server-5.1.73-8.el6_8.x86_64

[root@node001 ~]#rpm -e mysql-5.1.73-8.el6_8.x86_64 --nodeps

[root@node001 ~]# rpm -e mysql-libs-5.1.73-8.el6_8.x86_64 --nodeps

[root@node001 ~]# rpm -e mysql-server-5.1.73-8.el6_8.x86_64 --nodeps

(--nodeps:忽略其他依赖，直接卸载)

3、 安装rpm(4个)

安装包

[root@node001 ~]#tar zxvf mysql.tar.gz

MySQL-client-5.6.28-1.el6.x86_64.rpm

MySQL-devel-5.6.28-1.el6.x86_64.rpm

MySQL-server-5.6.28-1.el6.x86_64.rpm

numactl-2.0.9-2.el6.x86_64.rpm

[root@node001 ~]# rpm -ivh MySQL-client-5.6.28-1.el6.x86_64.rpm

warning: MySQL-client-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ########################################### [100%]

1:MySQL-client ########################################### [100%]

[root@node001 ~]# rpm -ivh MySQL-devel-5.6.28-1.el6.x86_64.rpm

warning: MySQL-devel-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ########################################### [100%]

1:MySQL-devel ########################################### [100%]

[root@node001 ~]# rpm -ivh numactl-2.0.9-2.el6.x86_64.rpm

Preparing... ########################################### [100%]

1:numactl ########################################### [100%]

[root@node001 ~]# rpm -ivh MySQL-server-5.6.28-1.el6.x86_64.rpm

warning: MySQL-server-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ########################################### [100%]

1:MySQL-server ########################################### [100%]

2017-12-24 05:39:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestam

p server option (see documentation for more details).2017-12-24 05:39:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28) starting as process 1287 ...

2017-12-24 05:39:08 1287 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-12-24 05:39:08 1287 [Note] InnoDB: The InnoDB memory heap is disabled

2017-12-24 05:39:08 1287 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-12-24 05:39:08 1287 [Note] InnoDB: Memory barrier is not used

2017-12-24 05:39:08 1287 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-12-24 05:39:08 1287 [Note] InnoDB: Using Linux native AIO

2017-12-24 05:39:08 1287 [Note] InnoDB: Using CPU crc32 instructions

2017-12-24 05:39:08 1287 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2017-12-24 05:39:08 1287 [Note] InnoDB: Completed initialization of buffer pool

2017-12-24 05:39:08 1287 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created

.............................

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/my.cnf and

will be used by default by the server when you start it.

You may edit this file to change server settings

4、上传mysql配置文件my.cnf

[root@node001 ~]# cd /etc

上传文件

[root@node001 etc]# ls /etc/my.cnf

/etc/my.cnf

5、初始化

[root@node001 etc]#/usr/bin/mysql_install_db

Installing MySQL system tables...2017-12-24 05:41:57 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-log) starting as process 1353 ...

2017-12-24 05:41:57 1353 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-12-24 05:41:57 1353 [Note] InnoDB: The InnoDB memory heap is disabled

2017-12-24 05:41:57 1353 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-12-24 05:41:57 1353 [Note] InnoDB: Memory barrier is not used

2017-12-24 05:41:57 1353 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-12-24 05:41:57 1353 [Note] InnoDB: Using Linux native AIO

2017-12-24 05:41:57 1353 [Note] InnoDB: Using CPU crc32 instructions

2017-12-24 05:41:57 1353 [Note] InnoDB: Initializing buffer pool, size = 64.0M

2017-12-24 05:41:57 1353 [Note] InnoDB: Completed initialization of buffer pool

2017-12-24 05:41:57 1353 [Note] InnoDB: Highest supported file format is Barracuda.

2017-12-24 05:41:57 1353 [Warning] InnoDB: Resizing redo log from 2*3072 to 3*2048 pages, LSN=1625987

....................

WARNING: Default config file /etc/my.cnf exists on the system

This file will be read by default by the MySQL server

If you do not want to use this, either remove it, or use the

--defaults-file argument to mysqld_safe when starting the server

6、  启动mysql

[root@node001 etc]# service mysql start

Starting MySQL....... SUCCESS!

7、重置密码

查看初始化密码

[root@node001 etc]# cat /root/.mysql_secret

# The random password set for the root user at Sun Dec 24 05:39:11 2017 (local time): DMBe85LznCxRo16N

[root@node001 etc]# mysql -u root -pDMBe85LznCxRo16N

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 2

Server version: 5.6.28-log

Copyright (c) 2000, 2015, 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('mysql');

Query OK, 0 rows affected (0.00 sec)

mysql>show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set (0.00 sec)

8、远程授权

原因：默认远程无法连接

授权命令：

mysql> grant all privileges on *.* to 'root'@'%' identified by 'mysql' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql>flush privileges;

Query OK, 0 rows affected (0.01 sec)

内容来源于网络如有侵权请私信删除