2013.03.14 04:18
mysql 사용자 추가 명령 모음
조회 수 3023 추천 수 0 댓글 0
mysqldump -u user -p user_db > /home/hosting_users/user/xxxxx.dump
mysqladmin -u root password '******'
update user set password=password('******') where user='root';
update user set password=password('******') where user='******';
create database ******_db
INSERT INTO mysql.user(User, Host, Password, ssl_cipher, x509_issuer,x509_subject) VALUES('******', 'localhost', Password('******'), '', '', '');
insert into db values('localhost','******_db','******','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
flush privileges;
사용자 삭제
DELETE FROM user where user='******';
DELETE FROM user where user='******';