On command line:
================

1.) USE database;
2.) DESCRIBE table;
2.) SELECT a,b,c from table;


In database 'mysql', table 'user' are the users stored.


Create user:
============

1.) CREATE USER 'username'@'HOST' IDENTIFIED BY 'password';
2.) GRANT ALL ON *.* TO 'username'@'HOST';   (evtl. noch mit WITH GRANT OPTION am Ende)


HOST kann dabei sein:
a) '%'
b) 'localhost'
c) 'other-hostname'


Set password:
=============

SET PASSWORD FOR 'user'@'HOST' = PASSWORD('new-password-here');