LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-26-2002, 03:29 AM   #1
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Rep: Reputation: 15
Question mysql permission


I have 2 system with me.
win 2k and redhat 7.3

I wrote a small mysql database. in the redhat system
but when i try to execute it from win2k remotely. i recieve permission denied message > 1130: Host '192.168.0.117' is not allowed to connect to this MySQL server


what's wrong..
there is a firewall but is located outside of the lan
i check the ipchains nothing related to the ip above.
 
Old 11-26-2002, 09:18 AM   #2
ccool
Member
 
Registered: Oct 2002
Location: Canada
Distribution: Slackware 10.1
Posts: 71

Rep: Reputation: 15
you should install phpmyadmin on your redhat... with that installed, you will be able to set all your permission correctly and with ease.

check it before you check all your firewall settings
 
Old 11-26-2002, 12:32 PM   #3
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Original Poster
Rep: Reputation: 15
i dont have a gui interface in my redhat..
any other idea
 
Old 11-26-2002, 01:42 PM   #4
ccool
Member
 
Registered: Oct 2002
Location: Canada
Distribution: Slackware 10.1
Posts: 71

Rep: Reputation: 15
well, you have one on your win2k... it will do if you have a web sever with php.
 
Old 11-26-2002, 04:11 PM   #5
vcheah
Member
 
Registered: Nov 2001
Distribution: redhat 8.0
Posts: 110

Original Poster
Rep: Reputation: 15
Ok ..
I try it later..
 
Old 11-26-2002, 04:35 PM   #6
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,532

Rep: Reputation: 132Reputation: 132
log in as root to your mysql
selct database u want to play with
'grant usage for username@192.168.x.x.identified by 'urpasswd';
grant everything what u want to this user
i dont know exactly but i guess u have to add
ur remote host to the host table in mysql db.
the mysql db registers users, privileges, allowed hosts ..
good luck,
jens

Last edited by j-ray; 11-26-2002 at 04:38 PM.
 
  


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
MySQL permission problem Lmax Linux - General 3 09-24-2004 02:12 PM
MySQL on RH9 still giving problems even after permission changes linuxnuby Linux - Software 2 02-04-2004 11:44 AM
MySQL Permission Question chrisk5527 Linux - General 0 11-17-2003 06:20 PM
MySQL permission problem amp2000 Linux - General 12 07-30-2003 03:28 AM
MySQL Permission Problems bselzler Linux - Software 2 07-18-2001 09:07 AM


All times are GMT -5. The time now is 10:56 AM.

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