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.安装MySQL
rpm -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下载libaio
yum 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下载numactl
yum 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下安装图文详细教程