APM 설치 후 사용자 및 데이타베이스 추가
사용자 추가
데이타베이스와 mysql 계정 추가
사용자 추가 후 데이타베이스 재가동 및 접속 테스트
#adduser yembeng
#password yembeng
Changing password for user yembeng
New UNIX password:*****
Retype new UNIX password:*****
passwd: all authentication tokens updated successfully.
#
#password yembeng
Changing password for user yembeng
New UNIX password:*****
Retype new UNIX password:*****
passwd: all authentication tokens updated successfully.
#
데이타베이스와 mysql 계정 추가
#/usr/local/mysql/bin/mysql -uroot -p
Enter password:*****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27 to server version: 4.1.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>create database yembeng;
Query OK, 1 row affected (0.28 sec)
mysql>use mysql;
Database changed
mysql>insert into user (host,user,password) values('localhost','yembeng',password('****'));
Query OK, 1 row affected (0.01 sec)
mysql>insert into db values('%','yembeng','yembeng','y','y','y','y','y','y','y','y','y','y','y','y');
Query OK, 1 row affected (0.00 sec)
mysql>exit;
Enter password:*****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27 to server version: 4.1.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>create database yembeng;
Query OK, 1 row affected (0.28 sec)
mysql>use mysql;
Database changed
mysql>insert into user (host,user,password) values('localhost','yembeng',password('****'));
Query OK, 1 row affected (0.01 sec)
mysql>insert into db values('%','yembeng','yembeng','y','y','y','y','y','y','y','y','y','y','y','y');
Query OK, 1 row affected (0.00 sec)
mysql>exit;
사용자 추가 후 데이타베이스 재가동 및 접속 테스트
#/usr/local/mysql/bin/mysqladmin -uroot -p***** reload
#/usr/local/mysql/bin/mysql -uyembeng -p*****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.18
#/usr/local/mysql/bin/mysql -uyembeng -p*****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
http://www.joon.pe.kr/blog/trackback/192