MYSQL

[devendra.meena]

I am using MYSQL 4.1 on my CentOS 4.2

my server is working very fine
but i am not able to connect to my mysql
database server from remote Computer

the following error:-

Host is not allowed to Connect to This MYSQL server

error number 1103


Plz Help me this is urgent

[KG6KVQ]

You need to enable network access, in your my.cnf file comment out

skip networking

and ensure you have a line reading

port = 3306 (or whatever port number you are going to use)

[devendra.meena]

This is my.cnf file


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[sarumont]

You will need to enable access from that host (and/or user). Check out the mysql docs on authentication.

http://dev.mysql.com/doc/refman/5.0/...ge-system.html