Rpi – Install MySQL and grant remote access

Posted by admin on November 3, 2012
Posted in: Other Stuff.

MySQL for the Pi is very easy, one command:

sudo apt-get install mysql-server

granting access to remote clients:

mysql> CREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD'
mysql> GRANT ALL PRIVILEGES ON 'MY_DATABASE'.* TO 'MY_USERNAME'@'12.34.56.78' IDENTIFIED BY 'MY_PASSWORD';