>I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: > > - Format: > grant all privileges on databaseName.tableName > to 'userName'@'hostName' > identified by 'somePassword'; > > > - Example: > grant all privileges on myDB.* > to 'clyde'@'coolPlace.org' > identified by 'secretPass'; > >Then you'll need to reload the access privileges. It can be done at the command line like this: > > % mysqladmin -u rootUserName reload > >Remember, you may need to add the -p switch and suply a password for this command. > >Is this enough info?
One more important question, if these privileges are now granted, will it then be possible for me to connect from MySQL client at the local machine to MySQL server at the remote machine? More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. c:>mysql\bin\mysqld c:>mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Or I will just run the MySQL client to connect to remote machine without neccessarily running MySQL server at the local machine c:>mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Thanks for giving me relieve. -kamal. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php