MySQL ODBC Connector

Author

myPhpAdmin

Jørn Dahl-Stamnes

2006-01-04, 7:23 am

This is perhaps a bit off-topic, but...

I tried to install and configurate phpAdmin on an internal web-server. I=20
copied a default config file and created my own config.inc.php file. In thi=
s=20
I set

$cfg['Servers'][$i]['host'] =3D 'sql.dahl-stamnes.net';

a 'host sql.dahl-stamnes.net' shows that it is an alias pointing to another=
=20
machine where the mySQL server is running.

However, when trying to access myPhpAdmin, I get the following error:

Error

MySQL said: Documentation
#1045 - Access denied for user 'quest'@'r2d2.dahl-stamnes.net' (using=20
password: NO)=20

It seems like the host name given in the config file is ignored and that it=
=20
try to connect to the host where the web-server is running.

It should not be like this, should it?
=20
=2D-=20
J=F8rn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Peter Normann

2006-01-04, 7:23 am

J=F8rn Dahl-Stamnes wrote:
> This is perhaps a bit off-topic, but...
>=20
> I tried to install and configurate phpAdmin on an
> internal web-server. I copied a default config file and
> created my own config.inc.php file. In this I set
>=20
> $cfg['Servers'][$i]['host'] =3D
> 'sql.dahl-stamnes.net';=20
>=20
> a 'host sql.dahl-stamnes.net' shows that it is an alias
> pointing to another machine where the mySQL server is
> running.=20
>=20
> However, when trying to access myPhpAdmin, I get the
> following error:=20
>=20
> Error
>=20
> MySQL said: Documentation
> #1045 - Access denied for user
> 'quest'@'r2d2.dahl-stamnes.net' (using password: NO)
>=20
> It seems like the host name given in the config file is
> ignored and that it try to connect to the host where the
> web-server is running.=20
>=20
> It should not be like this, should it?

Actually, yes. The error indicates that the user ('quest') you have =
defined
in your config file, has not been authorized to access the database from
your host 'r2d2.dahl-stamnes.net'

If you have access to a mysql console on the mysql host, try this:

GRANT ALL PRIVILEGES ON <database name>.* TO =
'quest'@'r2d2.dahl-stamnes.net'
IDENTIFIED BY 'somepassword';

FLUSH PRIVILEGES;

Remember to set the password in the config file accordingly...

Regards,

Peter Normann

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links