Tech /

My SQL





edit SideBar

My SQL

Basics

show databases;
show tables;
use somedb;

Variables:

show variables like "%foo%";

Status:

show status like "%foo%";

Blocked Hosts

mysqladmin flush-hosts

Permissions

Current:

show grants;

Available:

show privileges;
Recent Changes (All) | Edit SideBar Page last modified on 26 August 2019, at 12:55 PM UTC Edit Page | Page History
Powered by PmWiki