unable to connect to database from remote machine
Posted on 2007-07-31
I'm new to MySQL and are trying to get through with it. Need help from u masters...
Following is my network configuration...
I've installed MySQL 5.0 on machine A (192.168.1.21) with MySQL administrator 1.2.12. OS: Windows XP home edition (latest updates installed). MySQL ODBC connector driver installed on the machine and configured.
Service is running properly and I'm able to connect to the database (I've already created my database).
I've another machine B (192.168.1.212), which has Windows 2003 server, and is configured as domain controller and I'm using this machine for development (Visual studio installed, using visual basic). MySQL ODBC connector driver is installed, but while testing for connectivity using Test button it returns the error:
[MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'ServerName' (using password: YES)
Following are the config settings:
Data Source name: myodbc
Description: ODBC driver for MySQL
username: root (this is the default MySQL user at machine A)
Connect options tab:
Port: 3306 (default port is used)
rest fields are empty.
On both machines I'm logging as administrator.
My querries are:
What MySQL does:
Is it trying to connect to windows user database and searching 'root' user or the MySQL user.
In username, which user should I put, the one on remote machine(where the database is installed) or the one on local machine. On both machines I've created root user with same password so I suppose no confusinn.
On Windows XP machine, in firewall settings I also opened the 3306 TCP port, and then later on disabled the Firewall, but the problem remains same.
On Windows 2003 server machine I installed MySQL 5.0, but it was unable to start the service. The error message which comes after pressing Execute button:
Error no.: 1045
Access denied for user 'root'@'localhost' (Using password: YES)
Though the error is very obvious, that it is with the permissions, but again I've the same question. root is a Windows user or MySQL?
Prepare configuration is Tick marked
Write config file is Tick marked
Start service is tick marked
Apply security settings is cross marked
The security settings could not be applied
Error number 1045
Access denied for user 'root'@'localhost' (Using password: Yes)
I need an answer to both problems: