>>When creating a data connection for mySQL in the CF administrator, which id >>and password do I use? The one I created to admin the database, or a select >>restricted user? Also - if the mySQL server is on the same box, the host >>name is supposed to be:
For CF5( It may be the same on MX, dunno, but CF5.0 probably better on Linux than the MX behemoth) on Linux box the following, set up a connection in ODBC in CF5 admin using the MySQL Merant Driver: Server Hostname: ipaddress of your box(not localhost or 127.0.0.1) Server Port: 3306 Username: yourusername Password: yurpsword Username and password, not the CF admin password:( You have to set these up on MySQL ) granting access and permissions to them) Try the one you created to admin the database, or Connect to mysql, then mysql> grant all on *.* to [EMAIL PROTECTED] identified by "yurpsword" with grant option; Use a copy of MySQL-Front to administer MySQL. That should do it Colm Colm Brazel MA CB Publications www.cbweb.net <http://www.cbweb.net> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 01:13 To: CF Mailing List Subject: [ cf-dev ] Connect cf to mysql When creating a data connection for mySQL in the CF administrator, which id and password do I use? The one I created to admin the database, or a select restricted user? Also - if the mySQL server is on the same box, the host name is supposed to be: --------- (local) ---------- Correct? I am having issues connecting to a database... I am getting the error: ------- � * Connection verification failed for data source: addy []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. ----- .::d::. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
