Online SHA384 Hash Generator

I've tried to use the following SQL query, in order to generate (and then store) SHA-256 hashes:

CREATE TABLE IF NOT EXISTS hashes (  id int NOT NULL AUTO_INCREMENT,  text varchar(50) NOT NULL,  hash varchar(64) AS (SHA2(CONCAT(text), 256)) STORED  NOT NULL ,  PRIMARY KEY (id)) DEFAULT CHARSET=utf8;INSERT INTO `hashes` (`text`) VALUES ('testing');

But I get the following error:

#1064 - You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to usenear 'AS (SHA2(CONCAT(text), 256)) STORED  NOT NULL ,  PRIMARY KEY (id)) DEFAULT C' at line 4

I've found that query here on SO (it's an accepted answer):Using MySQL to Generate SHA-256 Hashes?

What's wrong? Is it really possible to generate (and then store) SHA-256 hashes using MySQL?

Thanks.

I read about that Git uses SHA-1 digest as an ID for a revision. Why does it not use a more modern version of SHA?

I'm currently using the crypt module in Python to try and create a SHA512 hash in the following manner.

When I run the following line of code from this SO post:

>>> import crypt>>> crypt.crypt('password', '$6$' + 'salt1234')

Instead of seeing the following output of the salt followed by the SHA512 hash per this SO post:

'$6$salt1234$Zr07alHmuONZlfKILiGKKULQZaBG6Qmf5smHCNH35KnciTapZ7dItwaCv5SKZ1xH9ydG59SCgkdtsTqVWGhk81'

I get the following:

$6FMi11BJFsAc

Below is a screenshot as proof:

Why is it that I'm unable to obtain the SHA512 hash that I'm expecting?

I'm looking at Weixin's document, I found that they are using SHA-1. I feel like it's not secure, but then my friend said 'never mind, we use https', so I am wondering, is it important to use SHA-1 or others? When will https encrypt our request?

Thanks!

This is Weixin's document:https://developers.weixin.qq.com/doc/offiaccount/en/Basic_Information/Access_Overview.html

private function checkSignature(){    $signature = $\GET["signature"];    $timestamp = $\GET["timestamp"];    $nonce = $\GET["nonce"];    $token = TOKEN;    $tmpArr = array($token, $timestamp, $nonce);    sort($tmpArr, SORT_STRING);    $tmpStr = implode( $tmpArr );    $tmpStr = sha1( $tmpStr );    if( $tmpStr == $signature ){        return true;    }else{        return false;    }}

I am using php mysqli_connect for login to a MySQL database (all on localhost)

<?php//DEFINE ('DB_USER', 'user2');//DEFINE ('DB_PASSWORD', 'pass2');DEFINE ('DB_USER', 'user1');DEFINE ('DB_PASSWORD', 'pass1');DEFINE ('DB_HOST', '127.0.0.1');DEFINE ('DB_NAME', 'dbname');$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);if(!$dbc){    die('error connecting to database');    }?>

this is the mysql.user table:

MySQL Server ini File:

[mysqld]# The default authentication plugin to be used when connecting to the serverdefault_authentication_plugin=caching_sha2_password#default_authentication_plugin=mysql_native_password

with caching_sha2_password in the MySQL Server ini file, it's not possible at all to login with user1 or user2;

error: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in...

with mysql_native_password in the MySQL Server ini file, it's possible to login with user1, but with user2, same error;

how can I login using caching_sha2_password on the mySql Server?