The problem i am having is that i am getting error 1130 "user@domain is not allowed to connect to this server" when trying to connect to my FC2 Box from anywhere but remotely.

so i have googled for a soulution and i have found that a few others have had this problem too. one solution that apears is to create permissions in the hosts table of mysql table.

doesn't work for me i added my remote box and i am still not able to connect remotely.

another solution was to make sure that skip-networking is set to OFF.

in my /etc/my.cnf i have the following

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

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

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


Thats it.

but i figure thats because of the mysql version i am using. and the instructions are for a different one.

at this point all i want to do is be able to connect remotely.

my initial goal was to enable a user verified connection regardless of host, as the remote connection will be dial up and will change.

any help would be great.

You need to grant permissions for the user to connect from the host in mysql.....
To allow a user to connect from any host with a password you need to:

GRANT ALL PRIVILEGES on dbname.* to 'username'@'%' IDENTIFIED BY 'password';

where dbname is the name of the database you want to allow connections to (use *.* for all db's, but this is generally not recommended). If the user only needs read access to the data you can just grant SELECT permissions instead of ALL.

i have run that and
mysql> GRANT ALL PRIVILEGES on tuxshop.* to 'tuxshop'@'%' IDENTIFIED BY 'password'
->

then it hangs there.

i edited what i though was required in the post you gave me but i amy be screwing it up.

am i to put exactly what you put in there not changing it

You're new to SQL aren't you? You missed the ; and that prompt indicates it. It can also indicate a missing close ' and other handy things.

i've since added the semicolon....:S

but i am still getting an error user@domain is not allowed to connect.

any ideas?

is there a skip networking option that i am missing?