mysql -uroot -p123456
我这里是MySQL5.7.19;
二、在servlet中指定对应的版本,不同版本jdbc连接配置不同 1.MySQL5://注册驱动 Class.forName("com.mysql.jdbc.Driver"); //获取连接 String url = "jdbc:mysql://localhost:3306/wenjian"; String user = "root"; String password = "123456"; conn = DriverManager.getConnection(url, user, password);2.MySQL8:
//注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获取连接 String url = "jdbc:mysql://localhost:3306/wenjian"; String user = "root"; String password = "123456"; conn = DriverManager.getConnection(url, user, password);三、连接数据库的jar包不同
1.MySQL5连接的jar包:mysql-connector-java-5.1.25.jar
2.MySQL8连接的jar包:mysql-connector-java-8.0.21.jar
jar包下载地址:https://repo1.maven.org/maven2/mysql/mysql-connector-java/