Finally got this working yesterday!  Thought I'd share the solution for
anyone else that might run into this issue.

This is a new server...after you install RH9, MySQL is running, but not
listening to port 3306 as it usually does...

I read the through all the links and docs I could find and found one
reference in the troubleshooting section of the MySQL online docs that
said to make sure you are not running MySQL with  '--skip-network'.

I checked the command to start the MySQL process and it wasn't in
there..It ended up that I had to comment out 'skip-network' in
/etc/mysql/my.conf.

I restarted mysqld and all is good!  MySQL now connects to CFMX without
any problems!

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Matt Robertson wrote:

> Josh wrote:
> >It is wierd.  I can connect to mysql at the command line just fine.  I
> >can connect via webmin, plesk , and phpMyAdmin just fine on the
> >'default' ports.  So I know MySQL is running fine...but CFMX still
> >refuses to connect...
>
> I've got an identical-sounding error on my home dev box.  Same error
> message.  It used to work just fine.  It didn't die until well after my
> 6.1 upgrade... I *think*.  
>
> Two dsn's continue to function perfectly.  One is my client var storage
> db and the other is a timed app that executes every five minutes.  All
> of the rest of the mySQL dsn's are dead as you describe, with the same
> error message.
>
> The only thing I can think of is that the working datasources' frequent
> use has something to do with their failure to... well, fail.
>
> I can do a cold reboot and no change.  I can delete the dead dsn and
> rebuild it, making sure I have the pwds and such correct.  No change.  I
> can confirm the dead dsn is working within mySQL directly via
> mySQLFront.  
>
> And the kicker:  I can open the dead dsn in CF Studio's datasource tree
> and it sees the tables just fine, and reports the fields.  But if I
> double-click on the table, instead of a view of the data I get a blank
> screen with no error.
>
> I'm running 6.1 developer, Apache, Win2k on an old Celeron.
>
> --------------------------------------------
> Matt Robertson       [EMAIL PROTECTED]
> MSB Designs, Inc.  http://mysecretbase.com
> --------------------------------------------
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to