Peter,
Have you set the privileges for the user in the mysql table?
Rob
> ----- Original Message -----
> From: "Peter Amiri" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 03, 2000 5:06 AM
> Subject: Problems creating a mySQL datasource
>
>
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: 7bit
> >
> > I'm having problems creating a mySQL datasource through the CF
> > Administrator. It comes back as not verified. This is the first datasource
> > I'm trying to setup so I don't know where to start in diagnosing this. I
> > know mySQL is up and running, and php3 pages to mySQL and the particular
> > database I'm trying to connect to are working. What I've done so far is to
> > create a mySQL database and using the phpMyAdmin tools created a table,
> > added columns, and created a row of data. I now want to connect CF to the
> > database so I can run CF code against it.
> >
> > B. Peter Amiri Direct: 949-470-2093
> > Amiri Industries, Inc. Office: 949-470-2090
> > 23232 Peralta Drive, Suite 222 Fax: 949-470-2095
> > Laguna Hills, California 92653 E-Mail: [EMAIL PROTECTED]
> > URL: www.amiriindustries.com
> >
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440
> > Content-Type: application/ms-tnef;
> > name="winmail.dat"
> > Content-Transfer-Encoding: base64
> > Content-Disposition: attachment;
> > filename="winmail.dat"
> >
> >
> eJ8+IgYTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
> >
> b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCgACAAwABgAAAAEA9gAB
> >
> A5AGAOwHAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
> >
> AAAAJQAAAFByb2JsZW1zIGNyZWF0aW5nIGEgbXlTUUwgZGF0YXNvdXJjZQAAAAACAXEAAQAAABYA
> >
> AAABwCyj0KR0Ox08mIYR1J7pAFCLE+KCAAACAR0MAQAAABUAAABTTVRQOlBFVEVSQEFNSVJJLk5F
> >
> VAAAAAALAAEOAAAAAEAABg4A3C3NoyzAAQIBCg4BAAAAGAAAAAAAAAB+rZdbmV7UEZ7UAFCLE+KC
> >
> woAAAAsAHw4BAAAAAgEJEAEAAACDAwAAfwMAAB4FAABMWkZ1jXHsEgMACgByY3BnMTI1FjIA+Atg
> >
> bg4QMDMzTwH3AqQD4wIAY2gKwHPgZXQwIEcDEAMgBhMcTVQCgwBQEGZwcnFvDlAQ2AcTAoB9CoAI
> >
> yCA2OwlvDjA1AoAUknN0lHlsB5BoCeB0ewewRwWwAMACc3MxIBdwYSJkC4BnIDEUY1x2SQiQd2sL
> >
> gGQ0DGBjBwBQCwMLtDQgSSdtXRiQYRmQGPETIG8CYGUubQQgBQAYsHQY4mEggG15U1FMIGQcsARh
> >
> cwhhY2UgdGgxA2B1Z2geMR4gQ0aZFABkbQuABAB0chywvQWwLhswBUAFoAeCYgDQpmsdAAQgbm8F
> >
> QHYGcqUIkGQgAFRoBAAgIjF/HsIhsBEQBUAdmRtCH6B5yxjiH9AgESF1cCSwJKDWSR2AAiAnBUBr
> >
> ITAH4P53F3AJcCSDAZAAICJQA6D5GNBhZyEwAJAkYiIhIAEfJcQdNCIxJPEAcGQgcix1bgMADyAs
> >
> KXNwaPxwMxvgJ2AHkSSRHTQpgucewgqxHMBjdQtgBcAdkv8gsBEgI90FoCngBZAFQCSRWwrAHiB3
> >
> BbAZ0WcgAFd/EPAFQBtAIXAlYh4gJSFm/wrBImIuURySHiAdGi1DKYLOdSelLDEqoE15HzMkgX8G
> >
> 8BxlCYAdAQGRF0AqMWTnAQApoAjhdW0AgCo0NSjzA2AH4G9mHYMoMiXjAHB/LtMudh8BJJEewi0H
> >
> JSNjvwORKcEe8gWgAQAdAGcLcfEjAWl0LgqiCoQKhAswvmILIAAgPnMQsD6Cdw9AWT5xc3AB0AMw
> >
> awngcNMLkCXhaWQuwGwKsRhhkQAQaTQ1AUB0cUFA0QzQNDY4QdY2DiAMEusSc0ABQiAAUBEwBJAU
> >
> ANcfUAUQDINiEVBEIuAusQI6DIIgOTQ5LTTINzAtAdA5MwwhPdn/QKpBn0KqE/FEkhswGfAzcG8f
> >
> oAiQNvFKwGM9UEXSTzsBIA3gZUW/AUA9czIz903xRBEfsGwBkEVABRAhcNkqMFN1PTAeIDJPoEXD
> >
> 6EZheEx/NUb/SA8M0MgzNjBCiiBMJ2Ap0O0dEEgRgTbxQwdABpAFsMMDAB0QOTI2NUbARdLoRS1N
> >
> C3BsUFMI0ABB5yywG+BEMkBhRJIZ4Ur1/i4gUVeRAUAssCEwLqA9ZVFF0lVSTFBUd1uQLr9Yf1mB
> >
> PdkaxT1kFIEAXtAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADA
> >
> AAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAgg
> >
> BgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAA
> >
> ADaFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAA
> >
> HgAMgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAA
> >
> AABGAAAAAIKFAAABAAAACwA6gAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAA
> >
> AADAAAAAAAAARgAAAAARhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBS
> >
> gAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFOACCAGAAAAAADAAAAAAAAARgAAAAABhQAA
> >
> AAAAAAIB+A8BAAAAEAAAAH6tl1uZXtQRntQAUIsT4oICAfoPAQAAABAAAAB+rZdbmV7UEZ7UAFCL
> >
> E+KCAgH7DwEAAACPAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5J
> >
> VEH5v7gBAKoAN9luAAAAQzpcV0lOTlRcUHJvZmlsZXNccGV0ZXJcTG9jYWwgU2V0dGluZ3NcQXBw
> >
> bGljYXRpb24gRGF0YVxNaWNyb3NvZnRcT3V0bG9va1xvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00
> >
> /TcAAAIBfwABAAAALwAAADxORUJCSk9ORUhPUE5CTUVJSExOTUVFRE5DUEFBLnBldGVyQGFtaXJp
> >
> Lm5ldD4AAAMABhCFZ2ePAwAHEHICAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAASU1IQVZJ
> >
> TkdQUk9CTEVNU0NSRUFUSU5HQU1ZU1FMREFUQVNPVVJDRVRIUk9VR0hUSEVDRkFETUlOSVNUUkFU
> > T1JJVENPTUVTQkFDS0FTTk9UVkVSSUZJRURUSElTSVNUSEVGSQAAAACL4A==
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440--
> >
> > --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
**********************
* Rob Burtelow *
* Senior SMC Staff *
* [EMAIL PROTECTED] *
**********************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
