ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó
ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó
ÎÒÓÃ:
grant all privileges on *.* to ´´½¨µÄÓû§Ãû@localhost identified by "ÃÜÂë";
flush privileges; \* ˢиղŵÄÄÚÈÝ*\
========================
mysqlĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ÒòΪÓкܴóµÄ°²È«Òþ»¼¡£¡£
ËùÒÔÐèÒªÊÖ¶¯Ôö¼Ó¿ÉÒÔÔ¶³Ì·ÃÎÊÊý¾Ý¿âµÄÓû§¡£
ÏÂÃæÊÇÁ¬½Ó·½Ê½£º
# mysql -u root -p
>;grant select,insert,update,delete on *.* to root@"202.11.10.253" Identified by "dboomysql";
----ÔÊÐíµØÖ·202.11.10.253ÉÏÓÃrootÓû§£¬ÃÜÂëdboomysqlÀ´Á¬½ÓmysqlµÄËùÓÐÊý¾Ý¿â£¬¸¶¸øselect,insert,update,deleteȨÏÞ¡£
grant all on *.* to root@"202.11.10.253" Identified by "dboomysql"
ÔÊÐíµØÖ·202.11.10.253ÉÏÓÃrootÓû§£¬ÃÜÂëdboomysqlÀ´Á¬½ÓmysqlµÄËùÓÐÊý¾Ý¿â£¬¸¶¸øËùÓÐȨÏÞ¡£
ÕâÑùÓÃÊý¾Ý¿â¹ÜÀíÈí¼þ¾Í¿ÉÒÔÔ¶³Ì·ÃÎÊMysqlÁË¡£
======================================
A1:
Ô¶³ÌÁ¬½Óµ½MySQLÐèÒª×öµÄ
1. ½øÈëMySQL,´´½¨Ò»¸öÐÂÓû§xuys:
¸ñʽ: grant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
²é¿´½á¹û,Ö´ÐÐ:
use mysql;
select host,user,password from user;
¿ÉÒÔ¿´µ½ÔÚuser±íÖÐÒÑÓиղŴ´½¨µÄxuysÓû§,host×ֶαíʾµÇ¼µÄÖ÷»ú,ÆäÖµ¿ÉÒÔÓÃIP,Ò²¿ÉÓÃÖ÷»úÃû,½«host×ֶεÄÖµ¸ÄΪ%¾Í±íʾÔÚÈκοͻ§¶Ë»úÆ÷ÉÏÄÜÒÔxuysÓû§µÇ¼µ½MySQL·þÎñÆ÷,½¨ÒéÔÚ¿ª·¢Ê±ÉèΪ%.
update user set host = '%' where user = 'xuys';
2.
./mysqladmin -u root -p pwd reload
./mysqladmin -u root -p pwd shutdown
3.
./mysqld_safe --user=root &
¼Çס: ¶ÔÊÚȨ±íµÄÈκÎÐ޸Ķ¼ÐèÒªÖØÐÂreload,¼´Ö´ÐеÚ3²½.
Èç¹û¾¹ýÒÔÉÏ3¸ö²½Ö軹ÊÇÎÞ·¨´Ó¿Í»§¶ËÁ¬½Ó,ÇëÖ´ÐÐÒÔϲÙ×÷,ÔÚMySQLÊý¾Ý¿âµÄdb±íÖвåÈëÒ»Ìõ¼Ç¼:
use mysql;
ins
Ïà¹ØÎĵµ£º
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡ ......
sphinx°æ±¾Ê¹ÓõÄÊÇcoreseekÐ޸ĵÄÖ§ ³ÖÖÐÎļìË÷µÄ°æ±¾,ÖÐÎÄ´Ê¿âʹÓà coreseek¿ª·¢µÄlibmmseg
mysqlÊÜsphinxÖÐsphinxseÒýÇæÒªÇó°²×°ÁËmysql-5.0.37×öÉú²ú»·¾³µÄmysql-5.0.70µÄ´Ó¿â
±àÒësphinx,libmmsegÒÔ¼°mysql:
±àÒë°²×°libmmseg:
./configure --prefix=/usr/local/mmseg && make -j5 && make instal ......
˵Ã÷: ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬
ΪISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
¡¾½â¾ö·½°¸¡¿
1. ´ò¿ªÎļþ: C:\Program Files\MySQL\MySQL Server 5.0\my.ini;
2. ½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312,
......
¡¡¡¡ÓÃC++²Ù×÷MySQLÊý¾Ý¿âÀࣺ
¡¡¡¡×¢ÊÍ£ºÕ⼸¸öÀà¶Ô´¦Àí²»ÊǺܴóÊý¾ÝÁ¿µÄ²Ù×÷ÊǺÜÀíÏëµÄ£¬ µ«²»ÊÊÒËÌØ´óÐ͵ÄÊý¾ÝµÄ²éѯ£¬ÒòΪԴÂëÖн«²éѯµ½µÄÊý¾ÝÖ±½Ó·ÅÈëÁËÄÚ´æ¡£
¡¡¡¡/*
¡¡¡¡* project:
¡¡¡¡* ͨÓÃÄ£¿é ( Óà c++ ´¦Àí mysql Êý¾Ý¿âÀ࣬ÏñADO )
¡¡¡¡*
¡¡¡¡* description:
¡¡¡¡*
¡¡¡¡* ͨ¹ýDataBase,Reco ......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊÇ°´°´Å¥»»ÒýÇ棻ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇ棬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ ......