Mysql 相关操作（续）

mysql> SET character_set_server = utf8;
mysql> SET character_set_server = utf8;
mysql> SET character_set_database = utf8;
alter table model convert to character set utf8;
alter database parameters character set utf8;
mysql> ALTER TABLE branch change fxtlb fxtlb char(16) not null;
sudo dnf install mysql57-community-release-fc22-7.noarch.rpm
sudo dnf install mysql-community-server mysql-community-devel
sudo systemctl enable mysqld.service
/home/plone/workspace/Plone5/sites/src/emc.kb/emc/kb/sql/init.sql
CREATE USER 'kbdba'@'localhost' IDENTIFIED BY '******';
create database parameters;
GRANT ALL ON parameters.* TO 'kbdba'@'localhost';
FLUSH PRIVILEGES;
mysql> source /home/plone/workspace/Plone5/sites/src/emc.kb/emc/kb/sql/testdata.sql;