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

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


 Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
 
 
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç 
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54) 
¸ÙÒª£º 
Ò»£¬Á¬½ÓMySQL 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷ 
ËÄ, Êý¾Ý¿â±¸·Ý 
Î壬ºó¼Ç 
Ò»£¬Á¬½ÓMySQL 
¸ñʽ£ºmysql -h Ô¶³ÌÖ÷»úµØÖ· -u Óû§Ãû -p »Ø³µ 
ÊäÈëÃÜÂë½øÈ룺 
mysql -u root -p »Ø³µ 
Enter password: ,ÊäÈëÃÜÂë¾Í¿ÉÒÔ½øÈë 
mysql> ½øÈëÁË 
Í˳öÃüÁî:>exit »òÕßctrl+D 
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ 
1.ÐÞ¸ÄÃÜÂ룺 
¸ñʽ£ºmysqladmin -u Óû§Ãû -p ¾ÉÃÜÂë password ÐÂÃÜÂë 
2.Ôö¼ÓÐÂÓû§: 
>grant create,select,update....(ÊÚÓèÏà¹ØµÄ²Ù×÷ȨÏÞ) 
->on Êý¾Ý¿â.* 
-> to Óû§Ãû@µÇ¼Ö÷»ú identified by 'ÃÜÂë' 
²Ù×÷ʵÀý£º 
¸ørootÓû§Ìí¼ÓÃÜÂë: 
# mysqladmin -u root password 52netseek 
ÒòΪ¿ªÊ¼rootûÓÐÃÜÂë,ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¿ÉÒÔÊ¡ÂÔ. 
µÇ½²âÊÔ£º 
# mysql -u root -p »Ø³µ 
ÊäÈëÃÜÂë,³É¹¦µÇ½. 
½«Ô­ÓеÄmysql¹ÜÀíµÇ½ÃÜÂë52netseek¸ÄΪ52china. 
# mysqladmin -u root -p 52netseek password '52china' 
´´½¨Êý¾Ý¿âÌí¼ÓÓû§²¢ÊÚÓèÏàÓ¦µÄȨÏÞ: 
mysql> create database phpbb; 
Query OK, 1 row affected (0.02 sec) 
mysql> use phpbb; 
Database changed 
mysql> grant create,select,update,insert,delete,alter 
-> on phpbb.* 
-> to phpbbroot@localhost identified by '52netseek'; 
Query OK, 0 rows affected (0.00 sec) 
ÊÚÓèËùÓеÄȨÏÞ: 
>grant all privileges 
>on bbs.* 
>to bbsroot@localhost identified by '52netseek' 
»ØÊÕȨÏÞ£º 
revoke create,select,update,insert,delete,alter 
on phpbb.* 
from phpbbroot@localhost identified by '52netseek'; 
ÍêÈ«½«phpbbrootÕâ¸öÓû§É¾³ý: 
>use mysql 
>delete from user 
where user='phpbbroot' and host='localhost'; 
>flush privileges; Ë¢ÐÂÊý¾Ý¿â 
Èý


Ïà¹ØÎĵµ£º

mysql±àÒë°²×°Óë²ÎÊý

mysql ±àÒë°²×°Óë±àÒë²ÎÊý
Ìí¼Ómysql×éºÍmysqlÓû§
 
[root@centos mysql]# groupadd mysql
[root@centos mysql]# useradd -g mysql mysql
 
±àÒëÓë°²×°
 
tar -zxvf mysql-5.1.35.tar.gz
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/data/mysql/data \    m ......

[MySQLÓÅ»¯] ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL


[MySQLÓÅ»¯] -- ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:zhenpao
Ò»°ãͨ¹ýÒÔÏÂÁ½ÖÖ·½Ê½¶¨Î»Ö´ÐÐЧÂÊ½ÏµÍµÄ SQL Óï¾ä¡£ Âý²éѯÈÕÖ¾ÔÚ²éѯ½áÊøÒÔºó²Å¼Í¼£¬ËùÒÔÔÚÓ¦Ó÷´Ó³Ö´ÐÐЧÂʳöÏÖÎÊÌâµÄʱºò²éѯÂý²éѯÈÕÖ¾²¢²»Äܶ¨Î»ÎÊÌ⣬¿ÉÒÔʹÓà show processlist ÃüÁî²é¿´µ±Ç° MySQL ÔÚ½øÐеÄỊ̈߳¬° ......

MySQLÖÐÐÞ¸ÄÃÜÂë¼°·ÃÎÊÏÞÖÆÉèÖÃÏê½â

¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......

cmd ÃüÁîÐÐÏÂmysqlµÄ֪ʶ


*************************×Ö·û´®º¯Êý***********************************
mysql> select concat('aa','bb');//×Ö·û´®µÄÁ¬½Ó
mysql> select insert ('beijing2008you',12,3,'me');//×Ö·û´®µÄ²åÈë
+-------------------------------------+
| insert ('beijing2008you',12,3,'me') |
+----------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ