MySQL Access From Remote Computer
By Default MySQL only accept local connection to enable MySQL access from remote computer we need to make some changes. Edit /etc/mysql/my.cnf file and search for bind-address line and comment it out and save it.
1 |
# bind-address = 127.0.0.1 |
User Permission Login to MySQL by issuing following command, you will be prompted for my your MySQL root password.
1 |
mysql -u root -p |
Enter MySQL root password that we set when you installed MySQL server on rpi, after successful login issue following command to give access to…