plsql

warning: Creating default object from empty value in /data/web/1/000/027/003/273448/htdocs/panticz.de/modules/taxonomy/taxonomy.pages.inc on line 33.

MySQL Queries

-- 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(
Syndicate content