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; Ë¢ÐÂÊý¾Ý¿â
Èý
Ïà¹ØÎĵµ£º
key_buffer_size - Õâ¶ÔMyISAM±íÀ´Ëµ·Ç³£ÖØÒª¡£Èç¹ûÖ»ÊÇʹÓÃMyISAM±í£¬¿ÉÒÔ°ÑËüÉèÖÃΪ¿ÉÓÃÄÚ´æµÄ 30-40%¡£ºÏÀíµÄֵȡ¾öÓÚË÷Òý´óС¡¢Êý¾ÝÁ¿ÒÔ¼°¸ºÔØ¡£
¼Çס£¬MyISAM±í»áʹÓòÙ×÷ϵͳµÄ»º´æÀ´»º´æÊý¾Ý£¬Òò´ËÐèÒªÁô³ö²¿·ÖÄÚ´æ¸øËüÃÇ£¬ºÜ¶àÇé¿öÏÂÊý¾Ý±ÈË÷Òý´ó¶àÁË¡£¾¡¹ÜÈç´Ë£¬ÐèÒª×ÜÊǼì²éÊÇ·ñËùÓÐµÄ key_buffer ¶¼±»ÀûÓÃÁË¡£ ......
[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......
¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......
# 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ÂÒÂëµÄÎÊÌâ
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF ......