How can I set to allow all the people to access mysql databases??I mean like how to set wildcard so that anyone can access mysql databases.

  • What type of access do you want to allow? By default, mysql requires a user account/password for access. You can create a user account with very limited permissions (read-only) through PHPMyAdmin (which from your other posts I know you are running). Granting unrestricted access is a major security hole. – douggro Dec 6 '13 at 16:09
  • I want to access my server's databases by a program which is on other's computers.. – Farukh Dec 6 '13 at 16:16

By reading your comments, you want to access from another computer. This can be done the following way:

  1. In /etc/mysql/my.cnf

uncomment bind-address

# bind-address

Restart mysql:

sudo /etc/init.d/mysql restart

Now you can add a new user (for example with phpmyadmin) an restrict the connection to the ip of the other computer.

You can add a user without IP-Restriction but this is highly insecure!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.