Hello,
I have a Linux server running Apache, MySQL, unixODBC, MyODBC
In my odbcinst.ini file I have the following:
[MySQL] Description = ODBC for MySQL Driver = /usr/local/lib/libmyodbc3.so FileUsage = 1
I have setup the following system DSN in the odbc.ini file:
[PbDatabase] Description = System DSN Driver = /usr/local/lib/libmyodbc3.so Host = localhost Server = localhost User = username Password = password Port = 3306 Database = Database01 Option = 3
However, when I use the System DSN name in my scripts I get the following error:
350
Native SQL Error Code
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
The user apacheusr is the username that the Apache webserver is running under. I've tried adding this user to the MySQL user table but the error still shows.
However, if I add the Username and Password along with the DSN name to my scripts within my HTML pages then the connection is made and records from the database returned.
Any ideas why this might be happening?? Is it a permissions issue with MySQL or with unixODBC or Apache??
Any help would be greatly appreciated. Thanks in advance [EMAIL PROTECTED]
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.4.0 - Release Date: 22/02/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
