Unanswered: [SOLVED] Can't access with normal users
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.
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....
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.
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.