Search Results

(2026-09-24) Problem The ManageEngine page includes spaces in the registry key names it wants you to create, however the spaces make the entry wrong when you copy/paste them. Solution When creating the registry keys under Computer\HKEY_LOCAL_MACHINE\SYSTEM\Cur...

(2026-09-24) Export the NPS Clients Get-NpsRadiusClient | ForEach-Object { Write-Output "New-NpsRadiusClient -Name `"$($_.Name)`" -Address `"$($_.Address)`" -SharedSecret `"$($_.SharedSecret)`" -VendorName `"$($_.VendorName)`" -AuthAttributeRequired `$fals...

(2026-10-02) ICMP ping scan: nmap -sn 192.168.1.0/24 Scan for a specific port: syn scan: nmap -sn -PS22 192.168.1.0/24 ack scan: nmap -sn -PA22 192.168.1.0/24

(2026-10-08) Version: 8.0.1 SSH to the esxi node esxcli system snmp get esxcli system snmp set -a SHA1 -x AES128 esxcli system snmp hash --auth-hash mysecret --priv-hash myothersecret --raw-secret esxcli system snmp set --users librenms/ceb749c1e03aba2097b1860...

(2026-10-08) Firmware WB.16.10.0025 Configure snmpv3: snmpv3 enable At this point it will prompt you to configure the "initial" user. Follow the prompts. Then: snmpv3 restricted-access snmpv3 user myuser plaintext auth sha priv aes At this point it will prom...

(2026-10-08) systemctl stop snmpd net-snmp-create-v3-user -ro -a SHA -A "myAuthPassword" -x AES -X "myPrivPassword" snmpv3user systemctl start snmpd

You're gonna want to run these as the librenms user. Command list clients with snmp versions lnms report:devices -f hostname,ip,community,snmpver | grep -v v3 cli discovery lnms device:discover HOSTNAME cli new node lnms device:add --v3 -u <userna...

(2026-10-13) (On Ubuntu LTS 24.04) The apt install does the "git init", so everything else is just git. Remember the sudo if you are not root. Minimal identification: # sudo git config --global user.email "root@localhost" # sudo git config --global user.name "...

$ mysql -h 192.168.1.8 -u root -p Enter password: You have to set up the remote access first: $ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES;

(if you don't know what it is) Log on to your system as the Unix mysql user that the mysqld server runs as. Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, host name, and configu...

(2017-09-13) > update mysql.user set Password=PASSWORD('newpass') WHERE user='username'; > flush privileges;

(2006-09-07) Previously, in MySQL To create a user jsmith with password Secret15 and allow them to do anything with the database named accounts, connect to the database with mysql and issue the command: mysql> grant all on accounts.* to jsmith@localhost identi...

Comma Separated Values format for MySQL Data mysql> SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM response_answers;

(2023-05-02) The most common way to get a list of the MySQL databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command. $ mysql -u me -p [-h remotehost] mysql> show databases -> ; +--------------------+ | Datab...

(2017-06-21) SELECT User FROM mysql.user; More info: SELECT User, Host, Password FROM mysql.user;

To make mysql listen only on the localhost interface, add the following to each of the three sections in /etc/my.cnf bind-address = 127.0.0.1

(4 February 2013) Problem When doing an import, I get the error: ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes Solution Open a terminal and run this: $ mysql -u root -p mysql> set global net_buffer_length=1000000; mysql> se...

...assuming you are using the rpms that come with your distro, and you have actually installed the rpms. # chkconfig mysqld on # service mysqld start # mysqladmin password $YOUR-ADMIN-PASSWORD # mysql -u root -p mysql > select user(); > quit