[Lazarus] can't connect to Mysql database using TMysql57connection

Larry Dalton larrydalton71 at gmail.com
Tue Jun 5 04:55:16 CEST 2018


error code
Debugger Exception Notification
Project Moneyproject raised exception class 'ESQLDatabaseError ' with
message
'Server Connect Failed'.


Lazarus version: lazarus-project_1.8.2-0_amd64.deb
fpc_3.0.4-2_amd64.deb
fpc-src_3.0.4-2_amd64.deb


settings for TMysql57Connection named CreateConnectionz'

Charset blank
database name bankofamerica
Hostname blank
(also tried Hostname localhost)
KeepConnection
logevents set on default setting
loginprompt false
options []
Params blank
password is set and correct
port 0
role blank
SkipLibrary verson false
tag 0
transaction CreateTransaction
user root.

Help!

Operating system Linux Mint 17.2 Cinnamon

phpmyadmin

   - Version information: 4.8.0.1, latest stable version: 4.8.1
   <https://www.phpmyadmin.net/files/4.8.1/>



Web Server

   - Apache
   - Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
   $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
   - PHP extension: mysqli[image: Documentation]
   <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mysqli.php>
    curl[image: Documentation]
   <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.curl.php>
    mbstring[image: Documentation]
   <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mbstring.php>
   - PHP version: 7.1.17



Database Server

   - Server: Localhost via UNIX socket
   - Server type: MySQL
   - Server connection: SSL is not being used [image: Documentation]
   <http://127.0.0.1:8080/phpmyadmin/doc/html/setup.html#ssl>
   - Server version: 5.7.22 - MySQL Community Server (GPL)
   - Protocol version: 10
   - User: root at localhost
   - Server charset: UTF-8 Unicode (utf8)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20180604/d8e06090/attachment.html>


More information about the Lazarus mailing list