Hi,
I'm trying to use a piece of software that requires connection to mysql databases. It uses Mysql ODBC connector 3.51.12 to this.
Connection is established thru vpn which works fine. I'm able to use ssh and connection to database in ssh session works fine with the same username + password.
I'm getting an error message like this when trying a remote connection:
[MySQL][ODBC 3.51 Driver]Access denied for user 'dbuser'@'pcname.domain.com' (using password: YES)
This is what I have done before:
config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot
config show mysqld
-> mysqld=service
TCPPort=3306
access=public
status=enabled
I'm not an expert with mysql but gotta feeling that I have not established enough privileges to this user. By the way I gave rights like this:
grant all privileges on dbname.* to dbuser@'192.168.1.0/255.255.255.0' identified by 'password';
Any ideas ?
Thanks, Jysse
06112007
I did as I was told to in this thread. First, same error messages as before until I noticed that in ODBC- config database name was wrong...
First letter of database name was in capital letter. Hmm, a little bit shamed.