MySQL create user with root privileges
To create a user with “root” privileges, you need to find what privileges root has, this can be done with the command…
Blog
Unable to detect ICU prefix
When compiling PHP, i get following error. checking whether to enable internationalization support… yes checking for icu-config… no checking for location of…
Datacenter
Here is some info for checking speed for various data centers. OVH Sydney, Australia Test IPv4 : 139.99.130.17 Test IPv6 : 2402:1f00:8100:211::1…
You must reset your password using ALTER USER
On MySQL 8, when you start MySQL, it generate a temporary root password, that you can find with command grep ‘temporary password’…
Install MySQL 8 on CentOS, RHEL 6/7
To Add MySQL yum repository to your server, go to https://dev.mysql.com/downloads/repo/yum/ Download the rpm file available. For RHEL/CentOS 7 wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm rpm…
Install MySQL 8 on Ubuntu/Debian
To install MySQL 8 on Ubuntu/Debian, download the .deb repository file from https://dev.mysql.com/downloads/repo/apt/ Following link may change, so always get newer version…
error: no acceptable C compiler found
When compiling software from source i get error configure: error: no acceptable C compiler found in $PATH To fix error, on CentOS,…
Dig
dig is a command line tool like nslookup used to check dns Find Reverse-DNS/PTR using dig, nslookup, host Requesting a zone trasnfer…
Magento 1.9 store login not working in Chrome
On a site running Magento 1.9, user login is not working on Google Chrome. The problem is due to cookie setting in…
MySQL Permission denied
After changing MySQL data directory, i get error Apr 17 03:01:20 hon-pc-01 mysqld[25298]: 180417 3:01:20 [Note] /usr/sbin/mysqld (mysqld 10.0.34-MariaDB-0ubuntu0.16.04.1) starting as process…
Installing PhpStorm on Ubuntu
Download latest version of PhpStorm from https://www.jetbrains.com/phpstorm/download/#section=linux You get a file with name like “PhpStorm-2018.1.1.tar.gz” Extract the file, put in a folder,…