PIKE

PIKE常见问题以及细节

Posted by xionghongzhi on May 4, 2018

  1. jetty 指定端口运行

    mvn jetty:run -Djetty.port = 8888

  2. 创建PIKE用户和数据库

    mysql> create user ‘pike’@’localhost’ identified by ‘pike’;

    mysql> create database PIKE DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

  3. 用户赋权

    mysql> grant all privileges on PIKE.* to ‘pike’@’localhost’;

    mysql> flush privileges;

Ubuntu的mysql配置文件位置: sudo vi /etc/mysql/my.cnf

安装：sudo apt-get install MySQL-server mysql-client

查看安装端口情况：sudo netstat -tap grep mysql

打开关闭服务：/etc/init.d/mysql start/stop

查看MySQL的默认字符集: sudo vi /etc/mysql/my.cnf, 更改配置 default-character-set=utf8