Akses MySQL Server dari remote komputer

Menanggapi bbrp pertanyaan teman2 saya, mengenai bagaimana cara setting MySql Server biar bisa di-akses dari remote komputer?
Berikut caranya
1. Masuk ke MySql Server Management, biasanya alamatnya di http://localhost:8080/phpmyadmin/
2. Klik Privileges
3. Klik Add a new User
4. Pada bagian Login Information, isi dgn sbb :
- UserName - Use Text Field = "nama user"
- Host - Any host = ""
- Password - Use Text Field = "password"
- Re-type = "password"

5. Pada bagian Global privileges, silahkan pilih sesuai kebutuhan.
6. Klik Go

Oke, demikian
Semoga membantu

Setting "Execution Time Out"

If you find an error with the message "Execution Time Out", was one reason is the connection to the database that is too long.

By default, a web server in the Timeout setting is 30 seconds max. Once there is a database connection that is more than 30 seconds, then the error message will be sent.

Then how do we want to enlarge this timeout, for example 60 seconds. The following piece of c# code themselves:

using (SqlConnection conn = new SqlConnection("ConnectionString"))

{

conn.Open();

SqlCommand cmd = new SqlCommand(SpName, conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandTimeout = 60; //add timeout here

SqlParameter[] sqlParameter = new SqlParameter[2];

sqlParameter[0] = new SqlParameter("@MhsId", SqlDbType.Char, 10);

sqlParameter[0].Direction = ParameterDirection.Input;

sqlParameter[0].Value = mhsId;

sqlParameter[1] = new SqlParameter("@PriodId", SqlDbType.Char, 25);

sqlParameter[1].Direction = ParameterDirection.Input;

sqlParameter[1].Value = periodId;

cmd.Parameters.AddRange(sqlParameter);

using (SqlDataReader sqlDataReader = cmd.ExecuteReader())

{

}

}

Ok, may it helps

Thanks