[Lazarus] TMysql57Connection won't connect to localhost

[Michael Van Canneyt]

Hello,

This means the mysql_real_connect() call failed. That means mysql itself
reports an error.

This means your connection parameters are somehow not correct: 
one of hostname, port, username or password.

At this point the database name is not yet used. First a connection is made,
then the database is selected...

If you leave empty the hostname, it assumes localhost and will attempt a unix
socket connection first.

Do I understand it correctly that you are running the mysql in a bitnami
virtual machine ?

Is your lazarus also running in the virtual machine ? Or is lazarus running
on the host computer ?

Because if that is the case, you cannot use hostname localhost, but you must
use the IP address of the virtual machine.

If lazarus and mysql are running on the same (virtual) machine, then it is
something else.

For instance, what username did you use ? root at localhost or root ? 
Hopefully the latter :).

Michael.


On Tue, 29 May 2018, larrydalton71 wrote:

> The error I am getting is simply "server connect failed." I am getting the same after I removed localhost from hostname.
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
> -------- Original message --------From: Michael Van Canneyt via Lazarus <lazarus at lists.lazarus-ide.org> Date: 5/29/18  01:57  (GMT-05:00) To: Larry Dalton via Lazarus <lazarus at lists.lazarus-ide.org> Cc: Michael Van Canneyt <michael at freepascal.org> Subject: Re: [Lazarus] TMysql57Connection won't connect to localhost 
>
> What is the error you are getting ?
>
> If you want to connect through unix socket, you should leave hostname empty.
> If you set it to localhost, TCP/IP will be used.
>
> Michael.
>
> On Mon, 28 May 2018, Larry Dalton via Lazarus wrote:
>
>> I am running lazarus 1.8.2 on linux mnt 17.2.
>> I am trying to access a mysql database that was installed with Bitnami.
>>
>>    - 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)
>>    - Server: Server: localhost:3307
>>    <http://127.0.0.1:8080/phpmyadmin/index.php>
>>    - Protocol version: 10
>>    - User: root at localhost
>>    - Server charset: UTF-8 Unicode (utf8)
>>
>>
>>    - 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
>>
>>
>>    - Phpmyadmin Version information: 4.8.0.1, latest stable version: 4.8.1
>>    <https://www.phpmyadmin.net/files/4.8.1/>
>>    - Web Address http://127.0.0.1:8080/phpmyadmin/
>>
>>
>>        I am using localhost as hostname on Tmysql57Connection.
>>
>>        I cannot connect the Tmysql57Connection to localhost.
>> Help?
>>
> -- 
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus-ide.org
> https://lists.lazarus-ide.org/listinfo/lazarus