LOVAPI

http://dev.mysql.com/doc/refman/4.1/en/connection-access.html

# mysql -u root -p
비밀번호 입력

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 52 to server version: 4.1.15

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
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> GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost' IDENTIFIED BY 'testpw' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY 'testpw' WITH GRANT OPTION;
mysql> 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

설명
text라는 유저를 만들고 localhost(루프백), 모든 접근을 허용한다,
비밀번호는 testpw, 모든데이터베이스와 테이블(*.*)에 모든 권한을 위임한다.

ps. 직접 user, host 테이블 값을 수정해도 된다.