debian, lenny, amd64, mysql

---

Installing MySql Server and Client:

#apt-get install mysql-server

---

#netstat -tap |grep mysql

---

#mysqladmin -u root password xxxx

---

#mysql -u root -p
password:xxxx
mysql>quit

---

Creating a Database and User

MySql Information Schema
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html

#mysql -u root -p
password:xxxx
mysql>create database mvcdb;
mysql>grant all privileges on mvcdb.* to 'mvcuser'@'%' identified by 'mvcuser';
mysql>use mysql;
mysql>show tables;
mysql>select host, user, password from user where user like 'mvcuser%';
mysql>use information_schema;
mysql>show tables;
mysql>select * from user_privileges where grantee like "'mvcuser%'";

---

$mysql -u mvcuser, runs well
but i want
$mysql -u mvcuser -p, and this is not running well
now reading..

---