Alexander Dalloz wrote: > Am Mi, den 20.10.2004 schrieb Christopher J. Bottaro um 18:08: > >> Port 3306 is open and /etc/my.cnf has a line "port = 3306" in the >> [mysqld] >> section. Yes, I've read the mysql manual and I *think* I've setup my >> user >> to be able to connect from the remote host. Here is the relevant portion >> of my mysql.user table: >> >> +-------------+---------+------------------+ >> | Host | User | Password | >> +-------------+---------+------------------+ >> | aa.bb.cc.dd | pymymud | (hashed passwd) | >> +-------------+---------+------------------+ >> >> Then from aa.bb.cc.dd, I try to connect: >> >> mysql -u pymymud -p -h <ipaddr of mysql server> -P 3306 pymymud >> ERROR 1130: Host 'aa.bb.cc.dd' is not allowed to connect to this MySQL >> server > > Yes, the reply by the MySQL server indicates that a connection did > happen and that the attempt was rejected by the MySQL server. Did you > really create the user using "GRANT" or "INSERT"? To be sure the new > permissions are read in run "FLUSH PRIVILEGES;" as root on the mysql > command line. Hey that worked! Thanks very much. This is going off topic now, but how can I copy database X from host A to host B. To be more clear, I installed MySQL on machine A and I've created a database with a bunch of tables, etc. Now I want to copy that database to machine B (which also has MySQL installed on it). Thanks for the help.
