Skip to content

Latest commit

 

History

History
39 lines (34 loc) · 916 Bytes

mysql.md

File metadata and controls

39 lines (34 loc) · 916 Bytes

Install

  1. Download generic Linux tarball, untar, define MYSQL_HOME, update PATH.
  2. Run
$ mysqld --initialize --basedir=$MYSQL_HOME --datadir=$MYSQL_HOME/data

Starting

$ mysqld_safe --basedir=$MYSQL_HOME --datadir=$MYSQL_HOME/data

Stopping

Useful Commands

  1. Change root password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
  1. Create database and grant privileges
mysql> CREATE DATABASE dbname;
  1. Create new user
mysql> CREATE USER 'finley'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON dbname.* TO 'finley'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'finley'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON dbname.* TO 'finley'@'%' WITH GRANT OPTION;
  1. Show user info
SELECT User, Host, authentication_string FROM mysql.user;
SHOW GRANTS FOR finley@localhost;