mysql µÄһЩ³£ÓÃÃüÁî

 ÔÊÐíËùÓÐÖ÷»úÔ¶³Ì·ÃÎÊ
GRANT ALL PRIVILEGES ON *.* TO 'dba'@'%' IDENTIFIED BY 'dbapassword' WITH GRANT OPTION;
Ö¸¶¨Ö÷»ú¿ÉÔ¶³Ì
GRANT ALL PRIVILEGES ON *.* TO 'dba'@'192.168.0.100' IDENTIFIED BY 'dbapassword' WITH GRANT OPTION;
Ö¸¶¨È¨ÏÞ¿ªÔ¶³Ì
grant select,insert,update,delete on test.* to dba@"192.168.0.100" Identified by "dbapassword";
²é¿´Óû§ÐÅÏ¢
select user,host,password from mysql.user;
ÉèÖúÍÐÞ¸ÄrootÃÜÂë
set password for root@localhost=password('ÔÚÕâÀïÌîÈërootÃÜÂë');
ÐÞ¸ÄÃÜÂë
use mysql
update user set password=password("ÐÂÃÜÂë") where user="root";
ɾ³ýÄäÃûÓû§
delete from mysql.user where user='';
ɾ³ýÃûΪtestµÄ¿ÕÊý¾Ý¿â
drop database test;
½¨Á¢¿â
create database test;
ÔÚÊý¾Ý¿âÖн¨Á¢±í
create table test(num int, name varchar(50));
²åÈëÒ»¸öÖµµ½±íÖÐ
insert into test values(1,'Hello World!');¡¡
²é±íÐÅÏ¢
select * from test;
¸üбíµÄÐÅÏ¢£¬¸³ÓèеÄÖµ
update test set name='Hello Everyone!';
ɾ³ý±í
drop table test;
ɾ³ý¿â
drop database test;¡¡
È¡Ïûdba¶ÔccvicµÄȨÏÞ
revoke all privileges on ccvic.* from dba@localhost;
ɾ³ýdbaÓû§
delete from mysql.user where user='dab' and host='localhost';¡¡
²éѯdbaÓû§ÐÅÏ¢
select user from mysql.user where user='dba';
ˢУ¬Ê¹²Ù×÷ÉúЧ
FLUSH   PRIVILEGES;
mysqlÃÜÂëÍü¼Ç£¬Õһذ취£º
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮£º killall -TERM mysqld
Æô¶¯ MySQL £ºbin/safe_mysqld --skip-grant-tables &
¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË
È»ºó¾ÍÊÇ
>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
ÖØÐÂɱ MySQL £¬ÓÃÕý³£·½·¨Æô¶¯ MySQL