I have XP SP3 with following "XAMPP Portable" setup:
- Code: Select all
###### ApacheFriends XAMPP (Basispaket) version 1.7.4 ######
+ Apache 2.2.17
+ MySQL 5.5.8 (Community Server)
+ PHP 5.3.5 (VC6 X86 32bit) + PEAR
+ XAMPP Control Version 2.5 from www.nat32.com
+ XAMPP Security
+ SQLite 2.8.15
+ OpenSSL 0.9.8o
+ phpMyAdmin 3.3.9
+ ADOdb 5.11
+ Mercury Mail Transport System v4.62
+ FileZilla FTP Server 0.9.37
+ Webalizer 2.01-10
+ Zend Optimizer 3.3.0
+ Perl 5.10.1
+ Mod_perl 2.0.4
+ Tomcat 7.0.3
On same system, i have MySQL/ODBC connector, which works fine. Now, i've tried to connect from second computer with same settings, and MySQL refuses connection.
I've tried:
1. MySQL user's hostmask is "%"
2.a) uncomment lines in my.ini which block remote connections
2.b) Bound listening IP address to 0.0.0.0 ("all")
3. changed socket from "D:/Xampp/mysql/mysql.sock" to "TCP/IP" and also tried "D:/Xampp/mysql/TCP/IP.sock" (which sounds mega-wrong because of slash in "tcp/ip")
and none of this works.
Here's the screenshot:
What am i doing that wrong?
PS. note that i've tried to use BBCode which puts a thumbnail of picture and links to bigger one, but forum blocked, therefore i've needed to put whole picture. Thank you!