PHP-logo

Install PHP Version (7.3, 7.2 or 7.0) on Ubuntu 19.04, 18.04 & 16.04 via PPA

Thanks to Ondřej Surý for maintaining PPA of most the popular PHP versions on launchpad. PHP 7.3 is the current & stable version of PHP. You can check the PHP Release History. PHP 7.3 has support till 6 December 2020. If you want to install the specific version of PHP, then this article can be helpful for you. In this article we will help you in installing PHP 7.3, 7.2 or 7.0 using PPA on Ubuntu 19.04 18.10 LTS, 18.04 LTS, 16.04 LTS, 14.04 LTS or 12.04 LTS systems. Install PHP 7.3 on Ubuntu 19.04, 18.04 & 16.04 PHP 7.3 is the current & stable version of PHP. Use the following set of commands that is installing software-properties-common and then …

Read More

How to Fix MySQL Error – #1089 – Incorrect prefix key or the storage engine doesn’t support unique prefix keys

Today in this article we will discuss one of the most common errors of MySQL that you may face while creating tables or importing the DataBase to the new server and that is #1089 – Incorrect prefix key; the used key part isn’t a string, the used length is longer than the key part, or the storage engine doesn’t support unique prefix keys.  This occurs due to the syntax error in Create query of Database Table. If you run the below query, you may face the above error and the query will stop working and will not create a Database Table.

And, If you run the below query, you will not face any error and query will work and create …

Read More
MySQL

Reset or Change MySQL root user Password on Ubuntu Linux

Today, in this article we will discuss How you can change / Reset / Set / Update MySQL root user’s password on Ubuntu Linux Server. Sometimes while playing with root user’s privileges to allow its access remotely may change its password. Or if you have forgotten the root user’s password. Then you can not access the MySQL DB without the password. In that case, you need to change/reset it’s MySQL password. Please follow these steps to reset/change the MySQL root user password. Stop The MySQL Server

Start The MySQLd Configuration And Skip The Grant Table This will start a new MySQL Server with no-password and it will ignore the Grant table rules. Now, This Temporary MySQL Server will have full control. …

Read More