connecting from other computer

[Bart van den Burg]

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

[D. Pickering]

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.

[D. Pickering]

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.

[Bart van den Burg]

"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

[Bart van den Burg]

"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