ãã第ä¸æ¥ï¼å®è£ MySQL客æ·ç«¯
ããå½ç¶ä½ å¾ç¡®ä¿MySQL客æ·ç«¯å·²ç»å®è£ å®æ¯ãå¦æ没æçè¯ï¼å¯ä»¥æç §ä¸é¢çæ¹æ³ã
ããå¨Debianï¼Ubuntu æè Linux Mintä¸ï¼
ãã$ sudo apt-get install mysql-client
ãã$ sudo apt-get install mysql
ãã第äºæ¥ï¼ç»éå°MySQLæå¡å¨
ããé¦å ï¼ä½ éè¦ä½¿ç¨rootç¨æ·ç»éè¿ä½ çMySQLæ°æ®åºï¼å¦ä¸ï¼
ãã$ mysql -u root -h -p
ãã请注æï¼ä¸ºäºè½ç»è¿è¿ç¨çMySQLæå¡å¨ï¼ä½ éè¦å¼å¯æå¡å¨ä¸çè¿ç¨è®¿é®ï¼å¦æä½ æ³è°ç¨åä¸ä¸»æºä¸çMySQLæå¡å¨ï¼ä½ å¯ä»¥çç¥ "-h " åæ°
ãã$ mysql -u root -p
ããä½ å°éè¦è¾å ¥MySQLæå¡å¨çå¯ç ï¼å¦æ认è¯æåï¼MySQLæ示å°ä¼åºç°ã
ãã第ä¸æ¥ï¼å建ä¸ä¸ªMySQLæ°æ®åº
ããå¨MySQLæ示ä¸è¾å ¥å½ä»¤ä¹åï¼è¯·è®°ä½ææçå½ä»¤é½æ¯ä»¥åå·ç»æç(å¦åå°ä¸ä¼æ§è¡)ãå¦å¤ï¼èèè¾å ¥å½ä»¤çæ¶å使ç¨å¤§äºåæ¯ï¼è¾å ¥æ°æ®åºå¯¹è±¡ä½¿ç¨å°ååæ¯ãä½é£ä¸æ¯å¿ é¡»çï¼åªæ¯æ¹ä¾¿çé 读ã
ããç°å¨ï¼å建ä¸ä¸ªå«åxmodulo_DBçæ°æ®åºï¼
ããmysql> CREATE DATABASE IF NOT EXISTS xmodulo_DB;
ãã第åæ¥ï¼å建ä¸ä¸ªæ°æ®åºè¡¨
ãã为äºè¾¾å°æ¼ç¤ºçç®çï¼å建ä¸ä¸ªå«åposts_tblç表ï¼è¡¨éä¼åå¨å ³äºæç« çå¦ä¸ä¿¡æ¯ï¼
ããæç« çæ é¢
ããä½è çåå
ããä½è çå§
ããæç« å¯ç¨æè ä¸å¯ç¨
ããæç« å建çæ¥æ
ããè¿ä¸ªè¿ç¨å两æ¥æ§è¡ï¼
ããé¦å ï¼éæ©éè¦ä½¿ç¨çæ°æ®åºï¼
ããmysql> USE xmodulo_DB;
ããç¶åï¼å¨æ°æ®åºä¸å建æ°è¡¨ï¼
ããmysql> CREATE TABLE 'posts_tbl' (
ãã'post_id' INT UNSIGNED NOT NULL AUTO_INCREMENT,
ãã'content' TEXT,
ãã'author_FirstName' VARCHAR(100) NOT NULL,
ãã'author_LastName' VARCHAR(50) DEFAULT NULL ,
ãã'isEnabled' TINYINT(1) NOT NULL DEFAULT 1,
ãã'date' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
ããPRIMARY KEY ( 'post_id' )
ããTYPE = MYISAM;
ãã第äºæ¥ï¼å建ä¸ä¸ªç¨æ·ï¼å¹¶æäºæé
ããå½æ¶åå°è®¿é®æ°åçæ°æ®åºå表çæ¶åï¼å建ä¸ä¸ªæ°ç¨æ·æ¯ä¸ä¸ªå¾å¥½ç主æãè¿æ ·åå°±å¯ä»¥è®©ç¨æ·å¨æ²¡ææ´ä¸ªMySQLæå¡å¨æéçæ åµä¸ï¼å»è®¿é®é£ä¸ªæ°æ®åº(èä¸åªè½æ¯é£ä¸ªæ°æ®åº)
ããä½ å¯ä»¥å建æ°ç¨æ·ï¼æäºæéï¼å¹¶ä¸ä½¿æ¹åçæï¼
ããmysql> GRANT ALL PRIVILEGES ON xmodulo_DB.* TO 'new_user'@'%' IDENTIFIED
BY 'new_password';
ããmysql> FLUSH PRIVILEGES;
ãã'newuser'å'newpassword'åå«æçæ¯æ°çç¨æ·ååä»çå¯ç ãè¿æ¡ä¿¡æ¯å°ä¼è¢«ä¿åå¨mysql.user表ä¸ï¼èä¸å¯ç ä¼è¢«å å¯ã
ãã第å æ¥ï¼æµè¯
ããå æå ¥ä¸ä¸ªèæçè®°å½å°posts_tbl表ï¼
ããmysql> USE xmodulo_DB;
ããmysql> INSERT INTO posts_tbl (content, author_FirstName, author_Las
tName)
ããVALUES ('Hi! This is some dummy text.', 'Gabriel', 'Canepa');
ããç¶åæ¥çposts_tbl表ä¸çææè®°å½ï¼
ããmysql> SELECT * FROM posts_tbl;
ãã注æï¼MySQLä¼å¨å åå®ä¹çå°æ¹èªå¨æå ¥éå½çé»è®¤å¼(æ¯å¦ï¼'isEnabled'å'date')ã
MySQL云数据库创建、配置与使用教程,五秒钟创建属于自己的mysql云数据库,申请地址:xmjar.cn