Hi Colm, I wouldn't mess with trying to get CF to not look at 'localhost' - just remove MySQL and reinstall. If when you say that you are using 'cobalt linux Red Hat' you mean RaQ (rather than LX50) then I would use the PKG installer for MySQL from http://pkgmaster.com/ - can go wrong with this one - just remember to reset the root password!
Either way, it looks like you are using version 3.22.32 - PKG Master has 3.23.54 which is a far more recent version. No doubt there is a way to do what you are asking but a reinstall would surely be quicker. HTH, Matt. > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
