Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
DynPHP
- Forum Newbie
- Posts: 10
- Joined: Tue Mar 04, 2003 8:25 am
Post
by DynPHP »
Has anyone done this, we keep getting an authentification error. Am using ODBC connection to connect from the database to the windows box.
Error I get:
Code: Select all
[ODBC 3.51 Driver]Access denied for user:'user name@ip address'(Using Password:Yes)
-
Stoker
- Forum Regular
- Posts: 782
- Joined: Thu Jan 23, 2003 9:45 pm
- Location: SWNY
-
Contact:
Post
by Stoker »
You have to grant access to the table for the user to access it from the host you are connecting from
USE databasename
GRANT SELECT ON table TO 'user'@'hostname' IDENTIFIED BY 'password'