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 Á¬½ÓµÄÓ¦¸Ã²»Òª Çý¶¯°¡
ÎÊÌâ½â¾öÁË£¬ÊÇÎÒ×Ô¼º´úÂëµÄÎÊÌâ¡£ ÈÔȻддÉϱßÅóÓѵİïÖú¡£·Ö¸øÁË
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......