Also, you might want to look at using "PhpMyAdmin" to manage your MySQL database. It requires PHP to be installed and loaded in Apache, but by default your system is probably already configured for PHP.
See: http://www.phpmyadmin.net/ You just decompress it into the document root, and then modify the configuration file "config.inc.php" to indicate the name of the server, the master user account and the user password. Then just launch a browser and navigate to the index page of the app. The ease of use and sophistication of this application are amazing, and you might find it easier to add users, create databases, and manage security. -----Original Message----- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:45 PM To: CF-Linux Subject: Re: MySQL datasource in CF admin error On 3/17/03 10:02 AM, "Steven Erat" <[EMAIL PROTECTED]> spit this out onto my computer screen: >>> "I had mentioned in a reply earlier that I had tried that patch, and >>> I got the exact same error." > > I don't have your message regarding this in my inbox, and I don't see it on > the HOF website archive. What message did the CFAdmin display? I just tested > the patch and found that it does produce a verbose error message > describing exactly what's going on... > > Here's what I get when trying to verify a mysql datasource from the > CFMX Admin when the user is not allowed to the database: > > Connection verification failed for data source: mysql_on_stonefly > []java.sql.SQLException: SQLException while attempting to connect: > java.sql.SQLException: Invalid authorization specification: Access > denied for > user: '[EMAIL PROTECTED]' (Using password: YES) > The root cause was that: java.sql.SQLException: SQLException while attempting > to connect: java.sql.SQLException: Invalid authorization specification: Access > denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > In this case, the error is telling me that the user 'testuser' is > denied access to the database. Without the patch, you'll just get a > generic message like you first posted. > > > > > > -----Original Message----- > From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 16, 2003 10:59 PM > To: CF-Linux > Subject: Re: MySQL datasource in CF admin error > > > On 3/15/03 8:31 AM, "Steven Erat" <[EMAIL PROTECTED]> spit this out > onto my computer screen: > >> Again... >> >> Download and install this patch which will allow you to get a more >> specific error message from the CFAdmin: >> >> Diagnostic JAR file for data source connection issues >> >> http://www.macromedia.com/support/coldfusion/ts/documents/tn18355.htm >> >> >> With this patch, you'll get an exact error message and you can stop >> guessing. >> >> >> And as far as CFMX not being supported on Red Hat 8... well, its not. >> So while this particular problem is likely not related to actually >> running on an unsupported distro, be aware that you may encounter >> unexpected results elsewhere. If your application is enterprise >> class, then you might want to rethink your configuration. ... Just >> fyi. > > > I had mentioned in a reply earlier that I had tried that patch, and I > got the exact same error. So I did not have any other info to add > on... > > This is far from an enterprise based server - just learning, etc. > > I have narrowed it down to a MySQL issue. It seems as though mysql > will accept the connection if I start it so that it doesn't need an > id. And also > - any gui's that are running else where also have this issue - so I am trying > to get help here - but would appreciate any contact from some mySQL admin's > off list! > > d > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
