mysql

MySQL command-line tool

kopje
486
66
SHOW GRANTS FOR 'root'@'localhost';

detajet |

kopje
428
86
ALTER TABLE tbl AUTO_INCREMENT = 100;

detajet |

kopje
186
14
GRANT SHUTDOWN ON *.* TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass';

detajet |

kopje
241
30
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

detajet |

kopje
250
21
ALTER TABLE CountryLanguage ENGINE=NDBCLUSTER;

detajet |

kopje
270
30
select * from siteExampleCmds where parentID=1 and example like '%alter%'

detajet |

kopje
171
12
GRANT USAGE ON *.* TO 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100;

detajet |

kopje
226
50
ALTER TABLE tt MODIFY ActualPC VARCHAR(15);

detajet |

kopje
209
18
ALTER TABLE orig_name RENAME new_name;

detajet |

kopje
197
21
ALTER TABLE City ENGINE=NDBCLUSTER;

detajet |

kopje
197
21
ALTER TABLE Country ENGINE=NDBCLUSTER;

detajet |

kopje
194
11
GRANT USAGE ON *.* TO 'francis'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 0;

detajet |

kopje
324
57
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

detajet |

kopje
185
17
ALTER TABLE t1 MODIFY b CHAR;

detajet |

kopje
183
14
SELECT * FROM TBL_NAME WHERE KEY_COL LIKE 'Pat%_ck%';

detajet |

kopje
172
18
ALTER VIEW v AS SELECT * FROM t;

detajet |

kopje
172
14
GRANT SELECT,UPDATE,INSERT on database.* to 'user'@'localhost' IDENTIFIED BY 'password';

detajet |

kopje
239
19
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO 'custom'@'server.domain' IDENTIFIED BY 'obscure';

detajet |