Форум пользователей MySQL

Создаём пользователя и базу.

# mysql --default-character-set=cp1251 -u root -p

use mysql;
INSERT INTO user (Host, User, Password)
  VALUES ('localhost','abills', password('sqlpassword'));

INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv,
  Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv,
  Lock_tables_priv, Create_tmp_table_priv, Create_view_priv,
  Show_view_priv, Execute_priv, Event_priv, Trigger_priv)
VALUES ('localhost', 'abills', 'abills', 'Y', 'Y', 'Y', 'Y', 'Y',
  'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

CREATE DATABASE abills;
flush privileges;

Загружаем таблицы в базу.

# mysql --default-character-set=cp1251 -D abills < abills.sql

$ su
Password:
my# mysql --default-character-set=cp1251 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.4.2-beta FreeBSD port: mysql-server-5.4.2

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
INSERT INTO user (Host, User, Password)
  VALUES ('localhost','abills', password('sqlpassword'));

INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv,
  Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv,
  Lock_tables_priv, Create_tmp_table_priv, Create_view_priv,
  Show_view_priv, Execute_priv, Event_priv, Trigger_priv)
VALUES ('localhost', 'abills', 'abills', 'Y', 'Y', 'Y', 'Y', 'Y',
  'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

CREATE DATABASE abills;
flush privileges;Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> INSERT INTO user (Host, User, Password)
    ->   VALUES ('localhost','abills', password('sqlpassword'));
Query OK, 1 row affected, 3 warnings (0.01 sec)
my# mysql --default-character-set=cp1251 -D abills < abills.sql
<strong>abills.sql: No such file or directory.</strong>