#/usr/local/mysql/bin/mysql -uroot -p

• show databases; show available databases
• \u DATABASE change to a database
• show tables; show tables
• describe TABLE; show details of a table

#/usr/local/mysql/bin/mysqladmin create DATENBANK -uroot -p
#/usr/local/mysql/bin/mysql -uroot -p
mysql>\u mysql
mysql>insert into user (Host,User,Password) values ('localhost','USERNAME',password('PASSWORD'));
mysql>insert into db (Host,Db,User,Select_priv) values ('%','DATENBANK','USERNAME','Y');
mysql>update db set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y' where User='USERNAME';
mysql>\q
#/usr/local/mysql/bin/mysqladmin reload -uroot -p