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

mysql server°²×°

Èý. mysql server°²×°
    ------------------ÒÔÏÂΪÀ©Õ¹£ºÉ¾³ýmysql----------------
    ɾ³ý mysql
    sudo apt-get autoremove --purge mysql-server-5.0
    sudo apt-get remove mysql-server
    sudo apt-get autoremove mysql-server
    sudo apt-get remove mysql-common //Õâ¸öºÜÖØÒª  Ó¦¸ÃΪ×Ô¶¯É¾³ýautoremove
    ÉÏÃæµÄÆäʵÓÐһЩÊǶàÓàµÄ¡£
    ÇåÀí²ÐÁôÊý¾Ý
    dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
    --------------------À©Õ¹Íê±Ï--------------------------
1. mysql server°²×°
    1.sudo apt-get install mysql-server mysql-client
    2.ÊäÈërootÃÜÂëΪroot
    3.¸ü¸Ämysql×î´óÁ¬½ÓÊý£º
    sudo gedit /etc/mysql/my.cnf Ôö¼Ó»òÐÞ¸Ämax_connections=1024;
2.½øÈëmysql:
    sudo mysql –u root -p  ÊäÈëÃÜÂëroot½øÈë¡£
3.Ìí¼Ó/ɾ³ýȨÏÞ
    Óï·¨ÈçÏ£º
    grant all privileges(or other options) on *.* (or others) to username@"localhost( or % or otherIP)" identified by"username" (or with grant option);Èôwith         grant optionÔòΪ³¬¼¶Óû§¡£
   
    revoke all privileges (or other options) on *.* (or others) from username(or username@"localhost( or % or otherIP)");
    ĬÈϰ²×ªÒѾ­ÎªrootÌí¼ÓÁ˱¾»úȨÏÞ,»ØÊÕȨÏÞʱÇëÉ÷ÖØ¶ÔrootȨÏÞ»ØÊÕ¡£
    ×¢£º»ØÊÕȨÏÞ²¢²»É¾³ýÓû§¡£Èç¹ûÏëɾ³ý£¬ÐèÒªdelete from user where USER like '...'
    ¼ÓȨÏÞµÄÓû§´´½¨£º
    eg:mysql>grant all privileges on epaper.* to wenxin@'localhost' identified by 'xinwen365';   Òâ˼ÊÇ:ÔÊÐíwenxin´Ó±¾µØ·ÃÎÊepaperÊý¾Ý¿â²¢ÇÒ¾ßÓжԸÃÊý¾Ý¿âµÄËùÓвÙ×÷
       mysql>grant all privileges on epaper.* to wenxin@'%' identified by 'xinwen365'; &nbs


Ïà¹ØÎĵµ£º

Safe Shutdown and Restart of MySQL Cluster


To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:

shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......

MysqlµÄGROUP_CONCAT()º¯ÊýʹÓ÷½·¨ ¶àÐкϲ¢º¯Êý

GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......

linuxϵ¼Èë¡¢µ¼³ömysqlÊý¾Ý¿âÃüÁî

Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
# ......

mysql¾ÖÓòÍø·ÃÎÊ

1,ÔÚwindow×Ô´øµÄ·À»ðǽÀïµÄÀýÍâÌí¼Ó3306¶Ë¿Ú£¬ÎªTCP
2£¬½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ