Game Development Reference
In-Depth Information
In
sites-available
, create a new file called
phpmyadmin
and use the following
configuration. Don't forget to create a symbolic link in
sites-enabled
and
reload nginx.
server {
location /phpmyadmin {
root /usr/share/;
index index.php index.html index.htm;
location ~ ^/phpmyadmin/(.+\.php)$ {
try_files $uri =404;
root /usr/share/;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME
$document_root$fastcgi_script_name;
include /etc/nginx/fastcgi_params;
}
location ~* ^/phpmyadmin/(.+\.
(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
root /usr/share/;
}
}
location /phpMyAdmin {
rewrite ^/* /phpmyadmin last;
}
}
You can now browse to
http://pi/phpmyadmin/setup
and follow the onscreen
instructions to get the most up-to-date and best practice information to set up
everything correctly and securely.
Installing SQLite3
SQLite3 is a self-contained, easy-to-install, lightweight transactional database. The
website boasts that it is the most deployed database in the world. As we know from
Wikipedia, it is mostly deployed on embedded devices, but the most used database
is still MySQL. None of this really matters to us because both these databases are
very good at what they do, except that SQLite is a better choice if you are looking
for performance on the Pi.
sudo apt-get install sqlite3 php5-sqlite