[PHP-DB] mysl_connect question

2003-04-05 Thread [EMAIL PROTECTED]
When I use myssql to connect to a db with anything besides root I get an
error that I cannot connect.  I created a user that has access to one
databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions
for that database. 

I can connect on the command line: mysql-u newuser -p.  But no luck using
mysql_connect().

Anyone have this problem?


.T


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] mysl_connect question

2003-04-05 Thread Larry E. Ullman
First, please don't cross-post. The PHP-DB list is the proper one for 
this question.

If you can connect via the mysql monitor but not with PHP, I expect the 
problem has to do with your host.

Larry

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] mysl_connect question

2003-04-05 Thread John W. Holmes
 When I use myssql to connect to a db with anything besides root I get
an
 error that I cannot connect.  I created a user that has access to one
 databse called 'menu'. The user has SELECT, UPDATE, and DELETE
permissions
 for that database.
 
 I can connect on the command line: mysql-u newuser -p.  But no luck
using
 mysql_connect().

You probably do not have the correct 'host' given for the user. What's
the complete error message? It usually says something like Access
denied for [EMAIL PROTECTED] ... Make sure the user you added matches the host
given in the error message. 

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php