Re: MySQL 3.23.39 shuts down by itself on Win2K
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, I've got a java application running with MySQL 3.23.39 on a Win2K server. No other application uses this MySQL server. And yesterday it just shut down without any reason. This is the second time. The first time was a few months back and I didn't pay attention to it. Does anyone have any explanation or similar experience and fix? Here is the related extract from mysql.err: -- 030331 9:14:13 db\mysql\bin\mysqld-opt: Normal shutdown 030331 9:14:14 db\mysql\bin\mysqld-opt: Forcing close of thread 569 user: 'testuser' 030331 9:14:14 Aborted connection 569 to db: 'testdb' user: 'testuser' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 030331 9:14:14 db\mysql\bin\mysqld-opt: Shutdown Complete -- It's very unlikely that a query caused MySQL to 'crash' or shut down by itself because there was no query at that time and the last query - 6mins before the shut down - was (and has always been) successfully performed without any problem. I've looked around on various web forums for anything similar but I've only gathered that this might be possible if the partition on which resides the data is full. But that is not the case with the machine. Anyway, there is no 'disk full' warning in the mysql.err file. The URL for this info is 'intermittently' available though: http://www.geocrawler.com/archives/3/108/2002/8/0/9430513/ No other place mentions about such problem. Could anyone kindly enlighten me :)? Many thanks, Al. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant connect to Mysql server on 'localhost' (10061)
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 +1000 Does anyone else get this message after installing and attempting to run mysql (version 4.0.12)?? I downloaded and installed mysql-4.0.12-win.zip file. then from the command prompt, I typed mysqld to start the service. Then I typed mysql and I got the error message: Cant connect to Mysql server on 'localhost' (10061) Am I doing something wrong ?? I checked and confirmed that mysql is running as a service on my PC, but I noted when using the winmysqladmin tool that no mysql server was being specified - probably the cuase of the problem, but how do I fix it. THanks to anyone that can help. Michael Hall Snr Web Developer Insurance Council of Australia Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to use GRANT for Network Client?(for newbie)
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 BY 'password'; It works pretty well on server machine. I've another machine with IP = 192.168.111.3. Do I need to set a grant such as GRANT ALL on TestDB.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Thank you. Terry _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Permission Setup
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 tried to log in as 'admin' using password to the same host. %mysql -u admin -network.srv -p password:** In this point the server said Access Denied to user [EMAIL PROTECTED], blablabla. Is there any mistake in my job? I'm using W2K server as OS. Thanks in advance, Terry. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Permission Setup
Dear Stefan, Sorry for incomplete information and also thank you for your help. Here is the recent condition .. --- mysqlstatus; - mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98(i32) Connection id: 338 Current database: mysql Current user: [EMAIL PROTECTED] SSL:Not in use Server Version: 4.0.12-nt Protocol version: 10 Connection: localhost via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: 3306 Uptime: 5 hours 42 min 38 sec Threads: 1 Questions: 1796 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables:0 Queries per second avg: 0.087 - mysqlGRANT ALL ON Security.* to [EMAIL PROTECTED] Identified by 'password'; Query OK, 0 rows affected(0,00 sec) mysqlexit Bye C:\mysql\binmysql -h network.srv -u newbuddy -p password ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Help me please. with Regards, Terry From: Stefan Hinz [EMAIL 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 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. Let's suppose your GRANT statement was okay. Better if you would provide the statement you issued. I tried to log in as 'admin' using password to the same host. %mysql -u admin -network.srv -p password:** That should be mysql -u admin -h network.srv -p. Let's assume you specified that. In this point the server said Access Denied to user [EMAIL PROTECTED], blablabla. That blablabla might hold some information worth posting. Is there any mistake in my job? I'm using W2K server as OS. When asking a question like that, you should provide information like the following sessions info: mysql STATUS; -- mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32) Connection id: 7 Current database: GuideProf Current user: [EMAIL PROTECTED] SSL:Not in use Server version: 4.0.10-gamma-max-nt-log Protocol version: 10 Connection: localhost via TCP/IP Client characterset:latin1_de Server characterset:latin1_de TCP port: 3306 Uptime: 1 day 1 hour 18 min 47 sec Threads: 1 Questions: 226 Slow queries: 10 Opens: 102 Flush tables: 1 Open table -- mysql GRANT ALL ON test.* TO 'someoneelse'@'localhost' IDENTIFIED BY 'youwontguess'; Query OK, 0 rows affected (0.19 sec) mysql EXIT Bye C:\mysql\binmysql -h localhost -u someoneelse -pyouwontguess Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 to server version: 4.0.10-gamma-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql USE mysql; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' mysql USE test; Database changed Look at the last couple of lines. They show that the privileges were granted as expected. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on MySQL, MyODBC VC++
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 MySQL bulid-in database in the same way. It works very well. I think it is because of security matter. Help me solve the problem please. *I create a DSN in in ODBC management. I didn't forget. Thank in Advance. Terry _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]