everythingandtwo Posted May 24, 2003 Share Posted May 24, 2003 I\'m trying to backup a database that I have located on one server to another server on my network. So far I haven\'t had any luck. I can back the database up to a file locally, but not across the network. Here is the syntax I\'m using along with the error message... C:mysqlbin>mysqldump -u webuser -p pass --opt fonemail | mysql --host=10.192.212.34 fonemail_backup ERROR 1044: Access denied for user: \'@OSPSDEV3\' to database \'fonemail_backup\' I\'ve created a DB called fonemail_backup at the remote location and I have granted all privileges to webuser@OSPSDEV3 however it is still saying access denied. Can anyone help me out? Thanks! - Brad Quote Link to comment Share on other sites More sharing options...
barbatruc Posted May 26, 2003 Share Posted May 26, 2003 Is the access granted elsewhere than from localhost for this user? Use your IP for this field or simply % to allow connections from everywhere for this user. JP. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.