//å·æ°ç³»ç»æé表ã
flush privileges;
ç¶åç»å½ä¸ä¸ã
mysql>exit;
@>mysql -u phplamp -p
@>è¾å
¥å¯ç
mysql>ç»å½æå
2.为ç¨æ·ææã
//ç»å½MYSQLï¼æROOTæéï¼ãæéæ以ROOT身份ç»å½.
@>mysql -u root -p
@>å¯ç
//é¦å
为ç¨æ·å建ä¸ä¸ªæ°æ®åº(phplampDB)
mysql>create database phplampDB;
//ææphplampç¨æ·æ¥æphplampæ°æ®åºçæææéã
>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
//å·æ°ç³»ç»æé表
mysql>flush privileges;
mysql>å
¶å®æä½
/*
å¦ææ³æå®é¨åæéç»ä¸ç¨æ·ï¼å¯ä»¥è¿æ ·æ¥å:
mysql>grant select,update on phplampDB.* to phplamp@localhost identified by '1234';
//å·æ°ç³»ç»æé表ã
mysql>flush privileges;
*/
3.å é¤ç¨æ·ã
@>mysql -u root -p
@>å¯ç
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//å é¤ç¨æ·çæ°æ®åº
mysql>drop database phplampDB;
4.ä¿®æ¹æå®ç¨æ·å¯ç ã
@>mysql -u root -p
@>å¯ç
mysql>update mysql.user set password=password('æ°å¯ç ') where User="phplamp" and Host="localhost";
mysql>flush privileges;
温馨提示:答案为网友推荐,仅供参考