1.访问云服务器:云服务器端需在防火墙设置中添加mysql协议规则(放开端口默认为3306)。
2.访问云服务器:修改云服务器数据库访问权限
3.c#连接实例
try{DataTable dt = new DataTable();string ConnectionStr = "server=" + "xxx.xxx.xxx.xxx" + ";User ID=root;Password=123456;database=mydatabase;Allow User Variables=True;SslMode=none;";MySqlConnection conn = new MySqlConnection(ConnectionStr);conn.Open();string sSQL = "select *from mytable2";MySqlCommand cmd = new MySqlCommand(sSQL, conn);MySqlDataReader dr = cmd.ExecuteReader();if (dr.HasRows){//读取MySqlDataReader里的内容 dt.Load(dr);}//关闭对象和连接 dr.Close();this.dataGridView1.DataSource = dt;}catch(Exception ee){}
4.my.ini文件实例
# For advice on how to change settings please see#/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.basedir =C:\mysql-5.6.40-winx64datadir = C:\mysql-5.6.40-winx64\dataport = 3306# server_id = .....# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES