By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,841 Members | 854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,841 IT Pros & Developers. It's quick & easy.

connecting from other computer

P: n/a
Hi

I'm using mysql-server 4.0.13-3 on Debian.
I wish to be able to connect to that server using a mysql frontend from my
other computer, which is a Win32 box. However, when I try "telnet
192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the host
box, I get connection refused.

Can someone give me, or point me to a step-by-step explaination on how this
is achieved?

Thanks
Bart
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On the Debian, go to admin >mysql dbname
Enter "Grant" command specifying the Win32 box. Eg.

mysql> grant read on *.* to winuser@winipaddress identified by winpw

where
winuser is just a username
winipaddress is the IP Address of the windows machine
winpw is some password.
then on the Win32 box connect using that username and password eg.
say the user is remuser and password=pwpwpw and the Debian box is ip=1.2.3.4
and the database name is somedata.
then on windows

mysql -u remuser -p pwpwpw so******@1.2.3.4

If using ODBC on the windows box, still use that ip, dbname, dbuser and
dppassword

Careful on the Grant command, to specify enough to restrict access.

For example "Grant all on *.* to fred identified by fredpw opens up connects
to (All IPs everywhere)

dp

I'm using mysql-server 4.0.13-3 on Debian.
I wish to be able to connect to that server using a mysql frontend from my
other computer, which is a Win32 box. However, when I try "telnet
192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the host box, I get connection refused.


Jul 19 '05 #2

P: n/a
On the Debian, go to admin >mysql dbname
Enter "Grant" command specifying the Win32 box. Eg.

mysql> grant read on *.* to winuser@winipaddress identified by winpw

where
winuser is just a username
winipaddress is the IP Address of the windows machine
winpw is some password.
then on the Win32 box connect using that username and password eg.
say the user is remuser and password=pwpwpw and the Debian box is ip=1.2.3.4
and the database name is somedata.
then on windows

mysql -u remuser -p pwpwpw so******@1.2.3.4

If using ODBC on the windows box, still use that ip, dbname, dbuser and
dppassword

Careful on the Grant command, to specify enough to restrict access.

For example "Grant all on *.* to fred identified by fredpw opens up connects
to (All IPs everywhere)

dp

I'm using mysql-server 4.0.13-3 on Debian.
I wish to be able to connect to that server using a mysql frontend from my
other computer, which is a Win32 box. However, when I try "telnet
192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the host box, I get connection refused.


Jul 19 '05 #3

P: n/a
"D. Pickering" <dc*****@hps.com> wrote in message
news:xM*********************@newssvr30.news.prodig y.com...
On the Debian, go to admin >mysql dbname
Enter "Grant" command specifying the Win32 box. Eg.

mysql> grant read on *.* to winuser@winipaddress identified by winpw

where
winuser is just a username
winipaddress is the IP Address of the windows machine
winpw is some password.
then on the Win32 box connect using that username and password eg.
say the user is remuser and password=pwpwpw and the Debian box is ip=1.2.3.4 and the database name is somedata.
then on windows

mysql -u remuser -p pwpwpw so******@1.2.3.4

If using ODBC on the windows box, still use that ip, dbname, dbuser and
dppassword

Careful on the Grant command, to specify enough to restrict access.

For example "Grant all on *.* to fred identified by fredpw opens up connects to (All IPs everywhere)

dp

I'm using mysql-server 4.0.13-3 on Debian.
I wish to be able to connect to that server using a mysql frontend from my other computer, which is a Win32 box. However, when I try "telnet
192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the

host
box, I get connection refused.

Thanks!
works fine now :)

Bart
Jul 19 '05 #4

P: n/a
"D. Pickering" <dc*****@hps.com> wrote in message
news:xM*********************@newssvr30.news.prodig y.com...
On the Debian, go to admin >mysql dbname
Enter "Grant" command specifying the Win32 box. Eg.

mysql> grant read on *.* to winuser@winipaddress identified by winpw

where
winuser is just a username
winipaddress is the IP Address of the windows machine
winpw is some password.
then on the Win32 box connect using that username and password eg.
say the user is remuser and password=pwpwpw and the Debian box is ip=1.2.3.4 and the database name is somedata.
then on windows

mysql -u remuser -p pwpwpw so******@1.2.3.4

If using ODBC on the windows box, still use that ip, dbname, dbuser and
dppassword

Careful on the Grant command, to specify enough to restrict access.

For example "Grant all on *.* to fred identified by fredpw opens up connects to (All IPs everywhere)

dp

I'm using mysql-server 4.0.13-3 on Debian.
I wish to be able to connect to that server using a mysql frontend from my other computer, which is a Win32 box. However, when I try "telnet
192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the

host
box, I get connection refused.

Thanks!
works fine now :)

Bart
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.