brotherhood_of_LAN - 4:45 am on Jul 31, 2012 (gmt 0)

You're welcome.

> 1)Can you tel me where can i change the server name instead of localhost.

From the command line

mysql -h localhost -u root -p databasename --password=root

Where -h stands for host.

> 2)How to configure the mysql to allow access from any non localhost.Is it to be done on installation?

This pretty much covers it: [debianhelp.co.uk...]

As I said earlier, it depends on the setup. On shared hosts you may not be able to edit the MySQL settings. On the other hand you may be able to connect from a remote IP with its current setup.