mysql

icedude · 06-15-2006, 01:29 AM

Hi.

I'm trying to get mythtv to work on my rhel4 machine. I think its sort of working. My problem i have is with mysql. I cant connect to mysql from a client machine to my server. It gives me this error:
#HY000Host 'bite.example.com' is not allowed to connect to this MySQL server. (This is from Windows)

When i connect from a linux machine it ask me for my password and then says the same:
ERROR 1130 (00000): #HY000Host 'bite.example.com' is not allowed to connect to this MySQL server

Is there an security issue, or do i have to add something. I dont have a lot of knoledge about MySQL yet but i'm trying.

Could someone help me please?

perfect_circle · 06-15-2006, 07:58 PM

It looks like a security issue to me?

connect to mysql locally:

Code:

mysql -u root -p

enter the mysql root password.
If you don't have a password at all omit the -p
then type:

Code:

use mysql

Code:

select user,host from user;

Are there any users allowed to connect from another host?
If not you probably have to create a new user and give correct permissions

boredandblogging · 06-15-2006, 09:44 PM

more than like the host column in the user table says only localhost.