Cannot connect to MySql Server remotely
I am doing volunteer work at a non-profit. We have a Suse Linux 10.0 box ip address 192.168.0.100, with MySql Server 5.0.15, with Apache2 running a custom PHP application.
We want to write some reports in Microsoft Access, using MySql odbc drivers, from various workstations, only workstations on the local subnet 192.168.0.0/24 will need access. They have never accessed the database this way before.
The workstations cannot connect. I have been using telnet 192.168.0.100 3306 and I get 192.168.0.150 is not allowed to connect to this MySql Server.
Things we have done:
Added bind-address = 192.168.0.100 in my.cnf
Remarked out skip-networking.
(we then stopped and restarted mysql server).
The firewall is not running on this server, however we added IP Table exceptions to port 3306. Have verified that port 3306 is the default port.
We issue the command
netstat -an | grep 3306
we get:
tcp 0 0 192.168.0.100:3306 0.0.0.0:* LISTEN
Permissions have been a problem. We cannot sign on to MySql as root. Whoever created this build has a special db admin, called dbadmin.
We can login to mysql accordingly:
We use putty to connect to the server, su as root, and get the # prompt.
#>mysql -u dbadmin -p
We get to the mysql prompt
But we cannot do mysql -u root -p
We use the root logon password (and a blank password) and it says
Access denied for user 'root'@'localhost' (using password: YES)
The grant all commands do not work when logged on as dbadmin, we get 'dbadmin'@'localhost' denied
The special dbadmin user (according to Webmin) is not in the normal user list, it is viewable by going to Servers, MySql Database Server, click Module Config.
The PHP application uses the dbadmin ID.
In Webmin, when we try to access global options (in MySql Server), (user permissions, database permissions, host permissions, etc.) we get:
DBI connect failed : Access denied for user 'dbadmin'@'localhost' to database 'mysql'
