Ethernet Cable or Wi-Fi<\/li>\n<\/ul>\n\n\n\nSetting up MYSQL on a Raspberry Pi<\/h3>\n\n\n\n
As with all of our tutorials, we will be utilizing the Raspbian operating system. If you\u2019re using something different, then the steps may differ slightly.<\/p>\n\n\n\n
1.<\/strong> Before we get started with installing MySQL to our Raspberry Pi, we must first update our package list and all installed packages.<\/p>\n\n\n\nWe can do this by running the following two commands.<\/p>\n\n\n\n
sudo apt update\nsudo apt upgrade<\/code><\/pre>\n\n\n\n2.<\/strong> The next step is to install the MySQL server software to your Raspberry Pi.<\/p>\n\n\n\nInstalling MySQL to the Raspberry Pi is a simple process and can be done with the following command.<\/p>\n\n\n\n
sudo apt install mariadb-server<\/code><\/pre>\n\n\n\n3.<\/strong> With the MySQL server software installed to the Raspberry Pi, we will now need to secure it by setting a password for the \u201croot<\/code>\u201d user.<\/p>\n\n\n\nBy default, MySQL is installed without any password set up meaning you can access the MySQL server without any authentication.<\/p>\n\n\n\n
Run the following command to begin the MySQL securing process.<\/p>\n\n\n\n
sudo mysql_secure_installation<\/code><\/pre>\n\n\n\nJust follow the prompts to set a password for the root user and to secure your MySQL installation.<\/p>\n\n\n\n
For a more secure installation, you should answer \u201cY<\/code>\u201d to all prompts when asked to answer \u201cY<\/code>\u201d or \u201cN<\/code>\u201c.<\/p>\n\n\n\nThese prompts will remove features that allows someone to gain access to the server easier.<\/p>\n\n\n\n
Make sure you write down the password you set during this process as we will need to use it to access the MySQL server and create databases and users for software such as WordPress or PHPMyAdmin.<\/p>\n\n\n\n
4.<\/strong> Now if you want to access your Raspberry Pi\u2019s MySQL server and start making changes to your databases, you can enter the following command.<\/p>\n\n\n\nsudo mysql -u root -p<\/code><\/pre>\n\n\n\n5.<\/strong> You will be prompted to enter the password that we just created in step 3<\/strong> for MySQL\u2019s root user.<\/p>\n\n\n\nNote:<\/strong> Like most Linux password inputs, the text will not show up as you type.<\/p>\n\n\n\n6.<\/strong> You can now enter MYSQL commands to create, alter, and delete databases. Through this interface, you can also create or delete users and assign them the rights to manage any database.<\/p>\n\n\n\n7.<\/strong> There are two different ways you can quit out of the MYSQL command line, the first of those is to type<\/kbd> \u201cquit;<\/code>\u201d into the MySQL interface.<\/p>\n\n\n\nThe other way of quitting out of the MYSQL command line is to press CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n8.<\/strong> At this point, you will now have successfully setup MySQL on your Raspberry Pi. Our next few sections will go into making better use of this database.<\/p>\n\n\n\nCreating a MySQL Database and User<\/h3>\n\n\n\n
1.<\/strong> Before we proceed to create a MySQL user and database on our Raspberry Pi, we must first log back into the MySQL command-line tool.<\/p>\n\n\n\nRun the following command to log in to the MySQL command line. You will be prompted to enter the password for the \u201croot<\/strong>\u201d account that you set up earlier.<\/p>\n\n\n\nsudo mysql -u root -p<\/code><\/pre>\n\n\n\n2.<\/strong> Let\u2019s start by creating a MySQL database using the following command.<\/p>\n\n\n\nThis command is super simple and is just \u201cCREATE DATABASE<\/code>\u201d followed by the name that you want to give the database.<\/p>\n\n\n\nIn our example, we will be calling this database \u201cexampledb<\/code>\u201c.<\/p>\n\n\n\nCREATE DATABASE exampledb;<\/code><\/pre>\n\n\n\n3.<\/strong> Next, we will create a MySQL user that we will assign to our new database. We can create this user by running the following command.<\/p>\n\n\n\nFor this example, we will be calling the user \u201cexampleuser<\/code>\u201d and giving it the password \u201cpimylifeup<\/code>\u201c. When creating your own, make sure you replace both of these.<\/p>\n\n\n\nCREATE USER 'exampleuser'@'localhost' IDENTIFIED BY 'pimylifeup';<\/code><\/pre>\n\n\n\n4.<\/strong> With the user created, we can now go ahead and grant all privileges to the user so that it can interact with the database.<\/p>\n\n\n\nThis command will grant all permissions to our \u201cexampleuser<\/code>\u201d for all tables within our \u201cexampledb<\/code>\u201d database.<\/p>\n\n\n\nGRANT ALL PRIVILEGES ON exampledb.* TO 'exampleuser'@'localhost';<\/code><\/pre>\n\n\n\n5.<\/strong> The final thing we need to do for both our MySQL database and user to be finalized is to flush the privilege table. Without flushing the privilege table, the new user won\u2019t be able to access the database.<\/p>\n\n\n\nWe can do this by running the following command.<\/p>\n\n\n\n
FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\nIf you rather not use the command line to administrate your databases then you can always\u00a0install PHPMyAdmin instead.<\/p>\n\n\n\n
Installing the PHP MySQL Connector<\/h3>\n\n\n\n
1.<\/strong> If you intend on using a MySQL database from PHP, you will need to make sure that you have the module installed.<\/p>\n\n\n\nYou can install the MySQL connector for PHP to your Raspberry Pi by running the following command.<\/p>\n\n\n\n
sudo apt install php-mysql<\/code><\/pre>\n\n\n\nAs I mentioned earlier, there are\u00a0many projects\u00a0where a database will come in handy. Most modern websites will require a database to be able to function correctly.<\/p>\n\n\n\n
At this point of the tutorial you should now have a MySQL server up and running on your Raspberry Pi. If you have ran into any issues feel free to drop a comment in the comments section below.<\/p>\n\n\n\n
I need to thanks<\/em>\u00a0Little Big Byte<\/a>, a small business located in Hobart, Tasmania, Australia for giving this great tutorial. It really works!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"In this Raspberry Pi MYSQL tutorial, we will be showing you how to install and configure the MySQL server on your Pi. MySQL is one of the world\u2019s most popular relational database system and is a common inclusion in most LAMP ( Linux, Apache, MYSQL, and PHP) stacks. It is one of the pieces of technology that […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-103","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":6,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/103\/revisions"}],"predecessor-version":[{"id":130,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/103\/revisions\/130"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}