Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÄÚ´æµ÷ÓÅ

key_buffer_size - Õâ¶ÔMyISAM±íÀ´Ëµ·Ç³£ÖØÒª¡£Èç¹ûÖ»ÊÇʹÓÃMyISAM±í£¬¿ÉÒÔ°ÑËüÉèÖÃΪ¿ÉÓÃÄÚ´æµÄ 30-40%¡£ºÏÀíµÄֵȡ¾öÓÚË÷Òý´óС¡¢Êý¾ÝÁ¿ÒÔ¼°¸ºÔØ¡£
¼Çס£¬MyISAM±í»áʹÓòÙ×÷ϵͳµÄ»º´æÀ´»º´æÊý¾Ý£¬Òò´ËÐèÒªÁô³ö²¿·ÖÄÚ´æ¸øËüÃÇ£¬ºÜ¶àÇé¿öÏÂÊý¾Ý±ÈË÷Òý´ó¶àÁË¡£¾¡¹ÜÈç´Ë£¬ÐèÒª×ÜÊǼì²éÊÇ·ñËùÓÐµÄ key_buffer ¶¼±»ÀûÓÃÁË¡£ ......

[MySQLÓÅ»¯] ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷


[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......

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

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

ÔÚLinuxÏ£¬°²×°Mysql£¨tar£©

# cd /home/tmp (½øÈëѹËõ°üËùÔÚĿ¼)
# groupadd mysql (½¨Á¢mysql×é)
# useradd -g mysql mysql (ÔÚmysql×éÖн¨Á¢mysqlÓû§)
# tar -zxvf mysql-5.0.37.tar.gz (½âѹmysqlÔ´Âë,bz2ѹËõ°üÇëÓÓtar -jvxf ÎļþÃû”Ö¸Áî)
# cd mysql-5.0.37 (½øÈë½âѹĿ¼)
# ./configure --prefix=/usr/local/mysql (p ......

javaÓëmysqlÂÒÂëµÄÎÊÌâ

javaÓëmysqlÂÒÂëµÄÎÊÌâ
javaÓëmysqlÂÒÂëµÄÎÊÌâ
¹Ø¼ü×Ö: javaÓëmysqlÂÒÂëµÄÎÊÌâ
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ