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
accessing server database from client?
Moderator: General Moderators
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.
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 ittimvw 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.
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