MySQL Queries
- Read more about MySQL Queries
- Log in to post comments
-- view hostname
select @@hostname;
-- view version
select version();
-- view engines
show engines;
-- list databases
show databases;
-- change database
use mysql;
-- show tables in database
show tables;
-- show table informations
show table status;
-- show engines
show engines;
-- show bin_log info
show variables like '%log_bin%';
-- list users
select user, host from mysql.user;
-- delete user
DROP USER 'USER_NAME'@'%';
-- set user password
--SET PASSWORD FOR 'USER_NAME'@'%' = PASSWORD('NEW_PASSWORD')
use mysql;
update user set password=PASSWORD(