nixCraft

Hey

how do i allow Ubuntu Linux Mysql server to talk over tcp connection from remote system

TIA

__________________
Raj
Linux rulz.
I have never turned back in my life ; I shall not do so today.. haha

open /etc/mysql/my.cnf file
Make sure bind-address set to your server IP address (not to 127.0.0.1)
Also make sure line skip-networking is removed or commented out
Save and close the file; Restart mysql
Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin then you need to grant access to this IP address. At mysql> prompt type following command for existing database:
See My tip How Do I Enable remote access to MySQL database server?

__________________
Vivek | My personal blog
Linux Evangelist
+ ADD [SOLVED] thread prefix to your thread when your problem is sorted out by editing your thread.
+ Always use CODE tags for posting system output and commands!

Hi,
I have a remote machine that has the mysql server. but my clinet machine is different. I read you tip on how to get remote access to MySQL server. DO I need to have any MySQL software on the client machine. There is no mention of that in the tip. If so is there any way around it? My problem is that I cannot install anything on the client machine.

You need mysql client or programming language that support MySQL api like Perl, C, Php, Python etc. Type mysql and see if you get any output.

__________________
Vivek | My personal blog
Linux Evangelist
+ ADD [SOLVED] thread prefix to your thread when your problem is sorted out by editing your thread.
+ Always use CODE tags for posting system output and commands!