How can I access (manage) MySQL on Linux from Windows?

[JustKIDn]

Hi all,

O.k. I have MySQL on a linux box and I want to manage it from a windoz box.

Can I use something like MySQL-CC to manage it?

What command line tools can I use and how?

Do I use the IP of the linux box?
tgus

____________________________
Families can be together forever...

 

[QatQat]

Hi Tgus,

you can log in normally from MySQL-CC setting the IP of the linux box.
However remember to GRANT appropriate rights on linux for the Windoz host you want to connect from.

Second way


At dos prompt

c:\mysql\bin\mysql -h ip_address -u root -p


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

QatQat,

Thanks for that.

But I'm unclear. What do you mean GRANT rights for the windoz host?

I thought you needed to GRANT rights to the user.

How do you do that for the host?

I tried it last night with MySQL-CC and I used the IP of the linux box, but it failed.
tgus

____________________________
Families can be together forever...

 

[QatQat]

Hi Tgus,
You grant to a user connecting from a host

an example will explain evertyhing

user=root
password=password for both servers
WIndozIP =192.168.1.2
LinuxIP = 192.168.1.1

Go on the linux box

/usr/bin/mysql -u root -ppassword

at Mysql login

GRANT ALL
ON DBNAME.*
TO ROOT@'192.168.1.2'
IDENTIFIED BY "PASSWORD"
;


FLUSH PRIVILEGES


This will give you rights to connect from the Windoz mysql server.

Go on Windoz now

c:\mysql\bin\mysql -h 192.168.1.1 -u root -ppassword

and you will connect to the linux Mysql server (hopefully)
I noticed a few glitches in doing this when you are running RedHat 8. It may give you an ERROR 2013. I posted something but noone replied to my post.

It does however work with any other version of redhat and for some strange reason it connects and works much better with Mandrake 9.


If you want to use MySQL-CC all you have to do is to create a connection with the right IP address AFTER executing all necessary grants.
Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[comtec17]

I find it easier to use mysqlgui. You can find it at

http://www.mysql.com/downloads/gui-mysqlgui.html

 

[JustKIDn]

Hi QatQat,

Well that worked ok.

I can login with mysql.exe. But I can't with MySQL-CC.

Here's the error;
ERROR 1064: You have an error in your SQL syntax near 'SQL_MAX_JOIN_SIZE=1' at line 1

I don't know what this has to do with it. I didn't type any SQL syntax. Must be a bug.

However, I did get it to work ok with MySQL-Front.

Thanks again!

tgus

____________________________
Families can be together forever...

 

[QatQat]

All I can tell you is that Max_join_size is one of MySQL variables but the value should be something like

4294967295

I am also sure you will find Mysql-front much more complete than MySQL-CC

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)