When I try to install and afterwards configure my phpmyadmin on my debian server I always get this error-message.
ERROR 1064 (42000): 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 'debian123'' at line 1
I am using: debian version: 9 ; MySql version: 8.0.19
What I tried:
I hope you can help me with my problem, because I am struggeling with it quite a while.
This is a change with newer versions of MySQL.
You can no longer use grant x on y.z to username identified by 'debian123'
.
You have to split the user creation into multiple steps.
Your MySQL should look like this instead:
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;