This problem happened to me when i first installed mysql, basically you need to add root to the user table of mysql. The first time you log in, password is not set so you log into the system with and hit 'enter', blank for a password, then you have to set password...
-----Original Message----- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 8:45 AM To: Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: Adding new users Egor - Here is the code: <? $link = mysql_connect("209.204.172.122", "root", "mypassword"); if ($link) { print("Connected<br>"); } else { print("Cannot connect<br>"); } ?> The error is a timeout with the following message and I think the answer is right in front of me: need to open port 110. Could that be true? I check my router and see if it has port 110 open - with Interbase, it is port 3050. Warning: Can't connect to MySQL server on '209.204.172.137' (110) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] Egor Egorov wrote: > Todd, > Monday, May 13, 2002, 8:06:03 AM, you wrote: > > TC> 1) Can I add new users with mysqladmin? > > Nope. You can only set new password for existing user with mysqladmin, > look at: > http://www.mysql.com/doc/m/y/mysqladmin.html > > TC> 2) With mysqladmin as root I can get a response to > > TC> # /usr/bin/mysqladmin -pmypassword ping > > TC> However this does not work in a script: > > TC> mysql_connect("209.204.172.122", "root", "mypassword"); > TC> What am I missing? > > What error did you get? > > TC> Todd > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
