Posted by: keithh0427 (---.dcvast.com)
Date: September 11, 2006 07:22PM

Hello all,

I have searched the forums for an anwer to my question and have found some related entries, butno definative response.

I keep getting the proverbial error:

[11-Sep-2006 11:59:35] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ODBC'@'localhost' (using password: NO)
[11-Sep-2006 11:59:35] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource

I can see the users and databases that are available to me using phpMyAdmin. I can even see the ODBC user. I've tried deleting that user and giving permissions to that user, but to no avail.

However, I cannot see my databases when I use SQLiteManager. I only see the "test" database. I've tried adding databases using SQLiteManager, but that doesn't work either.

I have been using Navicat to build and edit the databases and phpMyAdmin doesn't seem to care. However, php still comes up with the ODBC user and it's giving me problems executing on my test server.

I'm using Windows XP-Pro and Wamp5_1.6.4a.

I had originally tried using IIS but switched to Wamp5. I have since removed the original PHP and MySQL applications. But could something be left over that I'm missing?

Re: ODBC@localhost
Posted by: CyberSpatium (67.170.181.---)
Date: September 13, 2006 03:36PM

you have a few things mixed up. first, phpMyAdmin is an web based application for administering your MySQL database server. SQLiteManager is a web based application for administering your SQLite database server. They are totally different database servers. So, when you use phpMyAdmin to create a database for your MySQL server, it will not show up in SQLiteManager because SQLiteManager just deals with SQLite databases, not MySQL databases.

to learn how to correctly set users and permissions for you mysql users and databases, check out this post:

MySQL Info:

SQLite Info:

Sorry, only registered users may post in this forum.