Reputation
4,694
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
8 17
Newest
 Nice Answer
Impact
~337k people reached

  • 0 posts edited
  • 0 helpful flags
  • 80 votes cast
5h
comment Grant access to a table to all users
Nice hack! This seems to work well
Dec
5
comment mysql: Show GRANTs for all users
@ThorSummoner, it is unfortunate that the MySQL's default value for group_concat_max_len is 1024. It is one of the first defaults to change, and I recommend that you set it to a high value such as 1,000,000 or above. See further in my blog
Dec
2
awarded  Nice Answer
Oct
5
awarded  Good Answer
Jul
12
awarded  Yearling
Jul
9
comment mysql: Show GRANTs for all users
@Pacerier please see my comment on the user_privileges answer
Jul
9
comment mysql: Show GRANTs for all users
Sorry, it should not be the accepted answer. information_schema.user_privileges only lists user-level privileges, such as SUPER, RELOAD etc. It also lists all-round DML grants like SELECT. It does not list database-specific, table-sepcific, column-specific, routine-specific privileges. There fore, the grant GRANT SELECT ON mydb.* TO myuser@localhost does not show on information_schema.user_privileges. The common_schema solution presented above aggregates data from user_privileges and other tables to give you the full picture.
Nov
19
comment MySQL relay log rotates too soon and too often
Also kill -HUP makes for an implicit FLUSH LOGS. Check if you have a crontab entry that does that
Nov
5
answered Truncating and inserting in a safe transaction on MySQL
Nov
5
comment Truncating and inserting in a safe transaction on MySQL
This leaves the database in a state where mytable does not exist. Use a RENAME table statement instead, which allows for two atomic renames
Oct
3
awarded  Nice Answer
Sep
28
revised Can I time out my scripted “FLUSH TABLES WITH READ LOCK;”?
fixed markdown
Sep
24
awarded  Autobiographer
Aug
6
answered SHOW SLAVE HOSTS shows incorrect output
Aug
2
answered Mysql dump with View dependent on user
Jul
12
awarded  Yearling
Jul
7
awarded  Revival
Jun
9
awarded  Enlightened
Jun
9
awarded  Nice Answer
Jun
4
comment How To Prevent Replication Failure
To skip a single, known query, issue: SET GLOBAL SQL_SLAVE_SKIP_COUNTER:=1; START SLAVE;