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, “ ......
1.ÅäÖÃÃû×ÖΪmyodbcµÄÊý¾ÝÔ´
2.ÔÚstdafx.hÖмÓÉÏ
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename ("EOF", "adoEOF")
3.ÔÚ³ÌÐò³õʼ»¯µÄ·½·¨ÖмÓÉÏ
AfxEnableControlContainer();
// ³õʼ»¯COM,´´½¨ADOÁ¬½ÓµÈ²Ù×÷
AfxOleInit();
4.ÔÚºÏÊʵĵط½¼ÓÉÏ
public:_ConnectionPt ......
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......
¼ÇµÃÇ°ÌìÓÐÈËÎÊÎÒ£¬ Memcache ºÍ MySQL ×Ô¼ºµÄ Query Cache ÓÐɶÇø±ð? ÎÒÕâÑù»Ø´ðµÄ£¬Ç°ÕßÊÇɽկÖеÄÕ½¶·»ú£¬ºóÕßÊǹٷ½µÄÕ½¶·»ú¡£
ÐÂÊֻشðÎÊÌ⣬´íÁËĪ¹Ö¡£¹þ¹þ¹þ¡£
ºÃÏñϸ½ÚÉϵIJî±ð»¹ÊÇÓеġ£
MemcacheÓŵãÈçÏ£º
1. ÀíÂÛÉÏ¿ÉÒÔÖ§³ÅÎÞÏÞ²¢·¢ÒµÎñ²Ù×÷¡£
2. ¿ÉÒÔÆôÓõ¥¶ÀµÄʵÀýÀ´»º´æ¾Þ¶àµÄÊý¾Ý¡££¨µ± ......