accessing server database from client?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

accessing server database from client?

Post by rami »

i have linux as a server acting as web server redhat 9 for php and mysql pages and there are around 20 comp in network ..actuallyt it is windows computer's star topology ..
i have joined that linux computer in the network and changed the tcp server setting ip of windows computer

i have made DNS (resolution) in that linux comp as well
the intranet is working fine

i have php scripts and mysql database in server which is managed phpmyadmin

My question is
is it possible to excess ,run query (alter ,create ..all)
installing phpmyadmin in one of the windows workstation of the network....

Being in work station i want to access database file of server in client phpmyadmin program...

ok setting password and setting permission in server
....can it be done

mind you server is in linux ..client are windows ..no samba for now...

i just done want to touch that server frequently ...
how can it be done
what setting i have to make
thanks
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

Post by rami »

cannot be done...so bad..
thanks
AGISB
Forum Contributor
Posts: 422
Joined: Fri Jul 09, 2004 1:23 am

Post by AGISB »

Just look into plink and sshtunneling.

There might be a way to do it.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

The first you have to do is configure mysql to allow tcp/ip connections (i remember that debian defaults this to off, somewhere in my.cnf).
Now you have to configure and account that is allowed from different locations (grant all on databasename.* to 'username'@'*')
Next you have to do is configure your phpmyadmin to connect to 'somehost', 'username', 'password'.

Only do this in a secure network, because everything is send in cleartext over your network.
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

Post by rami »

timvw wrote:The first you have to do is configure mysql to allow tcp/ip connections (i remember that debian defaults this to off, somewhere in my.cnf).
Now you have to configure and account that is allowed from different locations (grant all on databasename.* to 'username'@'*')
Next you have to do is configure your phpmyadmin to connect to 'somehost', 'username', 'password'.

Only do this in a secure network, because everything is send in cleartext over your network.
i got it
it can be done
could u be more clear with it ..how can it be done...
i am not able to do it all
some tutorials...?
thanks for reply
rami
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Post Reply