安装步骤
mysql 版本:5.1.73
linux 版本:
- 查看可用的mysql 版本
[root@allen1 mysql]# yum list | grep mysq
- 选择一个本server版本安装, 会打印很多日志,发现completed成功。
root@allen1 mysql]# yum -y install mysql.x86_64 mysql-server.x86_64
- 安装完成后启动mysql服务
[root@allen1 mysql]# service mysqld start
- 设置mysql 开机自动启动,默认不是自动启动的, 2-5 为on是表示设置成功
[root@allen1 mysql]# chkconfig --list | grep mysqld
[root@allen1 mysql]# chkconfig mysqld on
[root@allen1 mysql]# chkconfig --list | grep mysqld
- 为root用户设置密码,设置时会让你输入密码,直接按回车,默认密码为空
[root@allen1 mysql]# mysqladmin -u root -p password '123456'
Enter password:
- 用root进入mysql,输入刚才设置的密码123456
[root@allen1 mysql]# mysql -uroot -p
Enter password:
- 给需要访问这台机器的远程ip赋登录权限。
grant all privileges on *.* to 'root' @'%' identified by '123456' with grant option;
flush privileges;
- 查看3306端口已经在监听
[root@allen1 mysql]# netstat -lpn | grep 3306
- 将3306端口临时开放并保存
[root@allen1 mysql]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
[root@allen1 mysql]# /etc/rc.d/init.d/iptables save
- 以防万一关闭防火墙
[root@allen1 mysql]# service iptables start
[root@allen1 mysql]# service iptables stop
测试
- 在mysql 客户端测试连接
sql yog 下载地址 http://soft.onlinedown.net/soft/24926.htm
- 在java jdbc 代码中测试连接:
package com.jiagouedu.com.jdbc;
import javax.swing.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
public class ConnectDockerMysql extends JFrame {
private static final long serialVersionUID = 1L;
public static void getDataVector() throws SQLException, ClassNotFoundException {
Connection conn = null;
java.sql.Statement stmt = null;
Class.forName("com.mysql.jdbc.Driver");
String dburl = "jdbc:mysql://192.168.0.101:3306/mysql";
String dbuser = "root";
String dbpassword = "123456";
conn = DriverManager.getConnection(dburl, dbuser, dbpassword);
stmt = conn.createStatement();
String sql = "select * from student";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
Vector rowVector = new Vector();
{
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
}
}
}
public static void main(String Args[]) throws ClassNotFoundException, SQLException{
getDataVector();
}
}
-
jdbc driver 下载: <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.44</version> </dependency>
- 执行结果:
参考地址: https://blog.youkuaiyun.com/jxpxlinkui/article/details/79639501