суббота, 13 июля 2013 г.

install mysql on raspberry pi and connect from laptop

$ sudo apt-get update
$ sudo apt-get install apache2 php5 mysql-server
$ sudo apt-get install phpmyadmin

to enable remote connection replace 127.0.0.1 in /etc/mysql/my.conf to real ip

the working application is at http://your_rpi_host/phpmyadmin
or download any application and look at db from it

to add user
$ mysql -u root -p mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO  'dbuser'@'%'  IDENTIFIED  BY  'dbpassword';
mysql> FLUSH PRIVILEGES;

mysql> CREATE DATABASE foo;
mysql> GRANT ALL ON foo.* TO 'foouser'@'%' IDENTIFIED BY 'PASSWORD';