MySQL Forums
Forum List  »  Install & Repo

weird connection remote problem from Query Tool
Posted by: Raymond Kodiak
Date: March 13, 2011 01:34PM

In my basement I run a ubuntu server with mysql runs on 192.168.1.105 on my local LAN, it all works great.

I wanted to connect to that using the Query Browser Tool, so the weird thing is that I did run these commands:

mysql> update db set Host='192.168.1.100' where Db='wordpress';
mysql> update user set Host='192.168.1.100' where user='raymond';

but the weird thing and its probably because I am doing something wrong, is that, I can connect from my other machine IP 192.168.1.100 into that schema wordpress, using ID raymond, but only using a blank password, if I enter a password, ummmm, I get an error:

Could not connect to host '192.168.1.105'.
MySQL Error Nr. 1045
Access denied for user 'raymond'@'192.168.1.100' (using password: YES)

anyways, I need to correct this so that I can log in only using a password :- )

Options: ReplyQuote


Subject
Written By
Posted
weird connection remote problem from Query Tool
March 13, 2011 01:34PM


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.