I have been using mysql localhost for testing with php.
I want to use my host server for testing on my outside IP for one
demo database.
In phpmyadmin the server is Server:localhost. My database is listed
under the localhost but I want it available to the outside on
myhostname.
How do you change it to Server:myhostname in phpmyadmin? or
mysqladministrator?
I tried to connect in mysqladministrator to the hostname with the root
login and it says access denied for that user which is correct because
when I log in to localhost i can't add the hostname to the root
account. Do I add the hostname to the grant tables?
I only want to do this for testing for a few users. I will fix the
security problem of using the root account later. I had a mysql user
but I forgot the password. I just need to get it working so I can
test on it. thanks,

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/07/10 16:41, JRough wrote:
<snip>

there you go:

http://www.cyberciti.biz/tips/how-do...se-server.html

regards,
Johannes Keßler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.15 (GNU/Linux)

iEYEARECAAYFAkwx8gEACgkQE++2Zdc7EteAnQCcCNSjFoREaF FoSXiR9NyEoGH9
yG0AnjCF2miYIQ6bL3tIlHMy0++3LiEc
=RJAj
-----END PGP SIGNATURE-----

On Jul 5, 7:53*am, Johannes Keßler <m... (AT) bananas-playground (DOT) net>
wrote:
Does this look like it would work this is a mac? It is a guess.
There is a var/run directory but no mysqld.pid.
Do I create one or does it create it automatically? The tmp/
mysql.sock location seems to be where mysqladministrator finds it.
Do you know if I can use my hostname, for example jaisrough.dyndns.net
or does it have to be a IP number ? thanks,
[mysqld]
user= root
pid-file = /var/run/mysqld.pid
socket = /tmp/mysql.sock
port = 3306
basedir = /usr
datadir = /usr/local/mysql-5.0.77-osx10.4-powerpc/data
tmpdir = /tmp
language = /usr/share/mysql/English
bind-address = janisrough.dyndns.net
thanks,

On Jul 5, 7:53*am, Johannes Keßler <m... (AT) bananas-playground (DOT) net>
wrote:
also, there is no directory for /usr/share/mysql/English only the /
usr/share , no mysql or English is English default/

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/07/10 21:42, JRough wrote:
Sorry for the late reply, but I can't help you with this on a mac.
Try a google search if nobody answers.

regards,
johannes keßler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.15 (GNU/Linux)

iEYEARECAAYFAkw0JHgACgkQE++2Zdc7Etd26ACffMzxwJ4caD iDnqwyOW9Rj6ri
6OUAnRwOAo/vs3GvYxGd8k4blUwimKI/
=xv9M
-----END PGP SIGNATURE-----