MySQL Forums
Forum List  »  Install & Repo

Why does this give syntax error?
Posted by: Parthasarathy Mandayam
Date: October 26, 2018 06:43AM

CREATE USER 'sha256user'@'localhost'
IDENTIFIED WITH sha256_password BY 'password';

I'm connecting to a mysql 8.0 server from mysql 6.3 workbench and it gives syntax error. Where is the syntax error?
What is wrong?
This is from your manual only
Then why is it giving syntax error?

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

Regards

Partha Mandayam
Software Consultant
http://www.linkedin.com/in/mcp111

Options: ReplyQuote


Subject
Written By
Posted
Why does this give syntax error?
October 26, 2018 06:43AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.