MySQL Forums
Forum List  »  MySQL Administrator

Re: Mysql Command Line Client ARRGH
Posted by: Barry Galbraith
Date: October 30, 2009 04:19AM

The mysql sever on the linux machine has to have user@<windows_host> allowed as a user, granted all permissions.
You'll probably find that it only has root@localhost allowed.

So, you'll need to login to your linux host, and use mysql command line locally to connect to the mysql server.
find the user names already enabled
mysql> use mysql;
Database changed
mysql> select host, user from user;
| host | user |
| % | barry |
| localhost | root |
Mine shows user barry from any host, and root from localhost

You'll need to allow a user from your windows host, and grant permissions to user@windows_host.

Then, on your windows machine, mysql administrator should be able to connect to your linux box using the username and password you just set up.
If your linux box has a firewall, don't forget to open port 3306 for mysql traffic from your windows machine.

Good luck.

Edited 1 time(s). Last edit at 10/31/2009 04:11AM by Barry Galbraith.

Options: ReplyQuote

Written By
October 28, 2009 03:21PM
Re: Mysql Command Line Client ARRGH
October 30, 2009 04:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.