Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2012
    Posts
    5

    Unanswered: [SOLVED] Can't access with normal users

    Hi,

    I have a linux mysql server with latest stable (nowadays) version.
    I can access with root user, but no way with other created users. Neither from other (in same LAN) client pc nor local access in the server.

    Always receive 1045 Access denied error.

    User and password are right specified.

    Any idea of what may be happenning?
    Any help would be appreciated.

    Thanks and sorry for my bad english.
    Last edited by peperfus; 10-03-12 at 06:55.

  2. #2
    Join Date
    Oct 2012
    Posts
    5

    [solved] !!

    At last !!

    Found solution by searching in other forums.

    Problem was I created regular user with '%' (any server) in server field.

    Changed to localhost and now it works.

    Don't understand why. Supposedly "any server" should have worked.

  3. #3
    Join Date
    Oct 2012
    Posts
    5
    I have read and seen that in "my.cnf" config file there is a parameter named: bind-address, set to localhost.
    If I comment that parameter and restart mysql server, then, a user from any host can access and % wildcard works again.

    I suppose this is for security reasons, but I think it is confusing to have such security levels because is harder to administer....

  4. #4
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    The bind address allows you to specify an IP address on which to accept connections. If you are only ever going to access this locally you should have this set to localhost or --skip-networking option. This is for maximum security. If you are going to connect remotely then certainly bind address should not be set.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  5. #5
    Join Date
    Oct 2012
    Posts
    5
    Hombre, eres del País Vasco? Estuve viviendo en Bilbao un año y medio.

    ¿Quieres decir que si sólo accedo al servidor mysql desde los ordenadores de mi LAN, puedo dejar bind-address en localhost y eso hará rechazar las conexiones externas a mi LAN?

    Entonces así lo dejaré, ya que no accedo desde fuera.


    Gracias

    Thank you

  6. #6
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Soy irlandes pero viviendo en San Sebastian. Estoy todavia aprendiendo castellano.

    No. Si accedes desde lo mismo servidor donde existe MySQL pones bind-address=localhost. Por ejemplo si tienes un aplicacion escrito en PHP que necesite acceder al MySQL desde Apache pone bind-address=localhost. Si tienes que acceder al MySQL desde otros ordenadores en tu LAN no necesitas bind-address.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  7. #7
    Join Date
    Oct 2012
    Posts
    5
    Ok, entendido.

    Muchas gracias por tu ayuda.

Posting Permissions

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