C#.NETÁ¬½Ómysql·½·¨
mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin";
MySqlConnection mycn = new MySqlConnection(myConnectionString);
try
{
mycn.Open();
Response.Write("<mce:script type="text/javascript"><!--
alert('Á¬½Ó³É¹¦')
// --></mce:script>");
}
catch (Exception ex)
{
Response.Write("<mce:script type="text/javascript"><!--
alert(" ex.ToString() ")
// --></mce:script>");
}
}
}
Ò²¿ÉÒÔÅäÖÃapp.config (web.config):
<appSettings>
<add key="Con" value="Provider=MySQLProv;Data Source=test;User Id=root;Password=admin;pooling=false;CharSet=utf8;port=3306"/>
</appSettings>
Ïà¹ØÎĵµ£º
ÖØÐ°²×°£¬³öÏÖ/etc/init.d/mysql: line 115: /etc/mysql/debian-start: ûÓиÃÎļþ»òĿ¼
invoke-rc.d: initscript mysql, action "start" failed.
ʹÓÃÃüÁsudo aptitude purge mysql-server mysql-server-5.0
È»ºóÔÚÖØÐ°²×°....
apt-get install mysql-server-5.0 ......
winform주
//´æ´¢
private void MemoryImage()
{
string sql = "";
&nbs ......
1¡¢LinuxÏÂmysql°²×°ÍêºóÊÇĬÈÏ£ºÇø·Ö±íÃûµÄ´óСд£¬²»Çø·ÖÁÐÃûµÄ´óСд£»
2¡¢ÓÃrootÕʺŵǼºó£¬ÔÚ/etc/my.cnf ÖеÄ[mysqld]ºóÌí¼ÓÌí¼Ólower_case_table_names=1£¬ÖØÆôMYSQL·þÎñ£¬ÕâʱÒÑÉèÖóɹ¦£º²»Çø·Ö±íÃûµÄ´óСд£»
lower_case_table_names²ÎÊýÏê½â£º
lower_case_table_names = 0
ÆäÖÐ 0£ºÇø·Ö´óСд£¬1 ......
Æô¶¯£ºnet start mySql;
¡¡¡¡½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
¡¡¡¡ÁгöÊý¾Ý¿â£ºshow databases;
¡¡¡¡Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
¡¡¡¡Áгö±í¸ñ£ºshow tables£»
¡¡¡¡ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
¡¡¡¡½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
¡¡¡¡Æ¥Åä× ......