Apache Check Configuration
Check Apache configuration.
apache2ctl -t
Check BIND configuration.
named-checkconf -z
Check a specific zone from a file.
named-checkzone zonename zonefile
Display all iSCSI targets on give ip-address.
iscsiadm --mode discovery --type sendtargets --portal 192.168.1.250
Connect to a give target.
iscsiadm --mode node --targetname iqn.1994-04.org.netbsd.iscsi-target:target0 --portal 192.168.1.250:3260 --login
Close connection to a iSCSI target.
iscsiadm --mode node --targetname iqn.1994-04.org.netbsd.iscsi-target:target0 --portal 192.168.1.250:3260 --logout
Mount a iSCSI disk with lable ISCSI-0 on directory ‘/mnt/iscsi-0’.
mount /dev/disk/by-label/ISCSI-0 /mnt/iscsi-0
Display node records.
iscsiadm --mode node
iscsiadm --mode node --targetname iqn.1994-04.org.netbsd.iscsi-target:target0 --portal 192.168.1.250:3260
Connect to A MySQL instance using named pipe sessies.
>mysql -u root -p
Some examples to show database objects.
SHOW DATABASES; SHOW TABLES; SHOW COLUMNS FROM naam_van_table; SHOW STATUS; SHOW FULL PROCESSLIST; SHOW PROCEDURE STATUS;
View a stored procedure.
SELECT ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE SPECIFIC_NAME = '<procedure_name>' AND ROUTINE_SCHEMA = '<database_name>;
CREATE DATABASE naam_van_database; DROP DATABASE naam_van_database; USE naam_van_database;
CREATE and ALTER table syntax.
CREATE TABLE naam_van_table (column0_id int(10) unsigned NOT NULL primary key auto_increment, column1 varchar(75) NOT NULL default '', column2 varchar(75) NOT NULL default '', column3 varchar(40) NOT NULL default '', column4 int(10) unsigned default NULL) engine = InnoDB;
ALTER TABLE naam_van_table ADD COLUMN (column5 bool default 0); ALTER TABLE naam_van_table ADD COLUMN column6 int unsigned AFTER column2; ALTER TABLE naam_van_table DROP COLUMN column2; ALTER TABLE naam_van_table ADD INDEX naam_van_index (naam_van_column);
SELECT * FROM naam_van_table WHERE naam_van_column='text'; SELECT column1, column2 FROM naam_van_table WHERE column3='text'; SELECT COUNT(*) FROM naam_van_table;
INSERT INTO naam_van_table VALUES (1, 'Jan', 'Jansen', MD5('zaq123'), 'Docent'); INSERT INTO naam_van_table (voornaam, achternaam, pswd) VALUES ('Jan', 'Jansen', MD5('zaq123')), ('Piet', 'Pieterse', MD5('qaz321'));
UPDATE naam_van_table SET naam_van_column1 = 'X' WHERE naam_van_column2='Y';
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT Select ON databasename.tablename TO 'username'@'localhost'; GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'%.domain.tld'; ALTER USER 'username'@'localhost' IDENTIFIED BY 'newpassword'; FLUSH PRIVILEGES;
Add file_priv to account to make it possible to use a bulk import procedure.
USE MYSQL; UPDATE user SET file_priv = 'Y' WHERE user='username'; FLUSH PRIVILEGES;
Except for embedded material you are free to share and adapt any code and articles from this site. All music is licensed under Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0).
Use published scripts and code at your own risk and test thoroughly before usage. Make sure you understand the code!