Can anyone help get this command working again? This cmd used to work in the putty console -
sudo mysql-create-db-and-user dbuserhere dbnamehere passwordhere
This error now appears -
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'passwordhere'' at line 1
I have MySQL version 8.0.28 on Ubuntu 20.04.4 LTS.
The database is created but I can’t connect to it using the username and password used in the cmd.
I can only guess it stopped working after I did sudo apt update
and sudo apt upgrade
.
This is the error in /var/log/mysql/error.log
2022-05-26T04:50:06.754109Z 21 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @twc8ac35a8636,
The new script should look like this:
Let me know how it goes.
Hi @twc8ac35a8636,
Is mysql-create-db-and-user some kind of a custom script?
What I think happened is that with
apt update
andapt upgrade
you’ve updated a Minor version or a NOT so minor version on MySQL which has a different syntax for the CREATE statement being used in the mysql-create-db-and-user script.What I’ll recommend is to find the said script and update it with the new Syntax.