dre3s/mysql.utils.md

Last active January 12, 2016 13:44

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dre3s/0b6fb11da05dd1f999d1.js"></script>
Save dre3s/0b6fb11da05dd1f999d1 to your computer and use it in GitHub Desktop.

mysql.utils

Raw

#Mysql Commands

###Accessing the mysql database

$ mysql -u root -p

###Creating and using the database

on console, mysql>

CREATE DATABASE meu_banco;
USE meu_banco;

###add user and password to access database

GRANT ALL PRIVILEGES ON database_name.* 
TO 'admin'@'localhost'
IDENTIFIED BY '123456';

Select an option