MysqlÏà¹Ø
1¡¢°²×°Ä¿Â¼:
½«my.iniÖÐ:
datadirµÄÖµ¸ü¸ÄΪ£º"sql/data/"
basedirµÄÖµ¸ü¸ÄΪ£º"sql"
2¡¢½øÈësql/data/"£¬É¾³ýÎļþ¼ÐÍâµÄËùÓÐÎļþ¡£
net start mysql»Ø³µ……
×¢ÒâбÏß/
ÐÞ¸Äpswd
·½·¨1£ºmysqladmin -u root -p "old password" "new password" (´ËÃüÁîÎÞ·¨°ÑÃØÃÜÇå¿Õ)
·½·¨2£ºÖ±½Ó½øÈëmysqlÊý¾Ý¿â£¬ÐÞ¸Äuser±íÖеÃÃÜÂë(¼ÓÃÜÃÜÂ룬ֱÊʺÏÇå¿Õ)¡£
mysql -u root -p (´ËÃüÁî¿É½øÈëmysqlÐèÊäÈëÃÜÂë)
“SET PASSWORD FOR root@localhost = OLD_PASSWORD('passwd');”
Ïà¹ØÎĵµ£º
Îļþphp.ini·ÅÈëwindowsÏ£¬½«ÏÂÃæÄÚÈÝ¿½±´µ½¼Çʱ¾ÃüÃûΪphp.ini·ÅÈëc:/windowsÏÂ,ÖØÆôApache server£º
[PHP]
;;;;;;;;;;;
; WARNING ;
;;;;;;;;;;;
; This is the default settings file for new PHP installations.
; By default, PHP installs itself with a configuration suitable for
; development purposes ......
(1)
´æ´¢¹ý³ÌÊÇÊý¾Ý¿â·þÎñÆ÷¶ËµÄÒ»¶Î³ÌÐò.
mysqlµÄ´æ´¢¹ý³Ì,Ö»Óа汾ÊÇmysql5.0»òÒÔÉϵIJÅÓдËÌØÐÔ.
(2)
ʲôʱºòÐèÒªÓô洢¹ý³Ì
´æ´¢¹ý³Ìͨ³£ÊÇһЩ¾³£ÒªÖ´ÐеÄÈÎÎñ£¬ÕâЩÈÎÎñÍùÍùÊÇÕë¶Ô´óÁ¿µÄ¼Ç¼¶ø½øÐеġ£ÔÚ·þÎñÆ÷ÉÏÖ´Ðд洢¹ý³Ì£¬¿ÉÒÔ
¸ÄÉÆÓ¦ÓóÌÐòµÄÐÔÄÜ¡£ÕâÊÇÒòΪ£º
2.1.
·þÎñÆ÷ÍùÍù¾ßÓÐÇ¿´óµÄ¼ÆËãÄÜÁ¦ºÍËÙ ......
ÏÈÇ°ÔÚ²âÊÔmysql connect c++½Ó¿ÚµÄʱºòÔËÐÐÆä¹Ù·½ÌṩµÄÀý×Ó
21.5.5.6. MySQL Connector/C++ Complete Example 2
The following code shows a complete example of how to use MySQL Connector/C++:
/* Copyright 2008 Sun Microsystems, Inc.
This program is free software; you can redistribute it and/or modify ......
ÅäÖø´ÖÆ
1.ÅäÖÃserver-idºÍlog-bin
2.Ö÷¿âÖÐÌí¼ÓÓÃÓÚ¸´ÖƵÄÓû§
GRANT REPLICATION SLAVE,reload,super ON *.*
TO 'repl'@'%.vm.dba.com' IDENTIFIED BY 'slavepass'
3.ÔÚ´Ó¿âÉÏÉèÖÃÓÃÓÚ¸´ÖƵÄÑ¡Ïî
server-id
master-host
master-user
master-password
--read-only ¸ÃÑ¡ÏîÈôӷþÎñÆ÷Ö»ÔÊÐíÀ´× ......
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON bankaccount.*
-> TO 'custom'@'localhost'
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INS ......