從官網下載 MSI 安裝檔,到 Navicat 視覺化管理,再到 Java JDBC 程式碼連線測試,一站式入門指南。
https://dev.mysql.com/downloads/mysql/5.5.htmlmysql-5.5.36-winx64.msi (35.3 MB) 或 32 位元版。utf8。localhost、埠 3306、用戶 root、密碼。# 進入客戶端
mysql -uroot -p
# 遠端連線
mysql -h 192.168.0.1 -uroot -p1234
# 常用指令
SHOW DATABASES;
USE mysql;
SHOW TABLES;
DESC proc;
CREATE DATABASE school;
USE school;
CREATE TABLE teacher (
id INT(3) AUTO_INCREMENT PRIMARY KEY,
name CHAR(10) NOT NULL,
address VARCHAR(50) DEFAULT 'ChengDu',
year DATE
);
INSERT INTO teacher VALUES (NULL, 'Wang', 'BJ', '1988-10-10');
SELECT * FROM teacher;
-- 全庫全權限,任意主機 (高風險)
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'test1'@'%' IDENTIFIED BY 'abc';
-- 僅本機、指定庫、指定權限 (安全)
GRANT SELECT,INSERT,UPDATE,DELETE ON mydb.* TO 'test2'@'localhost' IDENTIFIED BY 'abc';
-- 移除密碼
GRANT SELECT,INSERT,UPDATE,DELETE ON mydb.* TO 'test2'@'localhost' IDENTIFIED BY '';
// 1. 載入驅動 (mysql-connector-java-5.1.x-bin.jar 需在 classpath)
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 2. 建立連線
Connection con = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/school", "root", "abcd");
// 3. 執行 SQL
Statement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO user(username,password) VALUES('qgao','123456')");
// 4. 取得自增 ID
ResultSet rs = stmt.executeQuery("SELECT LAST_INSERT_ID()");
if (rs.next()) System.out.println(rs.getInt(1));
// 5. 關閉資源
rs.close(); stmt.close(); con.close();
mysql-connector-java-5.1.x-bin.jar。完成上述步驟,即可在 Windows 開發環境順利建構、管理與程式存取 MySQL 5.5。