• Database import fails: CREATE DATABASE line

    Overview Restoring a database backup within the control panel, mysqli CLI, or phpMyAdmin may fail with the following message: #1044 – Access denied for user ‘myuser’@’localhost’ to database ‘mynewdb’ Cause A CREATE DATABASE query is issued during database import that cannot succeed due to limited permissions. All databases must be created…

  • Stored procedure creation fails

    Overview During a database import, a stored procedure may be included in the backup. Although the backup is complete, restoring it within phpMyAdmin, the control panel, or mysql CLI fails with a similar error: #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation Cause Included…

  • Resetting MySQL password

    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….

  • Connecting remotely to MySQL

    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….

  • Installing Express

    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…

  • Running MongoDB

    Overview MongoDB is fast, document-oriented NoSQL server. It’s complementary to key-value cache stores like Redis or Memcached and is suitable when necessary. It is available on newer platforms (v6+) without any additional compilation from source. Accounts with terminal access are eligible to use MongoDB. Quickstart From the terminal, first create a directory…

  • Running Redis

    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…

  • Welcome aboard: your next steps!

    Introduction First off, thank you personally for deciding to host with Lithium Hosting. Now that you have a spot to host your domain, there are some steps to take to attach your domain to your hosting. It’s painless, and takes between 10 and 15 minutes, depending if you are a…

  • .htaccess Guide

    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…

  • Permissions overview

    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 …