MySQL for the Internet of Things

Chapter 6 ■ Building low-Cost MysQl data nodes

Next, let’s install MySQL with the sudo apt-get install mysql-server command as shown next.
Once you begin the MySQL installation, you may be prompted for setting the root user password for MySQL.
Be sure to choose a password you will remember.

pi@raspberrypi ~ $ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done

The following extra packages will be installed:

libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libterm-
readkey-perl mysql-client-5.5 mysql-common
mysql-server-5.5 mysql-server-core-5.5

Suggested packages:

libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libipc-sharedcache-perl
mailx tinyca

The following NEW packages will be installed:

libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libterm-
readkey-perl mysql-client-5.5 mysql-common
mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 11 newly installed, 0 to remove and 3 not upgraded.
Need to get 8,121 kB of archives.
After this operation, 88.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://mirrordirector.raspbian.org/raspbian/ jessie/main libaio1 armhf 0.3.110-1 [9,228 B]
Get:2 http://mirrordirector.raspbian.org/raspbian/ jessie/main mysql-common all
5.5.44-0+deb8u1 [74.3 kB]
Get:3 http://mirrordirector.raspbian.org/raspbian/ jessie/main libmysqlclient18 armhf
5.5.44-0+deb8u1 [616 kB]
...
Setting up libaio1:armhf (0.3.110-1) ...
Setting up libmysqlclient18:armhf (5.5.44-0+deb8u1) ...
Setting up libdbi-perl (1.631-3+b1) ...
Setting up libdbd-mysql-perl (4.028-2+b1) ...
Setting up libterm-readkey-perl (2.32-1+b2) ...
Setting up mysql-client-5.5 (5.5.44-0+deb8u1) ...
Setting up mysql-server-core-5.5 (5.5.44-0+deb8u1) ...
Setting up mysql-server-5.5 (5.5.44-0+deb8u1) ...
151001 12:58:57 [Warning] Using unique option prefix key_buffer instead of key_buffer_size
is deprecated and will be removed in a future release. Please use the full name instead.
151001 12:58:57 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb8u1) starting as process 18455 ...
Setting up libhtml-template-perl (2.95-1) ...
Setting up mysql-server (5.5.44-0+deb8u1) ...
Processing triggers for libc-bin (2.19-18+deb8u1) ...
Processing triggers for systemd (215-17+deb8u2) ...