LAMP Setup - mySQL CheatSheet

mySQLcheatsheet.txt

## Install mySQL -------------------------------
sudo mysql_secure_installation 

# Login to mySQL
sudo mysql –u root –p 

## Setup mySQL databases: -------------------------------

# Create Database for wordpress 
CREATE DATABASE databaseName;  

# View list of databases 
show databases; 

# Set active database/ Switch database 
USE databaseName; 

# Delete a database 
DROP DATABASE databaseName; 

## Setup mySQL user: -------------------------------

# See all users 
select host, user from mysql.user;  

# Create a user 
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'set_password'; 

## Grant user privileges: -------------------------------

#  grant new user all privileges 
GRANT ALL PRIVILEGES ON databaseName.tableName TO 'newuser'@localhost IDENTIFIED BY 'set_password';  

# refresh the database 
FLUSH PRIVILEGES; 

# exit mySQL
exit