search

csev / wa4e

Course materials for www.wa4e.com
BSD 2-Clause "Simplified" License
209 stars 228 forks source link

MySQL: GRANT ALL ON TO 'DENTIFIED BY ist deprected #28

Open winkler-winsen opened 4 years ago

winkler-winsen commented 4 years ago

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 commented 3 years ago

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 commented 2 years ago

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

srcatto commented 1 year ago

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.