Jørn Dahl-Stamnes wrote:
> This is perhaps a bit off-topic, but...
>
> 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
>
> $cfg['Servers'][$i]['host'] =
> 'sql.dahl-stamnes.net';
>
> a 'host sql.dahl-stamnes.net' shows that it is an alias
> pointing to another 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 password: NO)
>
> 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.
>
> 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/[EMAIL PROTECTED]
