centos 6.5 mysql 5.6 安装_MySQL5.6在Centos6.5下安装图文详细教程

软件安装：装机软件必备包

SQL是Structured Query Language(结构化查询语言)的缩写。SQL是专为数据库而建立的操作命令集，是一种功能齐全的数据库语言。在使用它时，只需要发出“做什么”的命令，“怎么做”是不用使用者考虑的。SQL功能强大、简单易学、使用方便，已经成为了数据库操作的基础，并且现在几乎所有的数据库均支持SQL。这篇文章主要介绍了Centos 6.5下安装MySQL 5.6教程,非常不错，具有参考借鉴价值，需要的朋友可以参考下

1.下载Linux对应的RPM包

2.解压tar包tar -xvf MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar

3.安装MySQLrpm -ivh MySQL-server-5.6.33-1.el6.x86_64.rpm

rpm -ivh MySQL-client-5.6.33-1.el6.x86_64.rpm

rpm -ivh MySQL-devel-5.6.33-1.el6.x86_64.rpm

如果出现:error: Failed dependencies:

libaio.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

下载libaioyum install libaio

如果出现:error: Failed dependencies:

libnuma.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

下载numactlyum install numactl

4.初始化MySQL及设置密码/usr/bin/mysql_install_db

service mysql start

如果启动失败可能是数据块所在目录没有权限cat /root/.mysql_secret #查看root账号密码

mysql> SET PASSWORD = PASSWORD('123456');

mysql> exit

如果.mysql_secret文件不存在,先停止MySQL进入安全模式设置密码service mysql stop

mysqld_safe --skip-grant-tables&

mysql -u root mysql

mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';

mysql> FLUSH PRIVILEGES;

5.允许远程登陆mysql> use mysql;

mysql> select host,user,password from user;

mysql> update user set host='%' where user='root' and host='localhost';

mysql> flush privileges;

mysql> exit

6.设置开机自启动chkconfig mysql on

chkconfig --list

关键词：MySQL5.6在Centos6.5下安装图文详细教程