Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½â¾öMySQL²»ÔÊÐí´ÓÔ¶³Ì·ÃÎʵķ½·¨

1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -p   
mysql>use mysql;   
mysql>update user set host = '%' where user = 'root';   
mysql>select host, user from user;  
2. ÊÚȨ·¨¡£ÀýÈ磬ÄãÏëmyuserʹÓÃmypassword´ÓÈκÎÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷µÄ»°¡£
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WI   
TH GRANT OPTION;   
FLUSH   PRIVILEGES;
Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃmypassword×÷ΪÃÜÂë
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY    
'mypassword' WITH GRANT OPTION;    
FLUSH   PRIVILEGES;  
Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷µÄdkÊý¾Ý¿â£¬²¢Ê¹ÓÃmypassword×÷ΪÃÜÂë
GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY    
'mypassword' WITH GRANT OPTION;    
FLUSH   PRIVILEGES;  
×¢ÒâÊÚȨºó±ØÐëFLUSH   PRIVILEGES;·ñÔòÎÞ·¨Á¢¼´ÉúЧ¡£
ÁíÍâÒ»ÖÖ·½·¨.
ÔÚ°²×°mysqlµÄ»úÆ÷ÉÏÔËÐУº 
  1¡¢d:\mysql\bin\>mysql   -h   localhost   -u   root 
        //ÕâÑùÓ¦¸Ã¿ÉÒÔ½øÈëMySQL·þÎñÆ÷ 
  2¡¢mysql>GRANT   ALL   PRIVILEGES   ON   *.*   TO   'root'@'%'   WITH   GRANT   OPTION 
        //¸³ÓèÈκÎÖ÷»ú·ÃÎÊÊý¾ÝµÄȨÏÞ 


Ïà¹ØÎĵµ£º

ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨

×÷Õß: Ф½¨±ò
| ¿ÉÒÔ×ªÔØ, ×ªÔØÊ±Îñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦
ºÍ×÷ÕßÐÅÏ¢¼°°æÈ¨ÉùÃ÷
꿅᣼http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql×´ ......

mysqlÓÅ»¯×ܽá

Èç¹û´ó¼ÒÓÐÒìÒ飬¿ÉÒÔÔÚºóÃæ²¹³ä¡£ÎÒ»áËæÊ±¸üеġ£
ÏÖÔÚ´ó¸ÅÁгöÈçÏÂ:(Íû¸÷λ²¹³ä)
1.Êý¾Ý¿âµÄÉè¼Æ
¾¡Á¿°ÑÊý¾Ý¿âÉè¼ÆµÄ¸üСµÄÕ¼´ÅÅ̿ռä.
1).¾¡¿ÉÄÜʹÓøüСµÄÕûÊýÀàÐÍ.(mediumint¾Í±Èint¸üºÏÊÊ).
2).¾¡¿ÉÄ͍ܵÒå×Ö¶ÎΪnot null,³ý·ÇÕâ¸ö×Ö¶ÎÐèÒªnull.£¨Õâ¸ö¹æÔòÖ»ÊʺÏ×Ö¶ÎΪKEYµÄÇéÐΣ©
3).Èç¹ûûÓÐÓõ½±ä³¤×Ö¶ÎµÄ ......

mysqlµÄÈȱ¸£º mysql replicationÔ­Àí½éÉÜ

×î½üÒµÎñ·ÃÎÊÁ¿±È½Ï´ó£¬Êý¾Ýͳ¼ÆÀàµÄ²Ù×÷¶¼Çл»µ½mysqlµÄ±¸»úÉÏÈ¥ÁË£¬±¸»úµÄ¶Á²Ù×÷²»»áÓ°ÏìÖ÷¡¢±¸Ö®¼äµÄÈȱ¸µÄ
ÏÂÃæÁÐһϾßÌåµÄÔ­Àí£º
ÒªÏëÓúÃÒ»¸öϵͳ£¬Àí½âÆäʵÏÖÔ­ÀíÊǷdz£ÖØÒªµÄÊÂÇ飬ֻÓÐÀí½âÁËÆäʵÏÖÔ­Àí£¬ÎÒÃDzÅÄܹ»Ñﳤ±Ü¶Ì£¬ºÏÀíµÄÀûÓ㬲ÅÄܹ»´î½¨³ö×îÊʺÏÎÒÃÇ×Ô¼ºÓ¦Óû·¾³µÄϵͳ£¬²ÅÄܹ»ÔÚϵͳʵʩ֮ºó¸üºÃµ ......

centos 5.Freeradius2.1 mysql 5.0³É¹¦°²×°ÅäÖñʼÇ

(1)°²×° freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# tar zxvf freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# cd freeradius-server-2.1.1
[root@localhost freeradius-server-2.1.1]# ./configure
[root@localhost freeradius-server-2.1.1]# make
[ ......

Mysql²éѯʱ£¬¶ÔÓÚÊýÖµÐÍ×ֶμӵ¥ÒýºÅ»áÒýÆðµÄÎó½â¡«

¼ÙÉèÓбí tb1
ID £ü name£ü
----+--------+
1   £ü2toon£ü
2   £ü1*xyz£ü
Óï¾ä1£º
 select * from  tb1 where ID='2toon' or name ='2toon';
mysql·þÎñÆ÷ÔÚijģʽÏ£¬¿ÉÒÔÖ´ÐÐÕâÌõ¾ä£¬¾Í³É¹¦·µ»ØÁ½Ìõ¼Ç¼£¬Ô­ÒòÔÚÓÚ ID=‘2toon’ ¼ÓÁ˵¥ÒýºÅ£¬mysql½âÊÍΪ ID=2.
Óï¾ä2
select * fro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ