MySQL Óû§¹ÜÀí

Ê×ÏÈÒªÉùÃ÷һϣºÒ»°ãÇé¿öÏ£¬ÐÞ¸ÄMySQLÃÜÂ룬ÊÚȨ£¬ÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ġ£
²âÊÔ»·¾³£ºWIN32 mysql5.0.45
×¢£º±¾²Ù×÷ÊÇÔÚWINÃüÁîÌáʾ·ûÏ£¬phpMyAdminͬÑùÊÊÓá£
    Óû§£ºphplamp  Óû§Êý¾Ý¿â£ºphplampDB
1.н¨Óû§¡£
//怬MYSQL
@>mysql -u root -p
@>ÃÜÂë
//´´½¨Óû§
mysql> insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));
//Ë¢ÐÂϵͳȨÏÞ±í
mysql>flush privileges;
ÕâÑù¾Í´´½¨ÁËÒ»¸öÃûΪ£ºphplamp  ÃÜÂëΪ£º1234  µÄÓû§¡£
È»ºóµÇ¼һÏ¡£
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;