But cannot get :- Zeos, SQL Connection1 to find the libmysql.dll.
everything is freshly installed

Opening SQL Connection1
driver name: MySQL
HostName: Server Name
Database name: DBNAME
User_Name and Password I have set at both in MySQL and SQL connection to 'root'.
BlobSize : -1 I want to use pictures should this be larger for pictures like 16 megs
MySQL otherwise is default in all its settings.
I have kept the install record but its too big to upload and the database is working though local host.

Copy the libmysql.dll to your project folder. It should be a LibraryLocation property(TZconnection), enter the full path to your dll. On form create, you should also give the full path programatically, in case you move your exe/dll, to another folder.

I found that dose not work at all.
I found: - make a windows shortcut with both *.dll's and place it in with my project. That worked perfectly.

The thing is my end product is not going to like doing that. I need Zeos to look past my end product's (*.EXE) current folder.

And now it asks me for db2cli.dll and that's not apart of MySQL as far as I can figure out (at all). Everything talks about it as a MS SQL product to link to the ADO or OBDC or something like this. I must ask what *.dll's go with it as well. so I'm looking for a download from something.