Re: [PHP-DB] diferent user passwords

2001-04-13 Thread Jeffrey A Schoolcraft
* Romeo Manzur ([EMAIL PROTECTED]) wrote: how could I configure diferent user password to each database on my server??? You can probably achieve this with grant statements. Grant SELECT on test.* to myuser@localhost identified by 'pass1'; Grant SELECT on other.* to myuser@localhost

Re: [PHP-DB] SELECT statement

2001-04-05 Thread Jeffrey A Schoolcraft
* Julio Cuz, Jr. ([EMAIL PROTECTED]) wrote: Ron, Thanks for your help, but my problem still there even when I made the following changes: $sql = "SELECT * FROM \"Remodel\" WHERE Email=\"".$find."\""; You don't have to quote the table name either. You can probably get away with

Re: [PHP-DB] Problems with MySQL

2001-04-03 Thread Jeffrey A Schoolcraft
* Bruno ([EMAIL PROTECTED]) wrote: The strange thing about this is that MySQL leaves the mysqld.sock in /tmp, not in the directory that the error reports. I've just installed MySQL v3.23, and I had v3.22 before, which had it's sock file on /var/run/mysqld. You might want to make sure your