Fedora Linux Support Community & Resources Center
  #1  
Old 29th June 2007, 12:12 AM
powers Offline
Registered User
 
Join Date: Nov 2006
Posts: 4
SQL connection problem

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
Reply With Quote
  #2  
Old 29th June 2007, 10:07 AM
ongola Offline
Registered User
 
Join Date: Nov 2006
Location: Douala, Cameroon
Age: 35
Posts: 14
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
Reply With Quote
  #3  
Old 29th June 2007, 03:40 PM
powers Offline
Registered User
 
Join Date: Nov 2006
Posts: 4
This connection works fine from other Linux/windows/mac client systems.
Reply With Quote
Reply

Tags
connection , problem , sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Net connection problem.... venkat3271 Servers & Networking 1 20th June 2007 04:21 PM
Problem with DNS for DSL connection nardinc Servers & Networking 2 24th January 2007 04:07 PM
FC5: Problem Slow PGSQL Connection, SSH connection dunadan67 Servers & Networking 4 5th June 2006 09:42 PM
VNC Connection Problem xgamma Using Fedora 8 6th September 2005 02:48 PM
Problem with 2 DSL connection ssnathan1975 Servers & Networking 0 28th July 2005 06:09 AM


Current GMT-time: 09:45 (Tuesday, 17-10-2017)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat