Hi

I am trying to set up remote access to mysql on a headless server. From what I have read this can be done by installing phpmyadmin on the client pc. Is this all I need?

I have changed the entry in my.cnf "bind = localhost" to "bind = ipofserver". Not sure if this was necessary as it is an internal ip and I only need access from within the network.

I believe I must also change config.inc.php on the client to include details of the server I wish to connect with.

If someone could advise me whether I am on the right lines here as I do not want to do anything that will compromise the security of the server.

Thanks in advance.

Re: Mysql remote access with phpmyadmin 80 80

What OS and what webserver are you using

I am trying to set up remote access to mysql on a headless server. From what I have read this can be done by installing phpmyadmin on the client pc.

No thats wrong. the idea is to install PHPMyAdmin and host it the web server on the mysql server.

Its a web application. You can then use the web interface to control the server remotely.

Re: Mysql remote access with phpmyadmin 80 80

The server is running ubuntu 6.06lts and I am running debian. I am trying to set it up so it can be accessed from a windows xp machine. The ubuntu server has no x-window system and is command line only.

I thought I was getting somewhere... lol, clearly not. Any help greatly appreciated.

Re: Mysql remote access with phpmyadmin 80 80

If I type http://ipofserver/phpmyadmin/ I get a page of text starting with <?php

Idealy I would like to use https instead of http. I have set up a root mysql password but it did not ask for it??

Re: Mysql remote access with phpmyadmin 80 80

well do you have PHP installed?

http://www.daniweb.com/forums/thread78131.html

If you just do apt-get install phpmyadmin it will do all the install and config for you.

Re: Mysql remote access with phpmyadmin 80 80

Yeah I have all the correct packages installed (apache2 php5 libapache2-mod-php5 mysql-server mysql-client php5-mysql phpmyadmin ssh).

I have also created mysql user and given permission for access from my pc. (I followed guide peter_budo suggested, thanks).

When I enter "http://ipofserevr/phpmyadmin" I am still getting this text page -

<?php
/* $Id: index.php,v 2.33 2006/01/17 17:02:28 cybot_tm Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* forms frameset
*
* @uses libraries/common.lib.php global fnctions
* @uses libraries/relation.lib.php table relations
* @uses $GLOBALS
* @uses $GLOBALS............

As the server is internal it's domain name is made up, when I start apache I get a message -

"unable to lookup SERVER.example.com via gethostbyname()"

I was thinking of changing the /etc/hostname entry to the ip address of the server, not sure if this is a security mistake or not?

Re: Mysql remote access with phpmyadmin 80 80

Have resolved issue with -
"unable to lookup SERVER.example.com via gethostbyname()"
the /etc/hosts file didn't have the correct info.

Will keep trying to sort why when trying to access phpmyadmin on server I get a txt file and not a login page ???

Re: Mysql remote access with phpmyadmin 80 80

Are you bound to PHPMYADMIN on the XP side. If you just want to connect to the database remotely you can get the community edition of SQLyog for free at this site.
http://www.webyog.com/en/downloads.php

Re: Mysql remote access with phpmyadmin 80 80

Ok for some reason it appears that apache does not have access to php causing text to be displayed when I try to load phpmyadmin. Am going to reinstall apache and php to sort. I didn't want to do this but my newbie knowledge has reached its limit.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.