$ 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';
Комментариев нет:
Отправить комментарий