Let's put the Raspberry Pi to good use:<\/p>\n
<\/p>\n
1. Install Mysql<\/p>\n
sudo pacman -S mysql<\/p>\n
2. Start your server<\/p>\n
# systemctl start mysqld<\/p>\n
3. Secure your mysql installation<\/p>\n
# \/usr\/bin\/mysql_secure_installation<\/p>\n
——————-<\/p>\n
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
\n\t SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!<\/p>\n
\n\tIn order to log into MySQL to secure it, we'll need the current
\n\tpassword for the root user. If you've just installed MySQL, and
\n\tyou haven't set the root password yet, the password will be blank,
\n\tso you should just press enter here.<\/p>\n
\tEnter current password for root (enter for none):
\n\tOK, successfully used password, moving on…<\/p>\n
\tSetting the root password ensures that nobody can log into the MySQL
\n\troot user without the proper authorisation.<\/p>\n
\tSet root password? [Y\/n] y
\n\tNew password:
\n\tRe-enter new password:
\n\tPassword updated successfully!
\n\tReloading privilege tables..
\n\t … Success!<\/p>\n
\n\tBy default, a MySQL installation has an anonymous user, allowing anyone
\n\tto log into MySQL without having to have a user account created for
\n\tthem. This is intended only for testing, and to make the installation
\n\tgo a bit smoother. You should remove them before moving into a
\n\tproduction environment.<\/p>\n
\tRemove anonymous users? [Y\/n] y
\n\t … Success!<\/p>\n
\tNormally, root should only be allowed to connect from 'localhost'. This
\n\tensures that someone cannot guess at the root password from the network.<\/p>\n
\tDisallow root login remotely? [Y\/n] y
\n\t … Success!<\/p>\n
\tBy default, MySQL comes with a database named 'test' that anyone can
\n\taccess. This is also intended only for testing, and should be removed
\n\tbefore moving into a production environment.<\/p>\n
\tRemove test database and access to it? [Y\/n] y
\n\t – Dropping test database…
\n\t … Success!
\n\t – Removing privileges on test database…
\n\t … Success!<\/p>\n
\tReloading the privilege tables will ensure that all changes made so far
\n\twill take effect immediately.<\/p>\n
\tReload privilege tables now? [Y\/n] y
\n\t … Success!<\/p>\n
\tCleaning up…<\/p>\n
\tAll done! If you've completed all of the above steps, your MySQL
\n\tinstallation should now be secure.<\/p>\n
\tThanks for using MySQL!<\/p>\n
———————-<\/p>\n
<\/p>\n
# nano \/etc\/mysql\/my.cnf<\/p>\n
<\/p>\n
[mysqld]<\/p>\n
bind-address=127.0.0.1<\/pre>\n<\/p>\n
<\/p>\n
Restart mysql<\/p>\n
systemctl restart mysqld<\/p>\n
<\/p>\n
<\/p>\n
================<\/p>\n
Install PHP<\/p>\n
<\/p>\n
pacman -S php php-apache libmcrypt libtool<\/pre>\n<\/p>\n
nano \/etc\/php\/php.ini<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
======================<\/p>\n
<\/p>\n
nano \/etc\/locale.gen<\/p>\n
enable:<\/p>\n
en_US.UTF-8 UTF-8
\n\ten_US ISO-8859-1<\/p>\n<\/p>\n
save and generate your locales<\/p>\n
# locale-gen<\/p>\n
<\/p>\n
<\/p>\n
Install and Configure PostgreSQL<\/p>\n
pacman -S postgresql<\/p>\n
<\/p>\n
# mkdir -p \/var\/lib\/postgres\/data<\/p>\n
# chown httpd:httpd -Rv \/var\/lib\/postgres\/<\/p>\n
<\/p>\n
Configure Postgresql data dir<\/p>\n
# su – postgres -c "initdb –locale en_US.UTF-8 -D '\/var\/lib\/postgres\/data'"<\/p>\n
———————–<\/p>\n
The files belonging to this database system will be owned by user "httpd".
\n\tThis user must also own the server process.<\/p>\n\tThe database cluster will be initialized with locale "en_US.UTF-8".
\n\tThe default database encoding has accordingly been set to "UTF8".
\n\tThe default text search configuration will be set to "english".<\/p>\n\tfixing permissions on existing directory \/var\/lib\/postgres\/data … ok
\n\tcreating subdirectories … ok
\n\tselecting default max_connections … 100
\n\tselecting default shared_buffers … 24MB
\n\tcreating configuration files … ok
\n\tcreating template1 database in \/var\/lib\/postgres\/data\/base\/1 … ok
\n\tinitializing pg_authid … ok
\n\tinitializing dependencies … ok
\n\tcreating system views … ok
\n\tloading system objects' descriptions … ok
\n\tcreating collations … ok
\n\tcreating conversions … ok
\n\tcreating dictionaries … ok
\n\tsetting privileges on built-in objects … ok
\n\tcreating information schema … ok
\n\tloading PL\/pgSQL server-side language … ok
\n\tvacuuming database template1 … ok
\n\tcopying template1 to template0 … ok
\n\tcopying template1 to postgres … ok<\/p>\n\tWARNING: enabling "trust" authentication for local connections
\n\tYou can change this by editing pg_hba.conf or using the option -A, or
\n\t–auth-local and –auth-host, the next time you run initdb.<\/p>\n\tSuccess. You can now start the database server using:<\/p>\n
\t postgres -D \/var\/lib\/postgres\/data
\n\tor
\n\t pg_ctl -D \/var\/lib\/postgres\/data -l logfile start
\n\t <\/p>\n——————————————<\/p>\n
<\/p>\n
Enable the service<\/p>\n
# systemctl enable postgresql<\/p>\n
Start if you want to use it before rebooting<\/p>\n
# systemctl start postgresql<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Let's put the Raspberry Pi to good use: 1. Install Mysql sudo pacman -S mysql 2. Start your server # systemctl start mysqld 3. Secure your mysql installation # \/usr\/bin\/mysql_secure_installation ——————- NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE… Continue reading