mysql

 

DB설치후 root 패스워드 변경 

 

# mysqladmin -u 계정 -p password '비밀번호'
# mysqladmin -u root -p password openstack

 

# mysql -u - root -p

# mysql root 패스워드가 openstack 인 경우 
# mysql -u -root -p 
# mysql -u root -popenstack

 

 

mysql> status
--> Conn. characterset: utf8mb4

# /etc/mysql/mysql.conf.d/mysql.cnf
# /etc/mysql/mysql.conf.d/mysqld.cnf

 

형식변경

 

(변경) NEUTRON 

CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'neutrondbpass';
CREATE USER 'neutron'@'%' IDENTIFIED BY 'neutrondbpass';
GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';​

(변경) keystone  

CREATE USER 'keystone'@'localhost' IDENTIFIED BY 'keystonedbpass';
CREATE USER 'keystone'@'%' IDENTIFIED BY 'keystonedbpass';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%';​

 

# show variables like 'char%';

 

# 자주쓰는 명령어

$ mysql > status
$ mysql > use keystone;