Avatar billede fredand Forsker
22. februar 2009 - 18:09 Der er 1 kommentar og
1 løsning

How to login remote?

Hello!

I got a old database running on a Win 2000 (MySQL 5).
Now I would like to connect to that database and do some admin-work from a remote linux-machine.

To my disappointment it seems like there is no Toad-client for MySQL for Linux, right?

Then I think I would like to go for the console-mode.
But I can not find out the correct syntax for the login.

I thought it would be possible to do something like:

mysql root@192.168.1.36/name_of_db

But it just says:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Perhaps I need to install something else as well.
Any ideas is welcome.

Best regards
Fredrik
Avatar billede fredand Forsker
22. februar 2009 - 18:11 #1
I think I found it!

shell> mysql -h THE_IP -u user -p
Enter password: ********
Avatar billede hkb-x Nybegynder
22. februar 2009 - 18:13 #2
You can log in lycaly mysql and the use sql to connect to the remote server through the local server.

Its not the best solution but it works. Else you can use some web interface or use suns mysql administrator.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester