Êý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«(MySQL)
Êý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«(MySQL)
MyODBC
MyODBC 2.50 Local database:
"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"
MyODBC 2.50 Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
MyODBC 3.51 Local database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"
MyODBC 3.51 Remote database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"
OLE DB, OleDbConnection (.NET)
Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
Connector/Net 1.0 (.NET)
Standard:
"Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"
Download the driver at MySQL Developer Zone.
Specifying port:
"Server=Server;Port=1234;Database=Test;Uid=UserName;Pwd=asdasd;"
Default port is 3306. Enter value -1 to use a named pipe connection.
Declare the MySqlClient connection:
C#:
using MySql.Data.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;";
oMySqlConn.Open();
VB.NET:
Imports MySql.Data.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"
oMySqlConn.Open()
MySqlConnection (.NET)
eInfoDesigns.dbProvider:
"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
Declare the MySqlConnection:
C#:
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connection string";
oMySqlConn.Open();
VB.NET:
Imports eInfoDesigns.dbProvider.MySqlCl
Ïà¹ØÎĵµ£º
³£ÓÃMySQLµÄͯЬ¶¼ÖªµÀÕâ¸ömyisamÀàÐÍµÄ±í¼«ÈÝÒ×Ë𻵣¬¶àÊýÈË¿ÉÄܶ¼ÊÇÓÃmyisamchkÃüÁîÀ´È˹¤ÐÞ¸´£¬ÏÂÃæ½éÉÜÒ»ÖÖ×Ô¶¯ÐÞ¸´myisamµÄ·½·¨£¬Ò²ÊÇÎÒÉÏÎç¸ÕѧµÄ£¬¹²Í¬½ø²½£¬ºÇºÇ~
ÔÚMySQLµÄÅäÖÃÎļþmy.cnfÖУ¬Æô¶¯Ï·Ö¼ÓÈëmyisam-recoverÉèÖÃÊý¾Ý»Ö¸´¹¦ÄÜ£¬¾ßÌå ......
mysql
ÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚmysql
Æô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 10
log-slow-queries =
long_query_time
ÊÇÖ¸Ö´Ðг¬¹ý¶à¾ÃµÄsql»á±»logÏÂÀ´£¬ÕâÀïÊÇ10Ãë¡£
log-slo ......
¹Ø¼ü×Ö: key×Ö¶ÎÊÇmysqlÀïÃæµÄ¹Ø¼ü×Ö
insert into app(name,created,key,secret,masterSecret) values ('aa',null,null,null,null);
ÒòΪÕâÀïµÄkey×Ö¶ÎÊÇmysqlµÄ¹Ø¼ü×Ö£¬ËùÒÔÒ»Ö±²å²»½øÈ¥¡£
ÐÞ¸ÄÈçÏÂ:ÔÚkeyµÄÍ·ÉϼÓÉÏÁ½µã(·´ÒýºÅ£¬ËüÔÚ¼üÅ̵Ä~Õâ¸ö¼üÉÏ)¡£¼´¿É¸ã¶¨
sql½¨±íÈçÏ£º
Java´úÂë
CREATE T ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
1)
°²×°Apache/2.2.14 ºÍ PHP/5.2.12 Ö®ºó£¬ÖØÐÂÆô¶¯Apache£¬Æô¶¯Ê§°Ü¡£²éÁËһЩ×ÊÁÏ£¬»ù±¾Éϸø³öµÄ½¨ÒéÊǽûµôExtension¡£ÎÒ¾Í×°ÁËÒ»¸öExtesion Mysqli¡£
ÐÞ¸Äphp.ini ×¢Ê͵ôÕâÒ»ÐУ¬¹ûÈ»ÉúЧ¡£
[PHP_MYSQLI]
;extension=php_mysqli.dll
°²×°Íêmysql£¬ÔÙÖØÐÂenableÕâ¸öÅäÖþͺÃÁË£¬¹À¼ÆÊÇÒÀÀµÄ³Ð©mysqlµÄ¿â¡£
......