MySQL

Install MySQL on Ubuntu 14.04

Published about 7 years ago
Topic: MySQL

Getting Started

Let's check our hostname

hostname
hostname -f

The first command shows short hostname, and the second shows your fully qualified domain name (FQDN).

Next, let's make sure we have the most current packages.

sudo apt-get update
sudo apt-get upgrade

Installing MySQL

sudo apt-get install mysql-server mysql-client libmysqlclient-dev

Make sure to chose a secure MySQL root user password when prompted. MySQL...

Create Users and Grant Permissions in MySQL

Published about 7 years ago
Topic: MySQL

Creating a New User

Lets open the MySQL shell and create a new user.

mysql -u root -p
CREATE USER 'jimmy'@'localhost' IDENTIFIED BY 'password123';

When we first create a user, it will have no permissions, which means it can even login to the MySQL shell, so we need to give it the needed permissions.

GRANT ALL PRIVILEGES ON * . * TO 'jimmy'@'localhost';

The first asterisk in this command refers to the database, in this case we are givin...