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:
> 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.

<snip>

there you go:

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

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

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

On Jul 5, 7:53=A0am, Johannes Ke=DFler <m...@bananas-playground.net>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 05/07/10 16:41, JRough wrote:
>
> > I have been using mysql localhost for testing with php.
> > I want to use my host server =A0for testing on my outside IP for one
> > demo database.
>
> <snip>
>
> there you go:
>
> http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-...
>
> regards,
> Johannes Ke=DFler
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.15 (GNU/Linux)
>
> iEYEARECAAYFAkwx8gEACgkQE++2Zdc7EteAnQCcCNSjFoREaFFoSXiR9NyEoGH9
> yG0AnjCF2miYIQ6bL3tIlHMy0++3LiEc
> =3DRJAj
> -----END PGP SIGNATURE-----

 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=3D root
pid-file =3D /var/run/mysqld.pid
socket =3D /tmp/mysql.sock
port =3D 3306
basedir =3D /usr
datadir =3D /usr/local/mysql-5.0.77-osx10.4-powerpc/data
tmpdir =3D /tmp
language =3D /usr/share/mysql/English
bind-address =3D janisrough.dyndns.net
thanks,

On Jul 5, 7:53=A0am, Johannes Ke=DFler <m...@bananas-playground.net>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 05/07/10 16:41, JRough wrote:
>
> > I have been using mysql localhost for testing with php.
> > I want to use my host server =A0for testing on my outside IP for one
> > demo database.
>
> <snip>
>
> there you go:
>
> http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-...
>
> regards,
> Johannes Ke=DFler
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.15 (GNU/Linux)
>
> iEYEARECAAYFAkwx8gEACgkQE++2Zdc7EteAnQCcCNSjFoREaFFoSXiR9NyEoGH9
> yG0AnjCF2miYIQ6bL3tIlHMy0++3LiEc
> =3DRJAj
> -----END PGP SIGNATURE-----

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:
> On Jul 5, 7:53 am, Johannes Ke�ler <m...@bananas-playground.net>
> wrote:
> On 05/07/10 16:41, JRough wrote:
> 
>>>> 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.
> 
> <snip>
> 
> there you go:
> 
> http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-...
> 
> regards,
> Johannes Ke�ler

> also, there is no directory for /usr/share/mysql/English  only the /
> usr/share , no mysql  or English  is English default/

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++2Zdc7Etd26ACffMzxwJ4caDiDnqwyOW9Rj6ri
6OUAnRwOAo/vs3GvYxGd8k4blUwimKI/
=xv9M
-----END PGP SIGNATURE-----