FedoraForum.org - Fedora Support Forums and Community
Results 1 to 3 of 3
  1. #1
    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

  2. #2
    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

  3. #3
    Join Date
    Nov 2006
    Posts
    4
    This connection works fine from other Linux/windows/mac client systems.

Similar Threads

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •