Hi, Following a reload on a cobalt linux Red Hat machine I inadvertently loaded mysql onto www.domainname and not localhost though the CF 5 I have is professional version and not enterprise version. Problem is I can't connect with the Merant MySQL driver to MySQL databases through ODBC datasource administrator. I can connect remotely to MySQL allright using Front and even using webmin and have setup users with permissions that work for all remote connections except this local connection the CF5 ODBC admin is trying to make. I have restarted/stopped the server and setup users for localhost and 127.0.0.1 and applied all in http://www.macromedia.com/v1/handlers/index.cfm?id=20755 including mysql.sock suggestions, but still the Merant driver won`t connect, anybody got a fix for this? I suppose the question could be is there a way for this professional ver of CF5 I use to instead of looking for default 127.0.01 or localhost, can it be configured to look instead for www.mydomain as default as I imagine this could fix this problem, if fo how or can this be done?
The following connection session may show something: [root@www bin]# mysql -h localhost test ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@www bin]# mysql -h 127.0.0.1 test ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@www bin]# mysql -h www.domainname test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 89 to server version: 3.22.32 Type 'help' for help. mysql> TIA Colm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
