вторник, 23 июля 2013 г.
суббота, 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';
$ 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';
Подписаться на:
Сообщения (Atom)