ä¸ãè¿æ¥MySQL
å¼ï¼ mysql -h主æºå°å -uç¨æ·å -pç¨æ·å¯ç
ãã1ã è¿æ¥å°æ¬æºä¸çMYSQLã
ããé¦å
æå¼DOSçªå£ï¼ç¶åè¿å
¥ç®å½mysql\binï¼åé®å
¥å½ä»¤mysql -u root -pï¼å车åæç¤ºä½ è¾å¯ç .注æç¨æ·ååå¯ä»¥æç©ºæ ¼ä¹å¯ä»¥æ²¡æç©ºæ ¼ï¼ä½æ¯å¯ç åå¿
须没æç©ºæ ¼ï¼å¦åè®©ä½ éæ°è¾å
¥å¯ç .
ããå¦æåå®è£
好MYSQLï¼è¶
级ç¨æ·rootæ¯æ²¡æå¯ç çï¼æ
ç´æ¥å车å³å¯è¿å
¥å°MYSQLä¸äºï¼MYSQLçæ示符æ¯ï¼ mysql>ã
ãã2ãè¿æ¥å°è¿ç¨ä¸»æºä¸çMYSQLãå设è¿ç¨ä¸»æºçIP为ï¼110.110.110.110ï¼ç¨æ·å为root,å¯ç 为abcd123ãåé®å
¥ä»¥ä¸å½ 令ï¼
ããmysql -h110.110.110.110 -u root -p 123;(注:uä¸rootä¹é´å¯ä»¥ä¸ç¨å ç©ºæ ¼ï¼å
¶å®ä¹ä¸æ ·)
ãã3ã éåºMYSQLå½ä»¤ï¼ exit (å车)
ããäºãä¿®æ¹å¯ç
ããæ ¼å¼ï¼mysqladmin -uç¨æ·å -pæ§å¯ç password æ°å¯ç ã ä¾å¦
ãã1ã ç»rootå 个å¯ç ab12ãé¦å
å¨DOSä¸è¿å
¥ç®å½mysql\binï¼ç¶åé®å
¥ä»¥ä¸å½ä»¤
ããmysqladmin -u root -password ab12
ãã2ã åå°rootçå¯ç æ¹ä¸ºdjg345ã
ããmysqladmin -u root -p ab12 password ******
ããä¸ãå建æ°æ®åº
ãã1ã CREATE DATABASE æ°æ®åºå;
ãã2ã GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON æ°æ®åºå.* TO æ°æ®åºå@localhost IDENTIFIED BY 'å¯ç ';
ãã3ã SET PASSWORD FOR
ãã'æ°æ®åºå'@'localhost' = OLD_PASSWORD('å¯ç ');
ããä¾æ¬¡æ§è¡3个å½ä»¤å®ææ°æ®åºå建ã注æï¼ä¸æ âå¯ç âåâæ°æ®åºâæ¯æ·èªå·±éè¦è®¾ç½®çã
温馨提示:答案为网友推荐,仅供参考