Re: PHP script cannot connect MySQL server

2004-03-23 Thread beacker
Sami Maisniemi <[EMAIL PROTECTED]> writes: > >It seems that the correct socket is used. Here is the output: > > > >unix 2 [ ACC ] STREAM LISTENING 3303 private/relay > >unix 2 [ ACC ] STREAM LISTENING 3307 public/showq ... >I tried to connect to socket #3307

Re: PHP script cannot connect MySQL server

2004-03-23 Thread jeffrey_n_Dyke
n Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote: > >> tcp0 0 *:3307 *:* > >> LISTEN > > > >It seems that the correct socket is used. Here is the output: > > > >unix 2 [ ACC ] STREAM LISTENING 3303 private/relay > >unix 2 [ ACC ] S

Re: PHP script cannot connect MySQL server

2004-03-23 Thread Sami Maisniemi
On Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote: > >> tcp0 0 *:3307 *:* > >> LISTEN > > > >It seems that the correct socket is used. Here is the output: > > > >unix 2 [ ACC ] STREAM LISTENING 3303 private/relay > >unix 2

Re: PHP script cannot connect MySQL server

2004-03-22 Thread beacker
Sami Maisniemi <[EMAIL PROTECTED]> writes: >> mysql> use mysql >> mysql> select User,Host,Password,Select_priv from user; >> >> which will show basic access capabilities for user/host/password > >Hmmm ... did not work as you can see: > >mysql> select User,Host,Password,Select_priv from user; >ERROR

Re: PHP script cannot connect MySQL server

2004-03-22 Thread beacker
>> tcp0 0 *:3307 *:* LISTEN > >It seems that the correct socket is used. Here is the output: > >unix 2 [ ACC ] STREAM LISTENING 3303 private/relay >unix 2 [ ACC ] STREAM LISTENING 3307 public/showq Looks

Re: PHP script cannot connect MySQL server

2004-03-22 Thread Sami Maisniemi
On Monday 22 March 2004 22:43, [EMAIL PROTECTED] wrote: > >specify how to check the socket, please? > > Based on your ps information, the socket will likely be in the > /usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way > to tell if there is a socket open for the server would b

Re: PHP script cannot connect MySQL server

2004-03-22 Thread beacker
Sami Maisniemi writes: >I think I am using root access, but should I create another user name for >MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I >view the user? from the mysql program: mysql> use mysql mysql> select User,Host,Password,Select_priv from user; which

Re: PHP script cannot connect MySQL server

2004-03-22 Thread beacker
>It seems that mysqld is up and running (view the results below), but could you >specify how to check the socket, please? Based on your ps information, the socket will likely be in the /usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way to tell if there is a socket open for th

Re: PHP script cannot connect MySQL server

2004-03-22 Thread B. van Ouwerkerk
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote: > Did you provide access to the databases as root? Is there a password > associated with access? For instance, how do you statr mysql from the > command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create

Re: PHP script cannot connect MySQL server

2004-03-22 Thread Sami Maisniemi
> Did you provide access to the databases as root? Is there a password > associated with access? For instance, how do you statr mysql from the > command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create another user name for MySQL? On the command lin

Re: PHP script cannot connect MySQL server

2004-03-22 Thread Sami Maisniemi
On Monday 22 March 2004 21:45, [EMAIL PROTECTED] wrote: > This error could result from a number of possible problems. First off I > would check to make sure the mysqld is running and attaching to the default > socket (3306). If you have it set up otherwise, you will likely need the > connect to c

Re: PHP script cannot connect MySQL server

2004-03-22 Thread Sami Maisniemi
On Monday 22 March 2004 20:36, [EMAIL PROTECTED] wrote: > This means that your server is not up, most likely. Can you connect from > the command line? try running > ps -efc | grep mys > > do you see an entry for mysqld? It seems that the server is up and running, because I am able to see mu

Re: PHP script cannot connect MySQL server

2004-03-22 Thread beacker
>I finally managed to install MySQL succesfully. I created a simple DB with two >different tables. I also created a simple PHP script to list all DBs and >tables. > >However, it seems that the PHP script cannot access MySQL server, because the >following error message is displayed: > >Warning: m

Re: PHP script cannot connect MySQL server

2004-03-22 Thread jeffrey_n_Dyke
I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: _ This

Re: PHP script cannot connect MySQL server

2004-03-22 Thread Rick Emery
mydatabase rick "People will forget what you said. People will forget what you did. But people will never forget how you made them feel." - Original Message - From: "Sami Maisniemi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 22, 2004 12:25 PM Su

PHP script cannot connect MySQL server

2004-03-22 Thread Sami Maisniemi
I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: Warning: mysql_con