MySQL access using WorkBench, Toast, Heidi...
Posted 18 January 2013 - 04:02 AM
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?
Posted 18 January 2013 - 12:47 PM
All the best
Posted 22 January 2013 - 10:52 AM
Instead of using localhost for Hostname use the IP address 127.0.0.1
All the best
I used two names for Hostname (#bind-address=127.0.0.1) in my.ini. Also 220.127.116.11, 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 18.104.22.168" to allow access phpmyadmin from my local pc with ip=22.214.171.124
And I can connect in root mode with phpmyadmin from 126.96.36.199
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
Posted 23 January 2013 - 07:11 AM
I thinkīs solved
MySql need run as service and bind-address need not value in my.ini
Itīs ok for me
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users