Mysql error

[davidvi]

I use the following:

 

- Mysql version 4.0.23

- PHP version 4.3.9

- Apache 1.3.33

 

My OS=Windows 2000 server SP4

 

When I try to setup the database for the first time I get the following error (clicking continu on page http://192.168.1.20/catalog/install/install.php?step=2):

 

Host 'apache.vijzelman.com' is not allowed to connect to this MySQL server

 

The mentioned is the name of the host where Mysql has been installed. In my opinion there is something wrong with login credentials to the mysql.

 

What can I do?

 

Thanks!

 

Dave :rolleyes:

[boxtel]

I use the following:

 

- Mysql version 4.0.23

- PHP version 4.3.9

- Apache 1.3.33

 

My OS=Windows 2000 server SP4

 

When I try to setup the database for the first time I get the following error (clicking continu on page http://192.168.1.20/catalog/install/install.php?step=2):

 

Host 'apache.vijzelman.com' is not allowed to connect to this MySQL server

 

The mentioned is the name of the host where Mysql has been installed. In my opinion there is something wrong with login credentials to the mysql.

 

What can I do?

 

Thanks!

 

Dave  :rolleyes:

<{POST_SNAPBACK}>

 

i think you should use localhost for the mysql on a dedicated server.

[davidvi]

Still get error

 

Host 'apache.vijzelman.com' is not allowed to connect to this MySQL server

 

This is the localhost, checked ini files and httpd files, is there anywhere a option to set the security in mysql?

[OceanRanch]

If you want to allow a user called 'myuser' to connect from any host with the password 'mypassword' :

 

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

 

if you want to allow a user called 'myuser' to connect from your station with the password 'mypassword' :

 

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

 

HTH

Tom