mysqlcc on windows error
 

Hello,
I have gotten mysql working on my redhat linux box, and can access it through a ssh terminal. But I was hopeing to use a GUI to work with it. I found mysqlcc on mysql's site, and installed it on my windows 2000 PC. When I try to register the server, I enter all the info to the best of my knowledge, same user/password, and database name. But then I get a error that says:

[linuxTest] ERROR 1130: Host '09e11blt01.domain.com' is not allowed to connect to this MySQL server

Can anyone help me with this. I have never used a database server on linux with any luck.

Thanks in advance for any help,
Todd

Have you grant access rights to the Win2k location and your username in mysql?

i.e

GRANT ALL on * to myusername@'192.168.0.2' identified by 'my_sneeky_password';
flush privileges;

that sort of thing?

should the IP you typed in be for the server or the win2k manchine? I did it with the user name on the linux box.

I will try the other way in a bit.

Todd

The user name isn't related to any user account on your windows or linux machine, it's a purely MySql username.

The ip address is the address of the remote machine that you want to allow to connect - not the machine with mysql running on it.

So to create a user thack111 that can access from anywhere and do just about anything and has the password my_sneeky_password, login to mysql as root and:

use mysql;

Grant all on * to thack111@'%' identified by 'my_sneeky_password';

flush privileges;

'%' means from absolutely anywhere so you can subsitute '%'
for an ip address, domain name etc... to be more restrictive

Thanks very much, seems to be working fine!
It is cap senisitive just a reminder to anyone else reading.

Wich database server is the stablest? Is that completely a opinion or is there one that stands out above the rest?

Thanks for the help.
Todd