Remote connection to MySQL server...?

From: Christopher J. Bottaro (cjbottaro_at_alumni.cs.utexas.edu)
Date: 10/20/04

  • Next message: James Kosin: "Re: Porblems creating RW discs in K3B" 
    To: fedora-list@redhat.com
Date: Wed, 20 Oct 2004 10:12:44 -0500

    Hello,
    I'm having a few issues with MySQL using the FC2 distro.

    First off, I can't remotely connect to the database. I did:

    GRANT ALTER,CREATE,DELETE,DROP,INSERT,SELECT
    ON mydb.*
    FOR 'cjb'@'*'

    That added a corresponding entry into mysql.user, but when I try to connect
    by a remote machine via tora, it says it can't open a connection.
    Connecting via tora on the localhost works fine. Do I need a specific port
    open on my firewall?

    My second problem is really more a nuisance than a real problem. When I
    execute "service mysqld start", it sits there for a while then finally says
    about timing out then [failed]. Well, it didn't fail cuz I can connect and
    use the database just fine...so whats up with the failure message (and semi
    long wait for the "timeout")?

    Thanks for the help. 

    -- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: James Kosin: "Re: Porblems creating RW discs in K3B"

    Relevant Pages

    • Re: Access Database becoming corrupt
      ... broken remotely or they go home on LAN and the server needs restarting etc. ... HP switch, 1 gig connection to server, 100mb to clients. ... Hired vendor to create inventory and sales database in ms-access. ... Vendor said he lost remote connection to our system, ...
      (microsoft.public.windows.server.sbs)
    • RE: Problems in terminal services, suggestions anyone?
      ... If the TS & Fox Pro database are on the same network, connections are not being dropped and no other application is affected then the problem is almost certainly with your installation of Fox Pro, which Citrix won't help at all. ... and at both the remote offices with a VPN. ... lose their connection to the database. ...
      (microsoft.public.windows.terminal_services)
    • Re: Multiple Simultaneous Sessions on Remote Desktop PC
      ... a plain VPN.. ... Although XP Pro supports only one incoming connection, ... Remote Networking Technology Support Site - ... >Because the solution is not based on a server database ...
      (microsoft.public.windowsxp.work_remotely)
    • Re: no idea how to proceed
      ... PCAnywhere is acceptable, if somewhat sluggish response depending on ... VPN connection is not recommended. ... Access database over a remote connection will likely lead to ...
      (microsoft.public.access.security)
    • Re: willing to pay for help
      ... Remote Desktop/terminal services may be a better ... > using connection manager, i can connect to the sbs server remotely, ... i need to access a database for a vet software program. ...
      (microsoft.public.windows.server.sbs)