Start MySQL client as root user:
$ sudo mysql -u root
See existing users:
> SELECT User, Host from mysql.user;
root = true | |
[*] | |
charset = utf-8 | |
end_of_line = lf | |
insert_final_newline = true | |
tab_width = 2 | |
trim_trailing_whitespace = true |
#!/bin/php | |
<?php | |
$SUBJECT_PREFIX = "Subject: "; | |
$allHeadersRead = FALSE; | |
$subject = NULL; | |
while($f = fgets(STDIN)){ | |
$allHeadersRead |= (trim($f) === ''); |
ALTER TABLE `table_name` ADD COLUMN `uuid` binary(16); | |
# Each value must be different, see https://stackoverflow.com/a/54777792 | |
UPDATE `table_name` SET `uuid` = (SELECT UNHEX(REPLACE(UUID(), _utf8'-', _utf8''))); | |
ALTER TABLE `table_name` MODIFY `uuid` binary(16) NOT NULL; |
#!/usr/bin/env sh | |
if [ $# -ne 2 ]; then | |
echo "This script needs exactly two parameters: the path where the current Gradle wrapper is and the version to which to upgrade." | |
echo "Example: ./update_gradle_wrapper.sh ./path/to/directory/to/update/ 1.2.3" | |
exit 1; | |
fi | |
distType="all" | |
path="$1" |
// ==UserScript== | |
// @name Achavi-Link on OSM.org | |
// @namespace de.schaeferban | |
// @include https://openstreetmap.org/user/*/history* | |
// @include https://www.openstreetmap.org/user/*/history* | |
// @include http://openstreetmap.org/user/*/history* | |
// @include http://www.openstreetmap.org/user/*/history* | |
// @include https://openstreetmap.org/changeset/* | |
// @include https://www.openstreetmap.org/changeset/* | |
// @include http://openstreetmap.org/changeset/* |
<!DOCTYPE html> | |
<script src="https://code.jquery.com/jquery.min.js"></script> | |
<style> | |
span { | |
top:10%; | |
left:50%; | |
position:absolute; | |
animation: scale 30s infinite alternate linear; | |
} | |
@keyframes scale { |
#!/bin/bash | |
# This hook checks for whitespace problems and rejects pushing them (even with --force). | |
# Put this in the ./hooks/ directory on your (server-)repository. | |
# With the core.whitespace-attribute in your git-configuration you can control for which | |
# problems it should check (see http://www.git-scm.com/docs/git-config for possible values). | |
echo "Checking for whitespace problems introduced between $2 and $3" | |
git diff --check $2 $3 | |
exit `git diff --check $2 $3 | wc -l` |