[svlug] Remote connections to MySQL

[Skip Evans]

Marco Walther wrote:
> Your telnet does not talk mysql;-)
> 
> It did connect to the mysql server but then the protocol is binary. The 
> gibberish are just some bytes which happen to be valid ASCII.
> 
> Try `mysql -h 192.168.1.101 -P 3306' ;-)
> 
> Thanks,
> -- Marco
> 

I tried what you have above and got this:

root at Xu-laptop1:/etc/mysql# mysql -u sevans -p -h 
192.168.1.101 -P 3306
Enter password:
ERROR 1045 (28000): Access denied for user 
'sevans'@'192.168.1.41' (using password: YES)
root at Xu-laptop1:/etc/mysql#

The user sevans does have the right privileges for 
the database. I can connect on the server using 
that user name and password no trouble.

The other thing I've done is put this in 
/etc/services on the server:

mysql           3306/tcp   # MySQL
mysql           3306/udp   # MySQL

And I get this from

netstat -all | grep mysql

tcp4       0      0  192.168.1.101.mysql    *.* 
                  LISTEN
c27ac604 stream      0      0        0 c27ac578 
      0        0 /tmp/mysql.sock
c27ac94c stream      0      0 c2aacaa0        0 
      0        0 /tmp/mysql.sock

Does that first line show MySQL listening 
appropriately on port 3306, as referenced in 
/etc/services???

My novice butt is stumped.

Skip

-- 
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/