Re: mysql socket problem in win98 (thanks for the help!)
First of all, thanks to everyone for no reply and no help! If someone is interested, I've found that i Win9x systems, if there are persistent connections open, the system instead of used the same opened connection for the same session, it opens a new connection for each script call, and, because it can't close persistent connections, (the port has always estabilished connection), it ever opens new port connection to the 3306 (Mysql server), while it reachs the open port limit. So, it's impossible to make new connections with servers. Ciao __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: mysql socket problem in win98 (thanks for the help!)
At 13.49 20/10/2002 +0200, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: First of all, thanks to everyone for no reply and no help! If someone is interested, I've found that i Win9x systems, if there are persistent connections open, the system instead of used the same opened connection for the same session, it opens a new connection for each script call, and, because it can't close persistent connections, (the port has always estabilished connection), it ever opens new port connection to the 3306, while it reachs the open port limit. So, it's impossible to make new connections with servers. Ciao __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità . http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità . http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql socket problem in win98
HI, I'm on a win98 2ED system, running - Apache 1.3.26 + php 4.2.3 - Mysql 3.23.52 (started server is mysqld) I'm running some php scripts, that works with a database. Every script, makes a db_connect. It happens that, after a certain time (I don't know how much, and I don't know if it really involved), and/or after a certain number (I don't know how much again!) of operations, win98 begins to open a new connection to the 3306 port (mysqld) for each db operation!. After that, it's merely a question of time, and when the connections become so many, it becomes impossible to connect to any port. I'm asking for your help bacause I don't know what to do. Thanks in advance. Carlo __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with win98
Pada Thu, 25 Jul 2002 11:44:26 -0400 [EMAIL PROTECTED] menulis : Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? make sure your mysqld is running ;-) run ms dos prompt go to mysql bin directory run : mysqladmin -uroot password your_new_password_for_root_user after that, you have to use user root and the password to login, don't forget to create new users if necessary. to login with password : mysql -uusername -p -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 34 days, Queries : 355.101 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with win98
Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? Alex __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with win98
Hi. On Thu 2002-07-25 at 11:44:26 -0400, [EMAIL PROTECTED] wrote: Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? Please read the manual, section post-installation. You have to set a password for the root user. (a message after installation should have told you so) MySQL comes with permissive default privileges (without password) for localhost to ease first usuage. Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
