Page 1 of 1

accessing server database from client?

Posted: Sun Oct 30, 2005 9:31 pm
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

Posted: Mon Oct 31, 2005 6:33 pm
by rami
cannot be done...so bad..
thanks

Posted: Tue Nov 01, 2005 1:07 am
by AGISB
Just look into plink and sshtunneling.

There might be a way to do it.

Posted: Tue Nov 01, 2005 3:26 am
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.

Posted: Tue Nov 01, 2005 10:26 am
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

Posted: Tue Nov 01, 2005 11:13 am
by timvw