SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Feb 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post mysql can't connect from client side

    hello,

    I am running mysql-5.0.77-linux-i686 in fedora 10. I already configured
    mysql server in my apache web server. Its running nicely. For starting mysql & to run the MySQL client program and connect to the MySQL
    server I type the following command:
    mysql -h hostname u username -p

    My client program is run on the same computer as the server thats why I use -h localhost or h 127.0.0.1. if I leave this part(hostname) thats also no problem mysql server also running in my pc(server).
    But problem is that other client in the network (intranet) can't connect with this server. My web server already connected with the intranet. other client can use my web server but can't connect with
    the mysql databse server.

    can anyone please give me any idea in that.

    thank you in advance.

  2. #2
    SitePoint Addict
    Join Date
    Dec 2007
    Posts
    358
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If they just cannot connect, they it may be firewall problem.
    If then cannot login, then it may be MySQL configuration issue: you need to allow the user to connect from the specific host. See GRANT examples here: http://dev.mysql.com/doc/refman/5.1/en/grant.html
    I'm creating trouble-free Apache, PHP, MySQL installer, WITSuite,
    and use it to setup my development environment.
    Demo, support, contact. Questions?

  3. #3
    SitePoint Evangelist
    Join Date
    Aug 2007
    Posts
    566
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    look in my.cnf, if you don't have a
    Code:
    skip-networking
    in there. This would mean that the sql server don't listen to network connection.
    As local / localhost connection are going through a pipe, and not the network, it would be the reason why you can connect and not the other computer


Bookmarks

Posting Permissions

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