mysql permission

vcheah · 11-26-2002, 02:29 AM

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.

ccool · 11-26-2002, 08:18 AM

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

vcheah · 11-26-2002, 11:32 AM

i dont have a gui interface in my redhat..
any other idea

ccool · 11-26-2002, 12:42 PM

well, you have one on your win2k... it will do if you have a web sever with php.

vcheah · 11-26-2002, 03:11 PM

Ok ..
I try it later..

j-ray · 11-26-2002, 03:35 PM

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