Connecting multiple W2K IIS servers to remote MySql server - error mssg

[RS25.com]

Hi,

I am currently running a single W2K and MySql box, but the load is getting to be a bit much so I want to push the web servers off to their own boxes and have MySql run on it's own dedicated box. To start with, I am connecting a secondary box I have running to my remote MySql server, but I keep getting this error:

Warning: Access denied for user: 'UserName@chat.rs25.com' (Using password: YES) in E:\Inetpub\www.rs25.com\Forums\admin\db_mysql.php on line 38


Well, I have changed the following two files:

admin\Config.php
admin\db_mysql.php

Specifically, I changed the lines that dealt with the IP address of the MqSql server to that which it is, and of course the username and password to match what is being used.

I can connect to the MySql server by using Telnet on port 3306, but can't seem to get the MySql server to allow this second server to connect.

I've searched but found no answers. Any help would be greatly appreciated.

Thanks!

James F
www.rs25.com/forums (http://www.rs25.com/forums)

[Floris]

The error says access denied so I guess you are not allowing remote connections, or the user can't access it because it is unknown on the remote box.

I didn't know db_mysql.php had to be changed in order to work remote, I thought only config.php

[Steve Machol]

Don't make any changes to db_mysql.com. That error is because one or more of the following is wrong in your config.php file:

$dbusername
$dbpassword
$dbname

If you are unsure of what the appropriate values are then you will need to ask your web host.

[AWS]

You need to grant access to mysql with something like this:

GRANT ALL PRIVILEGES ON *.* TO username_in_config.php@"%" IDENTIFIED BY 'password_in_config.php';

[RS25.com]

Originally posted by AWS
You need to grant access to mysql with something like this:

GRANT ALL PRIVILEGES ON *.* TO username_in_config.php@"%" IDENTIFIED BY 'password_in_config.php';

I tried to telnet to do this, but get a "bad handshake" error (along with the weirdest command prompt I have ever seen.)

Any suggestions, or is there a configuration file I can stick that code into?

Thanks.

BTW, I am hosting all the servers myself, so I have 100% access to everything and anything on the box. Thanks again! :D

[AWS]

Originally posted by RS25.com
I tried to telnet to do this, but get a "bad handshake" error (along with the weirdest command prompt I have ever seen.)

Any suggestions, or is there a configuration file I can stick that code into?

Thanks.

BTW, I am hosting all the servers myself, so I have 100% access to everything and anything on the box. Thanks again! :D If you have access to the box then just open a command prompt and use mysql prompt for the command. Make sure you end the command with a ; when you work for the mysql monitor prompt.