Re: Re: Adding new users

2002-05-14 Thread Egor Egorov
Todd, Monday, May 13, 2002, 7:18:11 PM, you wrote: TC> Where is the user table? Table 'user' is located in database 'mysql'. It's one of the table that MySQL uses for user identification. Some more details about user identification and privilege system in MySQL you can find at: ht

Re: Re: Adding new users

2002-05-13 Thread Mark
Todd wrote: > TC> The error is a timeout with the following message > TC> and I think the answer is right in front of me: > TC> need to open port 110. Could that be true? No. Port 110 is used for POP. Barring any unforeen setup, the MySQL daemon runs on port 3306. > TC> Warning: Can't connect

Re: Adding new users

2002-05-13 Thread Todd Cary
Where is the user table? Can it be viewed? How can I tell what is in it with mysqladmin? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please c

Re: Re: Adding new users

2002-05-13 Thread Egor Egorov
Todd, Monday, May 13, 2002, 4:44:30 PM, you wrote: TC> Egor - TC> Here is the code: TC>$link = mysql_connect("209.204.172.122", "root", "mypassword"); TC> if ($link) { TC> print("Connected"); TC> } else { TC> print("Cannot connect"); TC> } ?>> TC> The error is a timeout with

RE: Adding new users

2002-05-13 Thread Tewfic Kidess
al 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: "); } else { print("Cannot connect"); } ?> The error is a timeout with the following me

Re: Adding new users

2002-05-13 Thread Todd Cary
Egor - Here is the code: "); } else { print("Cannot connect"); } ?> 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 po

Re: Adding new users

2002-05-13 Thread Todd Cary
Whps! I am using PHP on a Linux platform. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] Georg Richter wrote: > On Monday, 13. May 2002 07:06, Todd Cary wrote: > Hi, > > > However this does not work in a script: > > > > mys

Re: Adding new users

2002-05-13 Thread Egor Egorov
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

Re: Adding new users

2002-05-12 Thread Georg Richter
On Monday, 13. May 2002 07:06, Todd Cary wrote: Hi, > However this does not work in a script: > > mysql_connect("209.204.172.122", "root", "mypassword"); > > What am I missing? What script do you use? Which language? Georg - B