Re: MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Terrance Win
It seems "The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests." From: "Al Caponi" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Subject: MySQL 3.23.39 shuts down by itself on Win2K Date: Wed, 2 Apr 2003 18:12:51 +0800 Hi all

Re: Cant connect to Mysql server on 'localhost' (10061)

2003-03-31 Thread Terrance Win
check this first in command prompt "mysqladmin ping". You should receive "Mysql is alive". Otherwise you have to start your service. From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Subject: Cant connect to Mysql server on 'localhost' (10061) Date: Mon, 31 Mar 2003 12:11:32

How to use GRANT for Network Client?(for newbie)

2003-03-28 Thread Terrance Win
Hello Everybody, I have a MySQL server in my W2K server DNS=Network.srv. User name 'Admin' and password ='password' is for Admin purpose in Server. Database name = 'TestDB' IP for server = 192.168.111.2 So I set up grant GRANT ALL on TestDB.* TO [EMAIL PROTECTED] IDENTIFIED B

Re: Permission Setup

2003-03-25 Thread Terrance Win
L PROTECTED]> Reply-To: Stefan Hinz <[EMAIL PROTECTED]> To: "Terrance Win" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: Permission Setup Date: Tue, 25 Mar 2003 21:00:00 +0100 Terry, > I 've a problem with permission setup. In my newly install MySQL &

Permission Setup

2003-03-25 Thread Terrance Win
Dear Experts, I 've a problem with permission setup. In my newly install MySQL server; First, I log into as 'root' and create a database, lets say 'myDB'. Then I Grant a user name 'admin' with password to that database'myDB' in hostname 'network.srv'. Then I log out from root account. I

Question on MySQL, MyODBC & VC++

2003-03-24 Thread Terrance Win
Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named "Log" and tried to connect from my project in VC++ via MyODBC. But my program get a runtime error when it try to open the database. I used CRecordset class to open it. Then I tried to open My