MySQL: GRANT ALL ON TO 'DENTIFIED BY ist deprected

[winkler-winsen]

https://github.com/csev/wa4e/blob/cf576876a77c264a88348022ec7c6891ad2bb0ed/code/crud/NOTES.txt#L4 https://github.com/csev/wa4e/blob/cf576876a77c264a88348022ec7c6891ad2bb0ed/code/crud/NOTES.txt#L5

Should be altered to:

CREATE USER 'fred'@'localhost' IDENTIFIED BY 'zap';
GRANT ALL ON misc.* TO 'fred'@'localhost';
CREATE USER 'fred'@'127.0.0.1' IDENTIFIED BY 'zap';
GRANT ALL ON misc.* TO 'fred'@'127.0.0.1';

[srcatto]

The current versions of MAMP, XAMPP are not MySQL 8.0 yet. There is also a note in course 2 about the default character set changes. Courses 3 & 4 are due to get a pinned post as well. See your other issue post. Not sure 2 are needed.

[csev]

@winkler-winsen Do you want to just edit the file and send a pull request?

[srcatto]

Thanks for the updated commands. Tested on - a) Win 11 x64Pro 22H2, MySQL 5.6.34 phpMyAdmin 4.7.0 b) Ubuntu 20.04 x64 MySQL 8.0.30 phpMyAdmin 5.2.0 Created PR #52 for this and remove phpMyAdmin warning, "A comma or a closing bracket was expected. (near KEY)" , for lines 3-5 & update utf8 to utf8mb4.