Posts

Showing posts from March, 2020

The server requested authentication method unknown to the client [caching_sha2_password]

Image
This time i got this PHP error after upgrading my MYSQL from version 5 to 8. Error says:

The server requested authentication method unknown to the client [caching_sha2_password]
This is because of the changing of default authentication password mechanism from previous MySQL to newest MySQL 8. The newest version uses an authentication plugin called caching_sha2_password meanwhile the older version is mysql using native password. So I guess it's a security thing, but don’t worry the older version I believe is already secure enough, you just need to make your password really strong (for your production server).

So if you execute SQL query below

select User,plugin from mysql.user ;

You will see what the plugin is being used for the user password, something like

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | caching_sha2_password |
+------------------+-----------------------+

So the …

Mysqli::real_connect(): Server sent charset (255) unknown to the client - PHP and MySQL 8

Image
Below is the PHP error occured when developing PHP apps using upgraded version MySQL 8, before that I used MySQL 5.

mysqli::real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
This PHP error happens after i upgrade MySQL version from 5 to 8, it happens because the utf8 is being replaced by utf8mb4. So if you use this SQL queries, you will see what the default charset is being used by MySQL:

show global variables like 'character_set_server';
In MySQL version 8, it showing something character_set_server | utf8mb4.

So the easiest way to solve this problem is to change it back the way it is before, to change it to utf8. So here’s the query to change it back from utf8mb4 to utf8.

You can change the character set by putting or changing this in your my.ini:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
Save my.ini and restart MySQL service. M…

What You Need To Know About Java Platform - For Beginner

Image
Java is an amazing platform, both as a language and its JVM. The language is not that beautiful but it is concise and can be easily integrated with IDE. The VM may not be that good either, some say it's a clumpy-memory hunger program, but surely the cross-platform thing makes it fascinating.

Here's some Java related terminology in Java you need to know if you are beginer in Java application development.

1. Java the language It’s a full object oriented language, which means everything must be written in a class style. So after the class is initiated then you treat them as an object where you can do some operation using its properties and methods.

2. JDK (Java Development Kit) JDK is a set of tools mainly for compiling Java code into binary JVM bytecode. So then you can ship your product in a binary either JAR or WAR after your code is successfully compiled by the javac command included in JDK.

3. JVM (Java Virtual Machine) The JVM works as runtime for reading Java bytecodes, so…

Must-have Windows appplication for software developer fresh OS install

Image
1. Gimp Gimp is an open source lightweight very capable image editor, sometimes we need to just resize, cropping, or layering an image, Gimp can do many things to alter images.

It is a free and fast application, also the learning curve is easier than let’s say Adobe products with many hidden little buttons we don’t even want to know about it.

2. Git Git is the most popular version control, every software developer using Git nowadays, its command line is simple and we can use it to clone as many cool open source projects as we want. I mean not just cloning, you can use git for your daily routine developing your app in your  professional tech company.

3. Google chrome If you are using windows there’s already have two ugly web browser by default (explorer and edge), such a waste of disk space, if i could get rid of it i would definitely uninstall it from the beginning of OS installation, it’s an F useless, a clumpy dusted program.

Ever Since i used Chrome, I've never used any other …

How to install Mac OS Catalina on VMWare on Windows 10

Image
Yes it is possible to install Mac OS on VMWare, or even whatever OS you want to, VMWare can handle it. It just sometimes VMWare doesn't want to load your OS image perfectly, so it needs special tricks to handle the situation to make it work.

In this tutorial, we are going to use VMWare player version 15.5.1, so pay attention if you don’t have the similar version like i use, it may not work.

You must have a WMDK image of Mac OS, you can find them on Geekrar dot comA patch tool / VMWare Mac OS unlocker, to make Mac OS available on the list of OSes when we are trying to create new, also available from Geekrar
So here’s steps how to install Mac OS on VMWare

Download and extract the patch tool, then Install the patch tool, by right click on ‘win-install.bat’ and run as administratorAfter finishing install the patch, close and reopen VMWareNow create new Virtual MachineConfiguration, select TypicalInstall from, I will install the operating system laterGuest OS, Mac OSVersion, select the …

How to restore a SQL Server backup file (bak) database using SSMS

Image
It is not a hard task to restore our backuped SQL Server database data, but it's a bit tricky for a newbie because sometimes the error message provided by SQL Server is sometimes not straightforward and can lead to confusion for beginners.

The first time I tried to restore a database was literally quite a stressful experience. so i don't want you to spinning your head like i did, these are main advice for doing restoring database in SQL server using SSMS:

- Don't create the database
- Put the backup file in the right location

In my machine it is C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup (It depends on your version of Sql-server)

It is easy to restore database from SSMS, here’s how:

1. Right click on the 'Databases' then 'Restore database'
2. After popup open, on the Source field, select Device
3. Then click the three dotted button to browse your backup database
4. After that just press OK and you're good to go

Well SQL serv…

Coronavirus positive impact on people become aware to live more hygienic

Image
This corona virus named Covid-19 originated from Wuhan, mainland China has been spreading the last couple weeks, believed to be started at late 2019 and still spreading till this day.

Since the news about the virus is coming out everywhere on TV, on the internet, I notice that people around me are starting to be aware about their personal higenity. They wash their hands frequently like I've rarely seen before.

I think we should thank the internet because people are able to find a way by searching on how to prevent Covid 19 or any other disease related to the virus infected them. Also social media which i frequently use people posting positive to encourage people on their personal hygiene.

Coronavirus impacts on people hygienity, they are becoming aware that if they don’t wash their hands for example they can be infected and it’s kind of a positive impact of the virus for the people who are not infected by it.

But I hope this awareness that our body is fragile to even small viruse…

Social Media is an addictive innovation of early 21st century

Image
This is the early 21st century. Social media nowadays is like a basic need for the majority of people on this planet. With the help of our fast processing device called smartphone, social media now has made people using it kind of out of control.

Social media is not to be blamed for making people addicted to it, because it’s fun to use it. Especially when we don’t have anything to do, we only have a smartphone in our hand, social media is like a friend when we don’t have any friends to talk to.

Of course there's a lot of options, lots of apps we can use, games, but sometimes other apps are just too boring. Social media is like watching our friends or someone far away we don’t know, what were they doing, even though they are not present, we feel like we are connected to them. Social media is winning in the smartphone apps world, because we don’t want to be alone, even if it's not perfected yet, current platforms like Facebook are still helping them to connect.

Sharing their ph…

Popular posts from this blog

Is Nox Player a Malware? Nox Android Emulator

ASUS Battery Health Charging Software To Make Your Battery Life Longer

Flutter AppBar, With Icon, Title and Actions Link

How To Uninstall Angular CLI, The Angular Framework

ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password