how much access does odbc@localhost need? i don't have any dsn that use the user, i don't have any php scripts that use it as a log in into the database; however if i disable the user, ALL of the pages that use a mysql odbc datasource break with the error that odbc@localhost can't log in. (all of the affected pages are writen in coldfusion)
this only started happening the day after phpMyAdmin was installed, and everything on the machine was fine for about 8 hrs after that (sorry, don't know the exact time, but poo hit the fan in the night) everything was working for about 5 days before that, and the only other changes we made were some syntax fixes on coldfusion pages. nothing that should affect the datasource logins. [no, i'm not trying to blame phpMyAdmin. i know it has nothing to do with it, but its the only changes that we know of before it broke.] [All = 4 sites, each with their own mysql login, the machine is a newly setup (maybe about 2 weeks now), and the first one we have here that uses MySQL] system info: Win2k (w sp2) Apache 1.3.24 ColdFusion 5 Php 4.2.1 MyODBC 2.50.39-nt MySQL 3.23.49-nt each virtual domain that uses mysql database has their own logins and the only thing keeping me from editing odbc@localhost and hunting for the breaking point is that this has happened on the production machine. -- mysql, sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
