mysql console

mysql
mysql --user=user_name --password=your_password db_name
mysql -u your-user-name -p'Your-password' -h your-hostname

mysql> show databases;

mysql> use db_name;

mysql> show tables;

mysql> describe table_name;


Импорт:
mysql -uroot -ppicapica l2jdb < l2jdb.sql
/opt/lampp/bin/mysql -uexchangebook -pexchangebook.ru --default_character_set utf8 exchangebook < book.sql
"C:\Program Files (x86)\VertrigoServ\Mysql\bin\mysql" -uroot -pvertrigo --default_character_set utf8 aion < D:\aion7.sql

Cannot connect to MySQL 4.1+ using old authentication
mysql> SET @@session.old_passwords = 0;
mysql> SET PASSWORD FOR 'existinguser'@'localhost' = PASSWORD('existingpass');

Show users
select host, user, password from mysql.user;