【160124】服务器管理记录

• Ubuntu 解决语言设置错误的问题，并正常输入输出中文
  安装localepurge管理语言文件

  sudo apt-get install localepurge

  当然也可以使用以下命令再次进行配置：

  sudo dpkg-reconfigure localepurg

  在本地对fish-shell进行配置：

  set -U LANG en_US.UTF-8
  set -U LC_ALL en_US.UTF-8

• Apache: Set Up Mod_Rewrite

  sudo a2enmod rewrite

• MySQL user management

  • enter interactive mode

    mysql -u [username] -h [hostname] -p

  • show all users

    select * {host,user,…} from mysql.user

  • add a user

    create user [username]@[hostname] identified by ‘[password]’

  • delete a user

    drop user [username]@[hostname]

  • give privileges (users not existed will be created)

    grant {all privileges,select,usage,…} on *.* to [username]@[hostname] identified ‘[password]’

  • retrieve privileges

    revoke {all privileges,select,usage,…} on *.* from [username]@[hostname] identified ‘[password]’

  • show privileges

    show grants for [username]@[hostname];

  All sorts of privileges