net stop mysql
net start mysql
Linux:service mysqld start|stop|restart。Windows 無 restart 參數,需先停後啟,可寫批次檔 mysqlreset.bat。
mysql -u root -p
-- 遠程連線
mysql -h 192.168.1.100 -u root -p
-- 本地登入,具增刪改查權限
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost' IDENTIFIED BY 'password1';
-- 允許任意主機登入
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'%' IDENTIFIED BY 'password1';
-- 移除密碼
GRANT SELECT,INSERT,UPDATE,DELETE ON mydb.* TO 'user1'@'localhost' IDENTIFIED BY '';
SHOW DATABASES;
USE mysql;
SHOW TABLES;
DESCRIBE 表名;
CREATE DATABASE dbname;
DROP DATABASE dbname;
CREATE TABLE tbname (id INT PRIMARY KEY, name VARCHAR(20));
DROP TABLE tbname;
DELETE FROM tbname;
SELECT * FROM tbname;
-- 匯出整庫
mysqldump -u root -p123456 --databases dbname > mysql.dbname
-- 匯出單表
mysqldump --opt test > mysql.test
-- 匯入
mysqlimport -u root -p123456 < mysql.dbname
-- 文字檔匯入(欄位以 Tab 分隔)
USE test;
LOAD DATA LOCAL INFILE '檔案名' INTO TABLE 表名;
-- 來源 .sql 檔匯入
SOURCE d:/mysql.sql;
CREATE DATABASE MYSQLDATA;
USE MYSQLDATA;
CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));
INSERT INTO MYTABLE VALUES ('hyq','M');
LOAD DATA LOCAL INFILE 'D:/mysql.txt' INTO TABLE MYTABLE;