Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Raspberry Pi Server Essentials

You're reading from   Raspberry Pi Server Essentials If you want to use Raspberry Pi as a server, this is the book that makes it all possible. Covering a wide range of projects – from network storage to a game server – you'll learn in easy, engaging steps.

Arrow left icon
Product type Paperback
Published in Feb 2014
Publisher
ISBN-13 9781783284696
Length 116 pages
Edition Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Piotr J Kula Piotr J Kula
Author Profile Icon Piotr J Kula
Piotr J Kula
Arrow right icon
View More author details
Toc

Installing a database


When we think of a database on a Linux machine, the first thing that often comes to our mind is MySQL. It is the first choice because it is free, open source, and reliable, and comes with a rich tool set. However, you have to remember that the Pi is not a server, and you might just want to use SQLite instead.

According to Wikipedia, as of July 2013, MySQL is the world's second most widely used open-source relational database management system.

Installing MySQL

The most popular tool to manage MySQL is phpMyAdmin. We will install these two and then test the installation. This can take up to 15 minutes.

sudo apt-get update
sudo apt-get install mysql-server

You will be presented with blue-background screens asking you for the root user password. You should write these down or store them in an application like KeePass.

The MySQL root user must never be used by web applications, especially production ones available on the Internet. The phpMyAdmin application needs to run with...

lock icon The rest of the chapter is locked
Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Raspberry Pi Server Essentials
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at ₹800/month. Cancel anytime
Modal Close icon
Modal Close icon