Month: October 2015
-
MySQL – Reminders
Get the list of users SELECT User FROM mysql.user; Add new user CREATE USER ‘user’@’host’ IDENTIFIED BY ‘password’; Create a database CREATE DATABASE databaseName CHARACTER SET utf8 COLLATE utf8_general_ci; * specify the character set and also the collation. Remember that stored procedure are created with the collation the database has and it will remain the…