Re: "show grants for xyz" does no show all privileges

[Tobin Cataldo]

Greetings,

'bts'@'127.0.0.1' is a different user than 'bts'@'%'.


"SHOW GRANTS displays only the privileges granted explicitly to the named account." ( http://dev.mysql.com/doc/refman/5.6/en/show-grants.html )

http://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_usage


In terms of installation and maintenance. Install your production MySQL server with a mind to applying updates. Only BIN SHARE and DATA are required to run a production server. The debug files and directories inside BIN are also not necessary. mysql_upgrade should be run every time you update the server executables.

Did you know you can set the
DATADIR via configuration option to a location outside of the installation dir.

For instance:
C:\MySQL
C:\MySQL\MySQL Server 5.6\
C:\MySQL\mysql-data\