Core MySQL Errata


Barry Callahan found the following error on page 25. The SQL statement

GRANT ALL ON leon.* TO leon@'%' IDENTIFIED BY PASSWORD('secret');

is incorrect. The statement should read:

GRANT ALL ON leon.* TO leon@'%' IDENTIFIED BY 'secret';

Thanks, Barry!


Pierre Cloutier submitted the following bugs.

On page 22, paragraph 2, line 5: says “…if do choose”, should be “…if you do choose”.

Also on page 22, paragraph 5, refers to “my-example.cnf”. These files are now called my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf.

On page 72, first paragraph, line 3: “unless you refer”, should be “unless you prefer”.

On page 124, first paragram, line 3: “X’4CG5GFGE'” s/b “X’4C656F6E'” (‘G’ is not a hex digit). The proper value appears on the previous page.

Thanks, Pierre!

Leave a Reply

Your email address will not be published. Required fields are marked *