Abstract
MySQL is the most trusted and depended-on open source database platform in use today. As such, 9 out of the top 10 most popular and highly trafficked websites in the world rely on MySQL primarily due to its ubiquity across heterogeneous platforms and application stacks and for its well-known performance, reliability and ease of use. This blog entry will guide you through the step-by-step installation ofMySQL 5.5onUbuntu Linux 12.04 LTS 32 bit. This installation is performed on a clean installation of Ubuntu Server 12.04 32 bit.
Step 1: Open your Terminal
Press the following keyboard shortcut:
1
|
Ctrl + Alt + T
|
Step 2: Update your package cache
Run the following command in your terminal:
1
|
sudo
apt-get update
|
Step 3: Install the mysql-server-5.5 package
Run the following command in your terminal:
1
|
sudo
apt-get
install
mysql-server-5.5
|
Step 4: Create a new MySQL database
Run the following commands in your terminal, replacingnewdatabase
,newuser
andnewpassword
:
1
2
3
4
|
mysql -u root -p
CREATE DATABASE newdatabase;
GRANT ALL PRIVILEGES ON newdatabase.* TO newuser@localhost IDENTIFIED BY
'newpassword'
;
Press CTRL + D
|
Step 5: Check whether MySQL is running
Run the following command in your terminal:
1
|
sudo
netstat
-tap |
grep
mysql
|
You should see the following line or something similar:
1
|
tcp 0 0 localhost:mysql *:* LISTEN 2810
/mysqld
|