Skygist

Explore

  • All gists
  • Topics
  • Users
Give feedback on the new UI Powered by Opengist ⋅ 69ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login
m

mysql

Recently created Least recently created Recently updated Least recently updated
KarelWintersky

KarelWintersky / MySQL -- create user & database + password

Last active 2 months ago mysql
0 0 1
1 #!/usr/bin/env bash
2
3 #
4 # Script to create MySQL/MariaDB db + user
5 #
6 # @author Karel Wintersky <karel.wintersky@gmail.com>
7 # @version 0.5
8 # mysql_config_editor set --login-path=proftpd --host=localhost --user=proftpd --password
9 # version this: https://gist.github.com/KarelWintersky/72021fe214f9d2f6ddc6a28c732baac1
KarelWintersky

KarelWintersky / MySQL slow

Last active 2 months ago mysql

About mysql slow queries

0 0 1

Настройка лога медленных запросов (Slow Query Log)

[mysqld]
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log_queries_not_using_indexes = 1

; -- Включить общий лог запросов
KarelWintersky

KarelWintersky / MySQL - пользователи, хосты, права

Last active 2 months ago mysql

Выводит список пользователей/хостов/БД в MySQL с правами

0 0 1

Подробный список всех привилегий для всех пользователей

SELECT 
    grantee, 
    table_schema, 
    privilege_type 
FROM 
    information_schema.schema_privileges 
ORDER BY