MySQL access using WorkBench, Toast, Heidi...

[sociales2]

Hello

First, sorry for my English.

 

I use nano 5.6.15 for years in production environment, on an intranet. A server without a display.

And I use Toad, HeidiSQL or Mysql_WorkBench from my desk (for me, better than phpmyadmin).

 

But if I upgrade to Coral 8.6, 8.7 ..., phpmyadmin does work, but I can`t connect from Toad, Heidi or WorkBench.

(After unzipping the package, just change the key and authorize in firewall).

What is different about the new versions?

 

Any idea?

Thank you.

[Ric]

Instead of using localhost for Hostname use the IP address 127.0.0.1

All the best

Ric

[sociales2]

Instead of using localhost for Hostname use the IP address 127.0.0.1

All the best

Ric

 

I used two names for Hostname (#bind-address=127.0.0.1) in my.ini. Also 30.0.40.20, uniform pc ip. No results.

I tried access from XP to Win7 and all four variations.

I changed a line \Uniserver865\home\us_phpmyadmin\.htaccess to: "Allow from 127.0.0.1 30.0.40.50" to allow access phpmyadmin from my local pc with ip=30.0.40.50

And I can connect in root mode with phpmyadmin from 30.0.40.50

But cant connect with MySQLworkbench, Toad or heidi. Im confused.

I can continue using nano, but... I would change to new versions.

Can you suggest any idea?

 

Thanks in advance

antonio

[sociales2]

Eyyyy

I think´s solved

MySql need run as service and bind-address need not value in my.ini

It´s ok for me

thanks all