 MySQL won't listen | |
Mark
Many thanks for your comments.
First off, the MySQL specs are:
acer client: 5.0.0-alpha-nt
hppav client: 5.0.18-nt
I have been experimenting with the different suggestions with no
results so far:
1. Commented out bind address 127.0.0.1' in 'my.ini'
2. Ran telnet on port 3306 ('o hppav3310.loc 3306'). Returns a 'Cannot
open connexion' msg.
3. Suppressed the password for user mark to simplify testing
4. Granted all permissions to user 'mark' in hppav.loc's user table
with the following entries (all other entries set to yes):
Host User Password ...
localhost root <none> ...
acer2355.loc mark <none> ...
hppav3310.loc mark <none> ...
5. Amended 'my.ini' and added Jerry's suggestions:
------------
#This File was made using the WinMySQLAdmin 1.4 Tool
...
[mysqld]
basedir=C:/Program Files/MySQL
#bind-address=127.0.0.1
datadir=C:/Program Files/MySQL/data
#language=C:/Program Files/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[safe-mysql]
port=3306
skip-networking=OFF
[WinMySQLadmin]
Server=C:/Program Files/MySQL/bin/mysqld-nt.exe
user=mark
password=mark
--------------
6. End Result. Entering on acer3350.loc the command:
mysql -h192.168.1.34 -umark
returns now the following error message:
'ERROR 2003: Can't connect to MySQL server on '192.168.1.34' (10060).
I am puzzled. Thanks for any further insights,
Mark
|