This tip can be used if you forget or want to change MariaDB root password.
Make sure to install MariaDB using Homebrew.
This tip is from Update root password in MariaDB 10.4 on MacOS
This tip can be used if you forget or want to change MariaDB root password.
Make sure to install MariaDB using Homebrew.
This tip is from Update root password in MariaDB 10.4 on MacOS
// This is a documented version of the build.gradle file from RemotePreferences: | |
// https://github.com/apsun/RemotePreferences/blob/master/library/build.gradle.kts | |
// | |
// It aims to explain exactly WTF is going on when you inevitably copy-paste | |
// someone's build.gradle from the internet and can't figure out why it's not | |
// working. | |
// | |
// It contains, to the best of my knowledge, the best practices as of Oct 2023 for | |
// building an Android library and publishing it to OSSRH (Maven Central). | |
// |
public static class ExtensionMethods | |
{ | |
public static TaskAwaiter GetAwaiter(this AsyncOperation asyncOp) | |
{ | |
var tcs = new TaskCompletionSource<object>(); | |
asyncOp.completed += obj => { tcs.SetResult(null); }; | |
return ((Task)tcs.Task).GetAwaiter(); | |
} | |
} |
Attempting mysql -u root
fails with Access denied for user 'root'@'localhost
immediately after doing brew install mariadb
and starting mariadb with brew services start mariadb
.
To fix it (with MariaDB still running):
sudo mysql
then enter your Mac user passwordALTER USER 'root'@'localhost' IDENTIFIED BY 'newrootpassword';
replacing newrootpassword
with the password you wish to use for the MariaDB root user.You should then be able to connect to MariaDB with mysql -u root -p
, then entering the root password when prompted.
#!/bin/bash | |
# README: A more updated version is on the comments by (ashmna)[https://gist.github.com/ashmna] | |
# See at: https://gist.github.com/allangarcia/938b052a7d55d1652052e4259364260b?permalink_comment_id=4265898#gistcomment-4265898 | |
# this is for tools required | |
brew update | |
brew install ninja | |
brew install cmake |
#include <stdint.h> | |
#include <stdio.h> | |
#include <stdlib.h> | |
// munged from https://github.com/simontime/Resead | |
namespace sead | |
{ | |
class Random | |
{ |
This notes is written by Sheldon. You can find me with #iOSBySheldon in Github, Youtube, Facebook, etc.
Convert .mov/.MP4 to .gif
As a developer, I feel better to upload a short video when I create the pull request to show other viewers what I did in this PR. I tried .mov format directly got after finishing recording screen using Quicktime, however, gif offers preview in most web pages, and has smaller file size.
This is not limited to developer, anyone has this need can use this method to convert the files.
// build a jar with source files | |
task sourcesJar(type: Jar) { | |
from android.sourceSets.main.java.srcDirs | |
classifier = 'sources' | |
} | |
task javadoc(type: Javadoc) { | |
failOnError false | |
source = android.sourceSets.main.java.sourceFiles |
#!/bin/bash | |
# Based on http://blog.pkh.me/p/21-high-quality-gif-with-ffmpeg.html | |
# Requires ffmpeg | |
filename="${1%.*}" | |
palette="/tmp/palette.png" | |
filters="scale=320:-1:flags=lanczos" | |
ffmpeg -v warning -i "$1" -vf "$filters,palettegen" -y $palette | |
ffmpeg -v warning -i "$1" -i $palette -lavfi "$filters [x]; [x][1:v] paletteuse" -y "$filename.gif" |