nixCraft
Ubuntu server allow tcp Mysql connection from remote system
This is a discussion on Ubuntu server allow tcp Mysql connection from remote system within the Databases servers forums, part of the Mastering Servers category; Hey how do i allow Ubuntu Linux Mysql server to talk over tcp connection from remote system TIA...
|
|||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
01-18-2007, 03:12 AM
|
|||
|
|||
Ubuntu server allow tcp Mysql connection from remote system
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 
|
| Sponsored Links | ||
|
|
|
01-25-2007, 03:22 AM
|
||||
|
||||
|
open /etc/mysql/my.cnf file
Code:
sudo vi /etc/mysql/my.cnf Code:
bind-address = 192.158.5.1 Code:
# skip-networking Code:
sudo /etc/init.d/mysql restart Code:
update db set Host='202.54.10.20' where Db='webdb'; update user set Host='202.54.10.20' where user='webadmin';
|
|
06-11-2007, 10:30 PM
|
|||
|
|||
|
Client machine requirements?
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.
|
|
06-11-2007, 11:06 PM
|
||||
|
||||
|
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.
|
 |
| Bookmarks |
| Tags |
| /etc/my.cnf , linux , mysql , networking , ubuntu linux |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| problem with System + MySQL backup script | massoo | Shell scripting | 1 | 08-20-2007 09:50 PM |
| MySQL remote server access howto | raj | Databases servers | 0 | 07-29-2007 05:32 AM |
| Ubuntu: Issue accessing any System applications | hightech | Linux software | 4 | 01-29-2007 09:56 AM |
| install and configure vmware server on Ubuntu Linux server | raj | Linux software | 1 | 07-17-2006 11:21 PM |
| Setting up RAID 1 mirroring on a running remote Linux system | sweta | Getting started tutorials | 8 | 06-22-2006 11:48 AM |
All times are GMT +5.5. The time now is 05:09 PM.
