RPi MySQL - Revision history

Ghans at 18:56, 18 June 2012

2012-06-18T18:56:01Z

GG Crew: /* Testing Your Installation */

2012-05-29T14:37:29Z

‎Testing Your Installation

GG Crew: /* Testing Your Installation */

2012-05-29T14:24:37Z

‎Testing Your Installation

GG Crew: Created page with "== Installing MySQL on Raspberry Pi == This is a guide to install [http://www.mysql.com/ MySQL Community Edition] (aka "MySQL") on the Raspberry Pi computer running Debian "squee..."

2012-05-22T07:42:13Z

Created page with "== Installing MySQL on Raspberry Pi == This is a guide to install [http://www.mysql.com/ MySQL Community Edition] (aka "MySQL") on the Raspberry Pi computer running Debian "squee..."

New page

== Installing MySQL on Raspberry Pi ==
This is a guide to install [http://www.mysql.com/ MySQL Community Edition] (aka "MySQL") on the Raspberry Pi computer running Debian "squeeze".

MySQL is comprised of two distinct components:
* MySQL Server
** The program that actually stores and processes the data.<br />There is generally no way to interact with the data stored in the database server without using an external client or library.
* MySQL Client
** A program or library that connects to an existing MySQL database server.<br />This is considered a "front end" to the database - a way for the user to send and retrieve data from the database server.

The guide has been developed/tested using debian6-19-04-2012. Depending on how you choose to install Ruby, there may not be enough room on a standard 2Gb image. This is especially true if you've already installed anything else. Learn how to expand your image [[RPi_Easy_SD_Card_Setup | here]] or [http://www.youtube.com/watch?v=DztSRaFyaVE here].

== Installing MySQL Server From The Debian Repository ==

=== Commands ===
# Install MySQL Server from the Debian repository
sudo apt-get install mysql-server
The package manager may suggest a slew of dependencies for MySQL Server. Press "Y" then "enter" (or just "enter") to continue installation.
The MySQL installation process will prompt for a password for the MySQL root user account. You can enter a password, or press "enter" to skip the password step - it is your choice. It is poor security to have a blank password if you will be running the MySQL Server on a shared network, but shouldn't matter if you are only using the system for development.
The installation process will prompt you two additional times for a MySQL root password. Continue entering the same password (or skipping it) as you did at the first prompt.
The MySQL Client is installed as part of the standard MySQL Server package from the Debian repository. You do not need to install additional software to start using MySQL.

=== Testing Your Installation ===
# Verify the MySQL Client was installed
mysql --version

# Connect to the MySQL Server on localhost
mysql --user=root --password='''password'''

== Installing MySQL Client From The Debian Repository ==
The MySQL Client is a "front end" to an existing database; it does not install the MySQL Server.
The MySQL Client can be used to connect to MySQL Server databases across a network. It provides a text-based interface to a MySQL Server, and requires a basic understanding of standard SQL commands. (ie SELECT, UPDATE, INSERT, and DELETE).
=== Commands ===
# Install MySQL Client from the Debian repository
sudo apt-get install mysql-client
The package manager may suggest a slew of dependencies for MySQL Client. Press "Y" then "enter" (or just "enter") to continue installation.

=== Testing Your Installation ===

← Older revision		Revision as of 18:56, 18 June 2012
Line 1:		Line 1:
		+	[[Category:RaspberryPi]]
	== Installing MySQL on Raspberry Pi ==		== Installing MySQL on Raspberry Pi ==
	This is a guide to install [http://www.mysql.com/ MySQL Community Edition] (aka "MySQL") on the Raspberry Pi computer running Debian "squeeze".		This is a guide to install [http://www.mysql.com/ MySQL Community Edition] (aka "MySQL") on the Raspberry Pi computer running Debian "squeeze".

← Older revision		Revision as of 14:37, 29 May 2012
Line 36:		Line 36:

	=== Testing Your Installation ===		=== Testing Your Installation ===
		+	The following instructions make these assumptions:
		+	* You have an existing MySQL Server, whether on localhost or elsewhere across the network
		+	* The existing MySQL Server "listens for" (accepts) network connections (disabled on a default installation of MySQL Server)
		+	* The MySQL Server has either:
		+	** Allowed "root" login over a network connection (disabled on a default installation of MySQL Server), or
		+	** A MySQL user account for you
		+	=== Testing Your Installation ===
		+	# Verify the MySQL Client was installed
		+	mysql --version
		+
		+	# Connect to a remote MySQL Server (assumes the server allows root access from a remote computer)
		+	mysql --host=''server_address'' --user=root --password=''password''
		+
		+	# Connect to a remote MySQL Server (assumes the server has already created your user account)
		+	mysql --host=''server_address'' --user=''user_name'' --password=''password''

@@ Line 25: / Line 25: @@
   # Connect to the MySQL Server on localhost
-  mysql --user=root --password='''password'''
+  mysql --user=root --password=''password''
 == Installing MySQL Client From The Debian Repository ==