Installing LAMP On Linux Mint

Installing LAMP (Linux, Apache, MySQL and PHP) On Linux Mint.  LAMP stands for Linux, Apache, MySQL, PHP. How to install Linux the L of LAMP. Install Apache To start off we will install Apache. 1) Open up the Terminal (Applications > Accessories > Terminal) 2) Copy/Paste the following line of code into Terminal and then […]

See More

Grant remote access of MySQL database

Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]

See More

Databases showing 0MB in cPanel

Databases showing 0MB in cPanel  From command line 1. Run the command. # /usr/local/cpanel/bin/setupdbmap 2. Edit cPanel configuration file. disk_usage_include_sqldbs=1 ( you need to set it to ‘1’ if ‘0’ ) in file /var/cpanel/cpanel.config 3. Run the following script. #/scripts/update_db_cache You can also enable this from the WHM control panel. WHM >> Server Configuration >> […]

See More