手动安装教程:http://www.cnblogs.com/happyty/p/4131686.html
alter table
表名
AUTO_INCREMENT=10000; //修改主键自动增长开始值
SELECT COUNT(1) FROM AccountsInfo WHERE Account='大家好' //选出有这个账号名的个数,没有为0
set @aaa=0; SELECT max(id) into @aaa from 表名; //把ID最大的值给变量@aaa
set @aaa=(SELECT max(id) into @aaa from 表名;) //把ID最大的值给变量@aaa
-------------------------类型-----------------------------------------
timestamp 时间戳
---------------------------MYSQL函数-----------------------------------
CURRENT_TIMESTAMP 返回当前时间戳
CONCAT('我是',123456) //连接函数
------IF--Else-EndIF---------
IF EXISTS (语句)
Then 语句
Else 语句
End if
------.net操作MYSQL存储过程-------
using MySql.Data.MySqlClient;
using System.Data;
MySqlConnection con = new MySqlConnection("server=localhost;userid=root;password=123456;database=game;port=3306");
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = "RegisterAccount";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Account", MySqlDbType.VarChar, 32);
cmd.Parameters.Add("LogonPassword", MySqlDbType.VarChar, 32);
cmd.Parameters.Add("strMessage", MySqlDbType.VarChar, 32);
//为参数赋值
cmd.Parameters["Account"].Value = "注册账号";
cmd.Parameters["LogonPassword"].Value = "123456";
//设置参数的类型为输出参数,默认情况下是输入
cmd.Parameters["strMessage"].Direction = ParameterDirection.Output;
//执行 返回影响的行数
int temp= cmd.ExecuteNonQuery();
//得到输出参数的值,把赋值给name,注意,这里得到的是object类型的,要进行相应的类型轮换
string name = cmd.Parameters["strMessage"].Value.ToString();
-----------------------------配合DbHelperMySQL.cs执行带参数SQL-----------------------------
//注册账号
public static int RegisterAccount(string Account, string LogonPassword)
{
MySqlParameter[] parameters = {
new MySqlParameter("@Account", MySqlDbType.VarChar,32),
new MySqlParameter("@LogonPassword", MySqlDbType.VarChar,32)};
parameters[0].Value = Account;
parameters[1].Value = LogonPassword;
return DbHelperMySQL.ExecuteSql("Call RegisterAccount(@Account,@LogonPassword)", parameters);
}
-------------------------------MYSQL取消,添加用户远程连接权限---------------------------------
CMD
F:
cd F:\MySQL\bin
mysql -u root -p"密码" //登陆MYSQL
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; //给root用户授权所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '密码' WITH GRANT OPTION; //给root用户授权所有权限,只限于IP 127.0.0.1
update user set host = "localhost" where user = "root" and host= "%"; //关闭root用户远程连接权限
FLUSH PRIVILEGES; //刷新授权表
exit