MySQL: GRANT ALL ON TO 'DENTIFIED BY ist deprected

[winkler-winsen]

wa4e/code/crud/NOTES.txt

Line 4 in cf57687

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

wa4e/code/crud/NOTES.txt

Line 5 in cf57687

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

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.