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:

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 #

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:

Re: Adding new users

2002-05-13 Thread Todd Cary
Egor - Here is the code: ? $link = mysql_connect(209.204.172.122, root, mypassword); if ($link) { print(Connectedbr); } else { print(Cannot connectbr); } ? 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.

RE: Adding new users

2002-05-13 Thread Tewfic Kidess
- 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(Connectedbr); } else { print

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 ? TC $link = mysql_connect(209.204.172.122, root, mypassword); TC if ($link) { TC print(Connectedbr); TC } else { TC print(Cannot connectbr); TC } ? TC The error is a timeout with the

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

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 to

Adding new users

2002-05-12 Thread Todd Cary
1) Can I add new users with mysqladmin? 2) With mysqladmin as root I can get a response to # /usr/bin/mysqladmin -pmypassword ping However this does not work in a script: mysql_connect(209.204.172.122, root, mypassword); What am I missing? Todd -- Todd Cary Ariste Software 2200 D Street

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 - Before