Some useful MySQL commands

Grant privileges* on table: To grant SELECT, INSERT, UPDATE, and DELETE privileges on table name: data_table to a user name jdoe, you would run the following GRANT statement: GRANT SELECT, INSERT, UPDATE, DELETE ON data_table.* TO ‘jdoe’@’localhost’; *Privileges can be any of: SELECT, INSERT, UPDATE, DELETE, INDEX, CREATE, ALTER, DROP, GRANT, ALL Revoke privileges on […]

ADSL ISP Linux Networking

Linux PPPoE configuration

I’m using Linux PPPoE for my internet connection, along with a Cisco VA887 router, in modem mode. Here’s the configuration for my specific ISP, but there’s no reason why this shouldn’t work with typical UK ISP’s This configuration should reside in /etc/ppp/peers/YOUR_ISP_NAME noipdefault defaultroute replacedefaultroute hide-password bsdcomp 15 deflate 15 noauth refuse-eap user ‘your isp […]

Sysprep Windows Windows 8.1

Keeping drivers after running sysprep

When building an image that is to be used on multiple machines of the same type, it’s useful to keep the drivers after running SYSPREP. To do this run the following prior to SYSPREP Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\Sysprep\Settings\sppnp Select Edit – New DWORD value Name the new value PersistAllDeviceInstalls Set to a value of 1 and […]