Reputation
4,399
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 16
Newest
 Yearling
Impact
~270k people reached

  • 0 posts edited
  • 0 helpful flags
  • 79 votes cast
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;
Apr
26
answered Are relay logs necessary for replication?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
@RolandoMySQLDBA are you using 5.6 yourself in production?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
That doesn't make sense, either.
Apr
18
answered Will redirecting queries to dev/null warm up indexes?