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ÓÅ»¯] -- ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:zhenpao
Ò»°ãͨ¹ýÒÔÏÂÁ½ÖÖ·½Ê½¶¨Î»Ö´ÐÐЧÂÊ½ÏµÍµÄ SQL Óï¾ä¡£ Âý²éѯÈÕÖ¾ÔÚ²éѯ½áÊøÒÔºó²Å¼Í¼£¬ËùÒÔÔÚÓ¦Ó÷´Ó³Ö´ÐÐЧÂʳöÏÖÎÊÌâµÄʱºò²éѯÂý²éѯÈÕÖ¾²¢²»Äܶ¨Î»ÎÊÌ⣬¿ÉÒÔʹÓà show processlist ÃüÁî²é¿´µ±Ç° MySQL ÔÚ½øÐеÄỊ̈߳¬° ......
¶ÔÓÚÖеȼ¶±ðÒµÎñÁ¿µÄϵͳÀ´Ëµ£¬±¸·Ý²ßÂÔ¿ÉÒÔÕâô¶¨£ºµÚÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿ÌìÒ»´ÎÔöÁ¿±¸·Ý£¬Ã¿ÖÜÔÙ×öÒ»´ÎÈ«Á¿±¸·Ý£¬Èç´ËÒ»Ö±Öظ´¡£¶ø¶ÔÓÚÖØÒªµÄÇÒ·±Ã¦µÄϵͳ À´Ëµ£¬Ôò¿ÉÄÜÐèҪÿÌìÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿Ð¡Ê±Ò»´ÎÔöÁ¿±¸·Ý£¬ÉõÖÁ¸üƵ·±¡£ÎªÁ˲»Ó°ÏìÏßÉÏÒµÎñ£¬ÊµÏÖÔÚÏß±¸·Ý£¬²¢ÇÒÄÜÔöÁ¿±¸·Ý£¬×îºÃµÄ°ì·¨¾ÍÊDzÉÓÃÖ÷´Ó¸´ÖÆ»ú ÖÆ(replica ......
gNBpPFgyOw9Rwt/ozsnjgM7tJNo2 bhaaAThangemMkaz2tQhq3/f7dZ7 Vj29WeGHjuupj/AhYqymjAuokhYi X1T/fG+q1yR22PdcEP39dxU3ovEo lLLzwIZlQr9oJYwUf5eG4x5e1bMP nfIaIl8reszQPHFNbrxBjCVrBEXL TyBLehxzUpVI672t3LjX8q4ytCRC ezcoZQfMAc0DulJzNREbwlcf0Rco N0zW3ojBUxGsplBBZZPrD7/bPhkM rjtS8Bxym+HeV1TJDTXuiL8QLg== ......
# 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 ......
*************************×Ö·û´®º¯Êý***********************************
mysql> select concat('aa','bb');//×Ö·û´®µÄÁ¬½Ó
mysql> select insert ('beijing2008you',12,3,'me');//×Ö·û´®µÄ²åÈë
+-------------------------------------+
| insert ('beijing2008you',12,3,'me') |
+----------------------- ......