安裝mysql-server包
sudo apt-get install mysql-server
安全設(shè)置
sudo mysql_secure_installation
創(chuàng)建用戶
根用戶連接mysql
mysql -u root -p
創(chuàng)建新用戶
CREATE USER 'tester'@'localhost' IDENTIFIED BY 'password';
設(shè)置用戶權(quán)限
GRANT ALL PRIVILEGES ON * . * TO 'tester'@'localhost';
重新加載權(quán)限
FLUSH PRIVILEGES;
新用戶連接mysql
mysql -u tester -p
創(chuàng)建新數(shù)據(jù)庫
CREATE DATABASE testdb;
刪除數(shù)據(jù)庫
DROP DATABASE testdb;
查看數(shù)據(jù)庫
SHOW DATABASES;
連接數(shù)據(jù)庫
USE testdb;
創(chuàng)建表
CREATE TABLE articles (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), created TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
查看表
SHOW TABLES;
查看表結(jié)構(gòu)
DESCRIBE srticles;
表中增加數(shù)據(jù)
INSERT INTO articles (name) VALUES ("python");
增加列
ALTER TABLE articles ADD author VARCHAR(20);
增加列到指定位置
ALTER TABLE articles ADD content VARCHAR(10000) AFTER name;
更新表
UPDATE articles SET name = "java", author = "sam" WHERE name = "flask";
刪除列
ALTER TABLE articles DROP created;
刪除行
DELETE FROM articles WHERE name = "flask";
處理unicode文本
ALTER TABLE articles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE articles CHANGE content content VARCHAR(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE articles CHANGE author author VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
