PDA

View Full Version : SQL connection problem



powers
29th June 2007, 12:12 AM
I am trying to connect to a mysql database remotely and I am having a permission problem.

Client system - Linux (Ubuntu 7.04) - linuxclient.domain.com
Joined to the domain with a DNS entry.

Server - Tru64 mysql 3 something

Permissions - user@%.domain.com
I verified this info with the admin and the Windows system we logged in from.

Tests -

client to Tru64 sql -
user@linuxclient:~$ mysql -u dbuser -h tru64sql.domain.com -p
Enter password:
ERROR 1045 (00000): Access denied for user: 'dbuser@' (Using password: YES)

client to linux sql for comparison - This system has the identical permission setup @%.domain
user@linuxclient:~$ mysql -u dbuserLinux -h linuxsql.domain.com -p
Enter password:
ERROR 1045 (28000): Access denied for user 'dbuserLinux'@'linuxclient.domain.com' (using password: YES)

I can see why the connection doesn't happen (missing @domain info) but I don't know how I can fix this. Has anyone had to deal with this before or have any ideas??

Thanks

ongola
29th June 2007, 10:07 AM
hello powers,
i do not read clearly all your informations above but:
- have you grant the right user WITH the right host in the mysql user table? , read the mysql tutorial and mysql database administration guides (you should have all these docs installed or find them at dev.mysql.com)
- is the server port (normally 3306) is open ? check your firewall

powers
29th June 2007, 03:40 PM
This connection works fine from other Linux/windows/mac client systems.