MYSQL DB Commands

MYSQL:

User Creation:

GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';

OR

mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;


* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h -P -u -p version variables extended-status ( To check for Mysql Configuration)
[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid