MySQL error occurs after upgrading PHP/MySQL web app

8-8-2019 5:47:53 PM


You upgrade a PHP/MySQL web app and you get the following error:

We are sorry, we not able to connect right now. Please try again later: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file


If the web app was installed when the server was running PHP 5.2 or earlier, or the web app was transferred from one CPanel/WHM server to another using the automatic transfer tool, the database user credintials were applied using the old 4.1 format.


You can use SSH, then log into the MySQL console run the password update as described in the error message.  As an alternative, you may also use the CPanel interface to delete, rescreate and re-apply the user to the database.

Ed Lemmers

Purchasing a Laptop - What Processor is Best?

8-8-2019 5:26:14 PM

As many savvy computers have become aware of, Intel markets their laptop processors under three different labels: Core i3, Core i5 and Core i7 which relate to different price range levers: economy, standard and premium.  In Intel's desktop line, these model series relate directly to performance in terms of computing power.  This is not necessarily true with laptops.  Another consideration for laptop performance is battery life.  As it turns out, there are Core i5 and Core i7 processors that currently being manufactured that have similar performance (or the Core i5 may actually run at a higher clock speed), but the Core i7 consumes half of the power of the Core i5.  If you are planning on using your laptop mostly in situations where your are running it on battery power, then paying the premium for the Core i7 is well worth it.  If on the other hand, you will not be traveling that often or you will generally have power available, you may prefer to have a slightly faster processor and to save a little money on the purchase as well.

Another aspect that is associated with the different levels of the Intel Core i series is the number of cores and threads each level has.  For desktop processors, the Core i3 series has 2 physical cores and 4 threads, the Core i5 series has 4 physical cores and 4 threads (mostly), and the Core i7 series has 4 physical cores and 8 threads.  This is not the case for Intel's mobile processors.  In fact, most mobile Core i5 and Core i7 processors have only 2 physical cores and 4 threads for both series.  But what does this mean in performance?  The number of cores and threads becomes important as your computer is required to multitask.  This can be extremely important for a programmer or developer who needs to run several operating systems in virtual machines simultaneously.  But for the typical user, processor clock speed will have a greater impact on user experience.

It is typically easier to get higher clock speeds with Intel processors than AMD processors.  Also, motherboards built with Intel chipsets seem to be better supported that other chipsets.  But quad-core laptops running Intel processors tend to be high-end products and are harder to find.  If you are on a budget and you want to run multiple OSes, and you need to use multi-threaded programs, than an AMD processor may be of better value to you.  The AMD mobile processors are divide into different A series: A4, A6, A8, A10.  The A4 series have 2 physical cores, the A6 series come with 2, 3 or 4 physical cores, and the A8 and A10 series all have 4 physical cores.  The next 4 digits, i.e.. A8-5600K have a relationship to clock speed, but this relationship is not one-to-one.  In fact sometimes higher numbers are used for slower clock speeds.  Therefore, you will need to lookup the specifications of the CPU by the CPU model number in order to compare the performance between any to laptop computers.  You can go to for specific information about any CPU.

Ed Lemmers