download zip version:
unpack
inside bin folder execute the command line: mysqld --no-defaults or mysqld --console
open another cmd/bash window and type:
mysql -u root -p
enter a blank password on the first time.
now, create a new user:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
if you want to change the password:
SET PASSWORD FOR 'jeffrey'@'localhost' = PASSWORD('cleartext password');
grant admin privileges:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
create a database:
CREATE DATABASE <<databasename>>;
list the databases:
show databases;
use a database:
use <<databasename>>;
create a table:
CREATE TABLE name (column1 VARCHAR(20), column2 VARCHAR(30), column3 CHAR(1), column4 DATE);