VCµ¥ÎļþÁ¬½ÓMYSQLʾÀý£¬¶ªµôlibmysql.dll.
ÍøÉϺܶàVCÁ¬½ÓmysqlµÄÀý×Ó¶¼ÊÇÒª´ø¸ölibmysql.dll²ÅÄÜÕý³£Ê¹Óõġ£
µ«ÓÐʱÎÒÃDz¢²»Ïë¶à´ø¸ölibmysql.dll£¬Ö»Ïëµ¥Îļþ¾ÍÄÜʹÓûòÕßÄãÊÇÒª
·â×°ÔÚÒ»¸ödllÎļþÀÕâʱÄãÒª¾ÍÓõ½mysqlclient.libÕâ¸ö¾²Ì¬¿âÁË¡£
ʾÀý´úÂëÈçÏ£¬ºÜºÜ¼òµ¥£¬¾Í²»¶à˵ÁË¡£
Ïà¹ØµÄmysqlÍ·Îļþ¼°¾²Ì¬¿â£º
http://download.csdn.net/source/1047386
#include "stdafx.h"
#include <windows.h>
#include <winsock2.h>
#include "mysql\include\mysql.h"
//ºöÂÔLIBCMT.lib, MSVCRTD.libÕâЩ¿â£¬²»È»Á´½Óʱ»á±¨lnk2005´íÎó
#pragma comment(linker,"/nodefaultlib:LIBCMT.lib")
#pragma comment(linker,"/nodefaultlib:MSVCRTD.lib")
/*ÓÃmysqlclient.lib,²»ÒªÓÃlibmysql.lib,Òª²»ÄãÒª¶à´øÒ»¸ölibmysql.dll
¾²Ì¬¿âÓÐÁ½¸ö£¬Ò»¸öÊÇdebug°æµÄ£¬Ò»¸öÊÇrelease°æµÄ£¬Òª×¢Òâ
*/
#if defined _DEBUG
#pragma comment(lib, "mysqlclient_debug.lib")
#else
#pragma comment(lib, "mysqlclient.lib")
#endif
#pragma comment(lib, "wsock32.lib")
#pragma comment(lib, "Advapi32.lib")
int _tmain(int argc, _TCHAR* argv[])
{
MYSQL* mysql = NULL;
mysql = mysql_init(mysql);
MYSQL_RES* res;
MYSQL_ROW record;
mysql_real_connect(mysql, "192.168.0.240", "root","root", "amx", 3306, NULL, NULL);
mysql_query(mysql, "select auth, password, access from admins where length(access)>3");
res = mysql_store_result(mysql);
while((record=mysql_fetch_row(res)))
{
printf("auth=%s,password=%s,access=%s\n", record[0], record[1], record[2]);
}
mysql_free_result(res);
mysql_close(mysql);
return 0;
}
Ïà¹ØÎĵµ£º
Linux + Apache2.0 + Mysql + PHP + phpBB3.0
1.°²°ü£º
Apache2.0
#tar -zxf httpd-***.tar.gz -C /usr/local/src/
#cd /usr/local/src/httpd-***
  ......
×î´óµÄÎïÆ·ºÅÊÇʲô£¿
SELECT MAX(article) AS article from shop;
ÈÎÎñ£ºÕÒ³ö×î¹óÎïÆ·µÄ±àºÅ¡¢ÏúÊÛÉ̺ͼ۸ñ¡£
ÕâºÜÈÝÒ×ÓÃÒ»¸ö×Ó²éѯ×öµ½£º
SELECT article, dealer, price
from shop
WHERE price=(SELECT MAX(price) from shop);
ÁíÒ»¸ö½â¾ö·½°¸ÊÇ°´¼Û¸ñ½µÐòÅÅÐòËùÓÐÐв¢ÓÃMySQLÌض¨LIMIT×Ó¾äÖ» ......
1¡¢´´½¨mysqlÊý¾Ý¿âµÄ¹ÜÀíÓû§
Êý¾Ý¿â°²×°ºÃºó£¬ÎÒÃÇÓ¦¸ÃΪmysqlÊý¾Ý¿â´´½¨Ò»¸ö¹ÜÀíÕʺš£Òª°ÑrootÓû§ÉèÖÃΪ¹ÜÀíÔ±£¬´ËʱÐèÒªÖ´ÐÐÏÂÃæÃüÁ
[root@CDS2 bin]# /usr/bin/mysqladmin -u root password 123456
˵Ã÷£ºÉÏÃæ´´½¨µÄmysqlÊý¾Ý¿â¹ÜÀíԱΪroot£¬ÃÜÂë123456
2¡¢´´½¨Ò»°ãµÄÓû§
¹¤×÷ÖÐÓõ½web·þÎñÆ÷ºÍmysql·þÎñÆ ......
1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......
½ñÌìÐèÒª´ÓÔ¶³Ì·þÎñÆ÷downÒ»¸öuchomeµÄÊý¾Ý¿âÏÂÀ´£¬ÔÚ±¾µØ»¹Ô¡£
·¢ÏÖÒ»¸öºÜ²»Ë¬µÄÊÂÇ飺Զ³Ì8G£¬NºËµÄlinux»úÆ÷£¬±¸·Ý»¹Ô²Ù×÷˳ÁïÁïµÄ£¬¿ÉÊÇÔÚ±¾µØµÄwindows£¬2GÆÕͨPCÉÏ£¬²Å100MµÄÎļþ£¬ÓÃuchome×Ô´øµÄ·Ö¾í±¸·Ý»¹Ô£¬»ù±¾ÉÏÖм䶼»á¶Ïµô£¬ÒªÃ´Ìáʾ“Ö´ÐÐʱ¼ä¹ý³¤”£¨¸Ä³É200Ã룬·Ö¾íΪ20M¶¼²»ÐУ©£¬ÒªÃ´¾ÍÊ ......