MySql install

Suppossed you have downloaded and install all the packages:

mysql_install_db

MySql start

mysqld_safe --user=root&

MySql changing password

/usr/bin/mysqladmin -u root password 'new-password'

mysql_install_db

MySql login

mysql -u root -p

MySql show all databases

show databases;

MySql create a database

create database foobar;

MySql import a database

mysql -p -h DBSERVER dbname < dbname.sql

where option -h is the server 

mysqldump -p database [tables] > database.sql

where option -h is the server 

Restarting MySql

mysqladmin -u root -p shutdown
mysqld_safe --user=root&

Deleteing a database

drop database foobar;

ISO-8859-1 to utf-8 conversion

mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset dbname > dump.sql
chgrep latin1 utf8 dump.sql 
mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql

sed -i "" 's/latin1/utf8/g' dump.sql