这篇文章主要介绍了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 | grep mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
7.mysql的默认安装位置
/var/lib/mysql/ #数据库目录
/usr/share/mysql #配置文件目录
/usr/bin #相关命令目录
/etc/init.d/mysql #启动脚本
8.常用命令
1.使用客户端工具连接到数据库
mysql -u root -p
2.查看mysql服务器中包含那些数据库
mysql>show databases;
3.查看数据库中的数据表信息
mysql>show tables;
4.切换数据库
mysql>use mysql;
5.创建新的数据库
mysql>create database 数据库名字;
6.创建新的数据表
mysql>create table 表名 (字段定义)
7.删除一个数据表
mysql>drop table 数据库名.表名;
8.删除一个数据库
mysql>drop database 数据库名
9.备份整个数据库
mysqldump -u root -p auth > mysql-auth.sql
10.备份数据库mysql中的user表
mysqldump -u root -p mysql user > mysql.host-user.sql
11.备份mysql服务器中所有数据库
mysqldump -u root -p -all-databases > mysql-all.sql
12.恢复数据库
mysql -u root -p [数据库名]< mysql-all.sql
13.授予用户权限
grant 权限列表 on 数据库名.表名 to 用户名@来源地址 [identified by '密码']
grant select on mysql.user to daxiong@'localhost' identified by'123456';
以上就是mysql5.6在centos6.5下安装教程的详细内容。