> I then try to connect to the server from a remote location and get > ERROR 1130: Host 'xxx.yyy.zzz' is not t allowed to connect to > this MySQL server > which is normal since i did not create a user yet > > I do this: > GRANT ALL PRIVILEGES ON *.* TO stew@'%' IDENTIFIED BY '123' WITH > GRANT OPTION; > flush privileges; > > and I get this again when i try to connect using > mysql -h the_host_name -u stew -p > > ERROR 2013: Lost connection to MySQL server during query > In other words, the server was not able to connect the first time because > it did not have permission, but the second time it did, and i get this > lousy error again. > > However, I am able to do the same command and connect from my XP > workstation where mysql client is installed. so I have no clue why it is > not working from the server where I really need it to work. > > I am getting really desperate after 3 weeks of this same error. Can you > please help
Assuming mysql server is running on a unix box, does the connecting client have permissions to mysqld in the hosts.allow file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]