zmej.org.ua - Памятки системного администратора.

Инструкция по заведение базы и пользователя в БД MySQL

13:00 testuser@host [/etc]#mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2322

Server version: 5.0.88-log FreeBSD port: mysql-server-5.0.88

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

mysql>

mysql> create database testdb;

Query OK, 1 row affected (0.05 sec)

mysql> GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Query OK, 0 rows affected (0.16 sec)