MYSQL³£ÓÃÃüÁ

1¡¢µÇ½MySQL:
mysql -u root -p
2¡¢²é¿´Óû§ÐÅÏ¢
select user,host,password from mysql.user;
select user,host from mysql.user;
3¡¢ÉèÖÃÃÜÂë
set password for root@localhost=password('
ÔÚÕâÀïÌîÈërootÃÜÂë
');
4¡¢ÐÞ¸ÄÃÜÂë
·½·¨1£ºmysqladmin -u root -p password newpassword
·½·¨2£º ££mysql -u root -p mysql
               mysql>UPDATE user SET password=PASSWORD("new") WHERE user='root';
               mysql>flush privileges;
5
¡¢É¾³ýÄäÃûÓû§
delete from mysql.user where user='';
6
¡¢²é¿´ÏµÍ³ÒÑ´æÔÚµÄÊý¾Ý¿â
show databases;
7¡¢É¾³ýÃûΪtestµÄ¿ÕÊý¾Ý¿â
drop database test;
8¡¢½¨Á¢mysqlÓû§
  Àýa:
½¨Á¢¶ÔtestÊý¾Ý¿âÓÐÍêÈ«²Ù×÷ȨÏÞµÄÃûΪcentospubµÄÓû§
mysql>grant all privileges on test.* to centospub@localhost identified by 'password';
  Àýb:
Ôö¼ÓÒ»¸öÓû§test1ÃÜÂëΪabc£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMYSQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ
mysql>grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
µ«ÀýbÔö¼ÓµÄÓû§ÊÇÊ®·ÖΣÏյģ¬ÄãÏëÈçij¸öÈËÖªµÀtest1µÄÃÜÂ룬ÄÇôËû¾Í¿ÉÒÔÔÚinternetÉϵÄÈκÎһ̨µçÄÔÉϵǼÄãµÄmysqlÊý¾Ý¿â²¢¶ÔÄãµÄÊý¾Ý¿ÉÒÔΪËùÓûΪÁË¡£
  Àýc:
Ôö¼ÓÒ»¸öÓû§test2ÃÜÂëΪabc,ÈÃËûÖ»¿ÉÒÔÔÚlocalhostÉϵǼ£¬²¢¿ÉÒÔ¶ÔÊý¾Ý¿âmydb½øÐвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄ²Ù×÷£¨localhostÖ¸±¾µØÖ÷»ú£¬¼´MYSQLÊý¾Ý¿âËùÔÚµÄÄÇ̨Ö÷»ú£©£¬ÕâÑùÓû§¼´Ê¹ÓÃÖªµÀtest2µÄÃÜÂ룬ËûÒ²ÎÞ·¨´ÓinternetÉÏÖ±½Ó·ÃÎÊÊý¾Ý¿â£¬Ö»ÄÜͨ¹ýMYSQLÖ÷»úÉϵÄwebÒ³À´·ÃÎÊÁË¡£
mysql>grant select,insert,update,delete on mydb.* to test2@localhost identified by "abc";
9¡¢²éÕÒ
È·ÈÏcentospubÓû§µÄ´æÔÚÓë·ñ
select user from mysql.user where user='centospub';
10¡¢
½¨Á¢ÃûΪtestµÄÊý¾Ý¿â
create database test;
11
¡¢È¡ÏûcentospubÓû§¶ÔÊý¾Ý¿âµÄ²Ù×÷ȨÏÞ
revoke all privileges on *.* from centospub@localhost;
12
¡¢É¾³ýcentospubÓû§
delete from mysql.user w