Allow remote access to MYSQL database

To allow remote access to MySql first create a MySql user and assign host as %.

CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';

then grant privileges

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';

then flush privileges

FLUSH PRIVILEGES;

You may need to add the following to /etc/mysql/my.cnf to listen for all ip’s instead of just localhost, this will override the setting bind-address = 127.0.0.1

[mysqld]
bind-address = 0.0.0.0

You may also need to allow TCP port 3306 for incoming connections in your firewall for MySql.

Fix Windows 7+ Corrupt Profile

If a user is given a temporary profile whilst logging onto Windows you can try the following to remedy the problem.

1. Log in using an account with administrative rights
2. Delete the key associated with the corrupt user in HKLM\Software\Microsoft\Windows NT\CurrentVersion\ProfileList
3. Delete the key associated with the corrupt user in HKLM\Software\Microsoft\Windows NT\CurrentVersion\ProfileGuid
4. Rename corrupt user folder in c:\users\[user]
5. Restart machine and log on with problem user

Tested:Windows 7

Reset RDP Sessions

When using Windows RDP you may encounter the error message ‘The terminal server has exceeded the maximum number of allowed connections’. You can delete open sessions or use the admin switch to administer the server.

At the command prompt:
To administer the server:

mstsc /v:<server> /admin

To obtain a list of current sessions:

query session /server:<server>

To close a session – [ID] can be found from session list

reset session [ID] /server:<server>

Get Serial Number From A Windows Machine

On a Windows based operating system you can find out the serial number for a machine using WMIC – the command line interpreter for WMI. This can be used for the local machine or a remote machine.

From the command prompt:

For the local machine

wmic bios get serialnumber

For remote machine(s) using /node

wmic /node:[ADDRESS/COMPUTER NAME] bios get serialnumber

/node
Computer names either comma delimited or listed within a file. File names have to be prefixed with &. Computer names/addresses within the file must be comma delimited or on separate lines.