mysql client on wlan

[bill-lancaster]

I have mysql server on computer A (ip 192.999.1.1)
Computer B is connected via wlan (Computer name: Vostro; ip 192.999.1.2)
I want B to access mysql on A
Here is what I have done so far:-
1) Comment out bind-address in /etc/mysql/my.cnf
2) mysql> create user Vostro@192.999.1.2 identified by 'xxxxx';
3) Grant permission. mysql> GRANT ALL ON *.* TO Vostro@'192.999.1.2' IDENTIFIED BY 'xxxxx';
4) Restart computer A

When trying to access 'A' from 'B':-
~$ mysql -u Vostro -pxxxxx -h192.999.1.1
I get

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Computer 'B' had a very long name with several '-' characters. I changed it to 'Vostro'. If I ping Vostro from computer 'B' I get sensible results so I don't think this is a problem.

Have looked at many posts but haven't found any that help. Any help would be very welcome.

[otisklt]

Are you using a firewall?

Kinda shocked that IP scheme works... if that is the actual numbers in use.

[bill-lancaster]

Thanks otisklt
No firewall
The ip address are ficticious!
BTW both machines are runnung Kubuntu 14.04

[bill-lancaster]

A further observation:-
MySQL Workbench on pc 'A' under 'Users & Privileges' shows 'Vostro' with correct ip address

[otisklt]

In some cases with other SQL stuff I have messed with, I have not messed with mysql very much, you end up having to turn on the TCP capability before it will answer remote calls.

http://stackoverflow.com/questions/1...s-mysql-ubuntu

Is all set on the target host like discussed in this link?

[bill-lancaster]

Well than you otisklt!
After many hours of trying I now have a working mysql client.
That posting is the only one that helped, it also has advice that is contrary to most other posts on the subject

[otisklt]

Cheers, glad that worked out.