To trim new lines in bash:
tr -d '\r\n'
Trimming new line in bash
Reply
Daily Archives: 2013-09-27 [Friday]
Getting a file by HTTP and redirecting file contents to stdout
To download a file from the web and send its contents to standard out, try this:
wget -O - -o /dev/null https://www.unconfusable.com
Change root password in MySQL
Needed to set a MySQL root password. Found this article which suggested a way when no password is yet configured:
mysqladmin -u root password NEWPASSWORD
And a way when a password is already configured:
mysqladmin -u root -p'oldpassword' password newpass
Note: you use ‘mysqladmin’ not ‘mysql’.