Overview At any time if you lose your MySQL password, it must be reset within the control panel. This can be done via Databases > MySQL Manager > List Users and Databases. Under Edit Users, select the username that you logged into the control panel with, usually the first user listed….
Overview MySQL, despite its ease of use and popularity has a dark side of instability and crashes. Communities have forked MySQL, now an Oracle subsidiary (that was once a Sun subsidiary…), spawning alternatives like Percona, Drizzle, and MariaDB to improve quality and keep MySQL a viable database server. Newer servers (platform version…
Overview By default, MySQL permissions only permit same-server access for clients. This protects your database by preventing external access, but also precludes desktop database utilities like Navicat, MySQL Workbench, and Eclipse from managing your database schema. Solution Create a new MySQL user within the control panel under Databases > MySQL Manager….
Overview Additional MySQL databases, used for storing application data, may be created quickly within the control panel via Databases > MySQL Manager. When a database is created, grants are automatically setup to permit the primary user access to the database. In multi-user environments, you may wish to create a separate user…
Every file is made up of a permission set. These permissions consists of 3 sets of 3 bits for a total of 27 configurations. Just kidding! It’s not that complex! -r–r–r– root root 1972 Oct 13 23:14 test.mail -rw-r–r– admin admin 4345 Aug 29 12:33 test.php -rwxr-xr-x nobody admin …
Overview An .htaccess file contains directives that the web server will apply to a collection of resources before a page is displayed. For example, a .htaccess file may change PHP configuration, deny access, change the page displayed, and even redirect a resource to another URL. These are denoted by a directive. A…
Overview Redis is an advanced key-value cache and store, similar to memcached with better performance. It is available on newer platforms (v6+) without any additional compilation from source. Accounts with terminal access are eligible to use Redis. Quickstart From the terminal, run: redis-server –bind 127.0.0.1 –port PORT where PORT is…
Overview Node.js is a performant JavaScript backend built off Chrome’s JavaScript engine (v8). It’s also wicked fast. Node.js and its accompanying package management, npm, are available without any additional compilation from source. Accounts with terminal access are eligible to use Node.js and npm. Running Node.js with Passenger Our hosting servers…
Overview Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering. It is available on newer platforms (v6+) without any additional compilation from source. Accounts with terminal access are eligible to use Memcached. Quickstart From the terminal, run: memcached…
Overview Express is a Node.js framework inspired by Sinatra for Ruby: it’s based on minimalism with a penchant for performance. Express is part of the MEAN fullstack: MongoDB, Express, Angular.js, and Node.js. MongoDB may be setup in a separate guide. Express is supported on all v6+ platforms using Passenger to manage isolated processes. Quickstart All steps…