Difference between revisions of "Nn web site building blocks"

Revision as of 15:03, 8 January 2018

The following tools and web and programming frameworks are all part of Ted's volunteer efforts with ASI web site, and in-progress study of how to configure and customize shopping carts, article and document management pages, and easy-to-read easy-to-adjust web page layouts using CSS and third party, open source frameworks:

• Linux package selection for constrained systems
  

^ MYSQL database server and client

• MYSQL data base install and config (set up)
  
  • MYSQL query syntax and examples
  • MYSQL show variables, show status
  • MYSQL command-line tool, also called MYSQL shell
  • MYSQL shell user guide
  • string quoting in MYSQL, multiple ways of quoting
  • mysqldump of database information_schema requires --skip-lock-tables option
  • MYSQL database back-ups and cron
  • https://dev.mysql.com/doc/refman/5.7/en/create-user.html
  • https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
  - 2017-11-30 -
  • recover, reset mysql root password
  • MYSQL 5.7.3 - MYSQL 5.7.9 bug present during --skip-grant-tables server invocation, work arounds

An important MYSQL database access recovery step is to reset the database server's root password in cases where that is lost. The following statement run in a mysqld_safe --skip-grant-tables session works, while some of the more standard and MYSQL 5.7 documented password change statements fail due to a bug in MYSQL . . .

  mysql> update mysql.user set authentication_string=password('MyNewPass') where user='root';

• PHP set up
  

^ Apache2 web server configuration

• https://wiki.apache.org/httpd/RedirectSSL redirect http to https URLs