TuxNet DokuWiki

SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';

SHOW CREATE VIEW my_view_name;

alter table t_hosts add mac_address varchar(17);

alter table t_hosts change mac_adress mac_address varchar(17);

explain t_hosts;

update t_hosts set hostname='motog-nadin' where hostId='4';

show grants for 'marko'@'marko-ThinkPad-T500.tuxnet.local';

revoke all privileges on `tuxnetlocal`.* from 'marko'@'marko-thinkpad-t500.tuxnet.local';

GRANT all privileges on `KMyMoney`.* TO 'marko'@'notebook-marko.tuxnet.local' IDENTIFIED BY 'password';