Operating System - HP-UX
1833172 Members
3023 Online
110051 Solutions
New Discussion

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

 
SOLVED
Go to solution
Rgomes
Valued Contributor

HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

Hi All,

My MySQL is installed on hpux box (11i). I want to connect to this MySQL server from phpmyadmin, which is installed on a linux machine.

But whenever I want to connect to the MySQL server, get the error message " mysql said: Access denied for user: 'root@proxy' (Using password: YES)".

Here 'proxy' is the linux machine.

If someone has the solution of this problem, pls share with me.

Thanks in advance,
Richard
5 REPLIES 5
Alex Lavrov.
Honored Contributor

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

Hey,
Did you grant access to 'root@proxy' to your box?
I don't give a damn for a man that can only spell a word one way. (M. Twain)
Rgomes
Valued Contributor

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

Hi Alex, thanks for your replay!

Permitting 'root@proxy' from .rhost or from MySQL? How can I permit 'root@proxy' from MySQL?

regards,
Richard
Alex Lavrov.
Honored Contributor
Solution

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

From MySQL:

grant all on .* to 'root'@'proxy';
flush privileges;

I don't give a damn for a man that can only spell a word one way. (M. Twain)
Rgomes
Valued Contributor

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

Hi Alex, I'll check it tomorrow.. and let you know.

Thanks and regards,
Richard
Rgomes
Valued Contributor

Re: HPUX 11i/ Iexpress/ MySQL --cannot connect remotely through phpamyadmin

Hi Alex, Thanks! ! !
Now I can connect to remote MySQL server from phpmyadmin (linux machine).

:-)
Richard