LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-22-2003, 03:54 PM   #1
thack111
LQ Newbie
 
Registered: Sep 2003
Posts: 18

Rep: Reputation: 0
Question 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
 
Old 10-22-2003, 05:50 PM   #2
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
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?
 
Old 10-22-2003, 09:25 PM   #3
thack111
LQ Newbie
 
Registered: Sep 2003
Posts: 18

Original Poster
Rep: Reputation: 0
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
 
Old 10-23-2003, 05:26 AM   #4
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
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
 
Old 10-23-2003, 08:23 AM   #5
thack111
LQ Newbie
 
Registered: Sep 2003
Posts: 18

Original Poster
Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[ubuntu] Mysqlcc Flippje Linux - Newbie 1 11-20-2005 07:39 PM
Mysqlcc connection denied BlackHatRob Linux - Software 1 09-15-2005 10:34 PM
MySQLCC segmentation fault Swift&Smart Linux - Software 11 11-03-2003 09:51 AM
mysqlcc tutorial noshellswill Linux - Software 5 09-09-2003 10:35 AM
MySQLCC rivang Linux - Software 2 06-07-2003 11:11 PM


All times are GMT -5. The time now is 07:21 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration