racl101 + root   36

How to get HTTPS working on your local development environment in 5 minutes
This still works as of October 2018. Followed a Homstead Vagrant Bash shell script implementation of this found in a file called: /scripts/create-certificate.sh

The thing that makes all the difference is creating the root certificate and then creating the specific site certificate from the root script.
blog  tutorial  freecodecamp  howto  create  ssl  certificate  self  signed  site  root  google  chrome  https  development  environment  example  guide  reference  security 
october 2018 by racl101
Installing MySQL (with Debconf) | Servers for Hackers

echo mysql-server mysql-server/root_password password root | debconf-set-selections;\
echo mysql-server mysql-server/root_password_again password root | debconf-set-selections;\
apt-get install -y mysql-server mysql-client libmysqlclient-dev

So that you don't have install mysql server interactively and can set the root password programmatically.

Works for installing MySQL 5.7 on Ubuntu 16.04 as well.
blog  tutorial  screencast  video  howto  install  mysql  mysql5.7  server  debian  configuration  root  password  programmatically  ubuntu  ubuntu16.04  script  bash  shell  example  guide  reference 
october 2018 by racl101
Ansible Install MySql 5.7 - Set Root User Password - Stack Overflow
This response explains a nuance for MySQL 5.7 whereby you can't log in as a root user with no password.

To change the password for a root user for the first time you have to do something like this:

- name: Check if '~/.my.cnf' exists
path: ~/.my.cnf
register: my_cnf_check

- name: Update MySQL root password for all root accounts
name: root
host: "{{ item }}"
password: "{{ mysql_root_password }}"
state: present
check_implicit_admin: "{{ 'no' if my_cnf_check.stat.exists == True else 'yes' }}"
- ::1
- localhost
become: "{{ 'no' if my_cnf_check.stat.exists == True else 'yes' }}"
become_method: sudo

- name: Create MySQL '~/.my.cnf' config file and add root credentials into it
template: src=templates/mysql_my.cnf.j2 dest=~/.my.cnf mode=0600
stackoverflow  ansible  mysql  mysql5.7  howto  example  guide  reference  update  root  user  password  my.cnf  sudo  admin 
july 2018 by racl101
Error during install , "python mysqldb module is required" · Issue #42 · geerlingguy/ansible-role-mysql
If using python3 as the Ansible Python Interpreter then you'll need to install both:

- python3-pip
- python3-mysqldb

to be able to update mysql user passwords with Ansible.
github  forum  mysql  module  howto  fix  troubleshoot  python  python3  ansible  update  root  password  user  example  guide  reference  pip 
july 2018 by racl101
apache - mod_rewrite: how to redirect everything except 2 files to "/"? - Stack Overflow
Shows how to add directives to .htaccess to redirect to any URIs hitting the website that aren't either the webroot or one or more certain URIs.
rewrite  mod_rewrite  redirect  Apache  Howto  Stackoverflow  example  root  Web  MOD 
november 2015 by racl101
How to enable ssh root access on Ubuntu 14.04 - Ask Ubuntu
This happened with our Webbynode server where we just couldn't log via traditional: ssh -p <portnumber> username@host (i.e. without using a public RSA key on the only machine that had set it up). So it turns out that Root Login capability was disabled so I enabled it by following these exact steps.
Linux  root  ubuntu  example  Guide  Howto  Ssh  stackexchange  login  config  ReferencE  ACCESS  Shell 
january 2015 by racl101

related tags

accept  ACCESS  ACess  Add  adduser  admin  amazon  android  anonymous  ansible  Apache  apple  apply  askubuntu  aws  bash  become  blog  certificate  change  chrome  conf  config  configuration  connection  copy  create  credentials  database  date  dba.stackexchange  deb  debconf  debian  delete  development  device  digital  directory  Document  documentation  ec2  environment  error  example  explanation  files  fix  forum  freecodecamp  FTP  g1  git  github  google  gotcha  Group  guide  handle  hard  homestead  howto  howtoforge  https  iam  index.html  install  instance  keychain  Laracasts  LAravel  limit  limits.conf  links  linux  localhost  log  login  macos  macosx  MAke  manager  MOD  module  mod_rewrite  Moz  my.cnf  mysql  mysql5.7  mysqladmin  ocean  official  open  package  pam.d  password  path  pathname  permission  phone  phpmyadmin  pip  playbook  programmatically  python  python3  rails  redirect  reference  relative  remove  reset  rewrite  root  root-relative  ror  ruby  ruby-on-rails  screencast  script  security  self  server  set  settings  shell  sierra  signed  site  soft  sql  Ssh  ssl  stackexchange  stackoverflow  su  sudo  support  sysadmin  test  theme-development  time  timezone  tolearn  toread  totry  tounderstand  troubleshoot  tutorial  ubuntu  ubuntu16.04  ulimit  unix  update  user  users  video  virtualhost  volume  Web  webroot  wiki  Wikihow  wordpress  writeable  zone 

Copy this bookmark: