mysql Ô¶³ÌÁ¬½ÓÎÊÌâ¡£
ÎҵijÌÐòÔÚд´úÂëµÄµçÄÔÉÏÓÃÁ¬½Óµ½ Ô¶³ÌµÄ¿Í»§¶Ë£¬µ«ÊÇÄõ½ÆäËû»úÆ÷ÉϾͱ¨
Client does not support authentication protocol requested by server
ÎÒ°´ÕÕÍøÉÏËÑË÷µÄ·½·¨¸ÄÁË
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Æä¶þ:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
½á¹û²»µ«Ã»Óã¬Á¬±¾À´ÄÜÁ¬µÄµçÄÔ Ò²ÌáʾÃÜÂë´íÎ󡣡£¡£¡£¡£¡£
ÇëÎÊÕâÊÇÔõô»ØÊ£¿
»ØÂ¥Éϵģ¬ ÎÒÓÃµÄ mysql C API Á¬½ÓµÄÓ¦¸Ã²»Òª Çý¶¯°¡
ÎÊÌâ½â¾öÁË£¬ÊÇÎÒ×Ô¼º´úÂëµÄÎÊÌâ¡£ ÈÔȻддÉϱßÅóÓѵİïÖú¡£·Ö¸øÁË
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......