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
Ïà¹ØÎĵµ£º
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, “ ......
GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......
Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
# ......
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ºó£¬¸ ......