CentOS7.4 Mysql5.6 详细安装教程
来源:互联网 发布:js面向对象 阮一峰 编辑:程序博客网 时间:2024/05/20 02:22
Mysql5.6 详细安装教程
1. 查看系统是否有安装
rpm -qa |grep -i mysql
rpm -qa |grep -i mariadb
2. 如果有安装使用以下命令卸载
yum -y remove XXXX
3. 下载安装程序
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.21-1.rhel5.x86_64.rpm
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.21-1.rhel5.x86_64.rpm
4. 安装过程
rpm -ivh MySQL-server-5.6.21-1.rhel5.x86_64.rpm
rpm -ivh MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
rpm -ivh MySQL-client-5.6.21-1.rhel5.x86_64.rpm
5. 安装报错处理
5.1 error: Failed dependencies:
libaio.so.1()(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
解决:
下载:wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
安装:rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
5.2 FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db:
Data::Dumper
解决:yum install -y perl-Module-Install.noarch
6. 启动
复制配置文件:cp /usr/share/mysql/my-default.cnf /etc/my.cnf
初始化mysql: /usr/bin/mysql_install_db
修改权限: chmod -R 777 /var/lib/mysql
启动: service mysql start
7. 修改root密码
mysql -u root -p 然后回车
use mysql 选择数据库实例
SET PASSWORD = PASSWORD(‘a123456’); 设置root密码
exit 退出
mysql -uroot -pa123456 测试登录
8. 授权远程登录权限
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘a123456’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
- CentOS7.4 Mysql5.6 详细安装教程
- Centos7安装mysql5.6详细教程
- CentOS7安装MySQL5.6详细步骤
- 在centos7中安装mysql5.7-详细教程
- CentOS7安装MySQL5.7.11教程
- centos7 mysql5.7.19安装教程
- MySql5.6 Window超详细安装教程
- MySql5.6 Window超详细安装教程
- MySql5.6 Window超详细安装教程
- MySql5.6Window超详细安装教程
- MySql5.6Window超详细安装教程
- CentOS7安装Mysql5.6
- CentOS7安装mysql5.6
- centos7 安装mysql5.6
- CentOS7安装mysql5.6
- centos7 mysql5.6安装
- centos7安装mysql5.6
- Centos7安装mysql5.6
- NSURL的一些属性
- python面向对象详解
- FastCopy 批处理命令
- eclipse启动tomcat无法访问的解决方法
- android RSA和Java RSA加密不一致的坑
- CentOS7.4 Mysql5.6 详细安装教程
- scrollView ListView GridView 嵌套 你要知道的
- 神经网络之自编码与稀疏性
- 浅析并发
- npm install webpack失败
- Kotlin学习(6):控制流
- windows 10 内置bash 安装32位支持
- linux 任务管理-后台运行与终止
- Fedora删除已安装的软件