JDK:要求jdk必须是1.7及以上版本
MySQL:推荐mysql是5.5以上版本
MySQL安装与启动步骤如下:( 步骤1-5省略 )
(1)将MySQL的服务端和客户端安装包(RPM)上传到服务器
(2)查询之前是否安装过MySQL
rpm -qa|grep -i mysql |
(3)卸载旧版本MySQL
rpm -e --nodeps 软件名称 |
安装MYSQL时出现:
error: Failed dependencies:
libaio.so.1 is needed by MySQL-server-5.5.31-2.el6.i686
libaio.so.1(LIBAIO_0.1) is needed by MySQL-server-5.5.31-2.el6.i686
libaio.so.1(LIBAIO_0.4) is needed by MySQL-server-5.5.31-2.el6.i686
原因:libaio依赖没有安装!
解决方案:
yum install libaio.so.1
出现 :/usr/bin/perl is needed by MySQL-server-
解决方案:yum install -y perl-Module-Install.noarch
- 安装服务端
rpm -ivh MySQL-server-5.5.49-1.linux2.6.i386.rpm |
安装客户端前先:yum install libncurses.so.5 yum install libgcc_s.so.1
- 安装客户端
rpm -ivh MySQL-client-5.5.49-1.linux2.6.i386.rpm |
(6)启动MySQL服务
service mysql start |
(7)登录MySQL
mysql -u root |
- 设置远程登录权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION; |
在本地SQLyog 连接远程MySQL进行测试