понедельник, 30 сентября 2013 г.

Quick tip: Create MySQL database, add user and access rights

Quick tip: Create MySQL database, add user and access rights
 
  CREATE DATABASE `mydb` CHARSET utf8 COLLATE utf8_general_ci;
  GRANT USAGE ON *.* TO 'webapp'@'localhost' IDENTIFIED BY 'SecretP@ssw0rd';
  GRANT ALL PRIVILEGES ON `mydb`.* TO 'webapp'@'localhost';
  flush privileges;
  SHOW GRANTS FOR webapp@localhost;

вторник, 24 сентября 2013 г.

Install Java7 on Ubuntu 12.04 LTS

Install Java7 on Ubuntu 12.04 LTS.

Just console commands:

  sudo aptitude install python-software-properties

  sudo apt-add-repository ppa:webupd8team/java

  sudo apt-get update

  sudo apt-get install oracle-java7-installer
See more: http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html

понедельник, 9 сентября 2013 г.

четверг, 5 сентября 2013 г.

nginx files

Nginx files are as following:
  • /etc/nginx/nginx.conf - main config file for nginx
  • /etc/nginx/conf.d/*.conf - additional config files for nginx
  • /etc/nginx/sites-enabled/* - additional config files for virtual hosts, one file per virtual host
More info see at StackOverflow - Configure /etc/nginx/nginx.conf to redirect to separate host