mysqldump gives Error 1045 access denied when using .my.cnf for automated backups using sh script 
I had to change my passwords recently and I found that after I did this for the credentials used to access my mysql databases that my automated backup scripts became broken. I finally found a fix for this.

It turned out that if you use special characters in your passwords like !@#$%^&*() this will confuse mysqldump when it's reading your login credentials from a my.cnf file.

The my.cnf file is used mostly when you want to create an automated method of backing up your mysql database contents. Since the process is automated and it needs a password, it's a security risk to just use the -p switch with mysqldump in your shell script because the password will be exposed in plain text in the process list of the machine while the mysqldump process runs.

The my.cnf file holds the login credentials on disk, but are set to be only readable by your user, so other users can see what's in the file. The mysqldump process can read the file to get the credentials, keeping them safe.

I found a forum posts here: https://www.virtualmin.com/node/21032 by chitoz that had a small mention about the character # being used in his password and it creates problems.

The fix for this was to edit the my.cnf file and enclose the password string in single quotes:

[client]
username = user
password = 'specialChars@$#&%'

[ view entry ] ( 44 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 130 )
HOWTO Fix Non-Removable Google Play Movies and TV Notifications on Android Phone 
For the interwebz:

1. Go to Google Play Store and update or install the Google Play Movies app
2. Open Google Play Movies & TV app
3. Once you open the app, the notifications should all disappear from your phone's notification curtain
4. In the app, go to Settings, under section "Get Notifications" untick the options you don't want to see



[ view entry ] ( 89 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 2.9 / 42 )
Mi Remote Android App and Aldi EasyHome Oscillating Fan Pairing 
We have a pedastal fan from Aldi which comes with remote control and I wanted to see if the MiRemote app that comes with MIUI Android phones like the Xiaomi range of phones worked with the fan.

The remote app doesn't list any brand names that looked familiar such as EasyHome or Aldi that could be found on the fan itself, so I thought I'd randomly try a Chinese brand fan and hope for the best.

The best is what I got by fluke. I chose Xiaoxiang brand fan from the brand's list in the app and the second (of 2) options pressing the power button worked for me.

I then tried all the buttons in the app and pretty much all of them worked. Power, fan speed, fan mode, oscillation all works.

[ view entry ] ( 169 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 2.9 / 207 )
HOWTO Alter, CHange or Remove Underline or Box Shadow from Anchor HREF Links in Wordpress 4.9.5 Theme TwentySeventeen 
This note just logs how I altered the CSS styles in Wordpress 4.9.5 with theme TwentySeventeen to change the link colours and style, and also to control the box shadow (which at the time I didn't even know what that thing was called)

Read More...

[ view entry ] ( 168 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 2.9 / 140 )

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next> Last>>