blog.helperchoi.com

GRANT ALL PRIVILEGES ON helperchoi_wiki.* TO helperchoi@localhost IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;

CREATE DATABASE DB명;GRANT ALL ON DB명.* TO 계정명@localhost IDENTIFIED BY '패스워드';GRANT ALL ON DB명.* TO 계정명@'%' IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;

use mysql;grant all privileges on *.* to 'root'@'%';flush privileges; update user set host = '%' where user = 'mysql'; grant all on test.* to 'mysql';select host, user, select_priv, update_priv, delete_priv from user;

※ MySQL 접속후 다음 쿼리 수행 use mysql;update user set password=password('패스워드') where user='root';flush privileges;select host, user, password from user;

※ Cloud Stack MySQL DB에서 간단히 조회 #SELECT vm_instance.id, vm_instance.name, user_vm.id, user_vm.display_name FROM vm_instance INNER JOIN user_vm WHERE vm_instance.id=user_vm.id AND user_vm.display_name="TB_LCMS" ;## UPDATE volumes set template_id='566' WHERE account_id=70 AND name='Windows_2008_32_DATA-1403';SELECT * FROM account where account_name="othuslp"; ### CS 계정의 Accound ID 알아 조회select * fr..

select @@servername + '\' + @@servicename;