snipt

Ctrl+h for KB shortcuts

INI

reasonable mysqld default on Ubuntu

1
2
3
4
#this should become /etc/mysql/conf.d/django.cnf
[mysqld]
default-character-set=utf8
default-storage-engine=innodb
https://snipt.net/embed/11e375a52ebc2a17b39df4b69e1a9bb5/
/raw/11e375a52ebc2a17b39df4b69e1a9bb5/
11e375a52ebc2a17b39df4b69e1a9bb5
ini
INI
6
2019-07-16T10:00:45
True
False
False
/api/public/snipt/3247/
reasonable-mysqld-default-on-ubuntu
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">#this should become /etc/mysql/conf.d/django.cnf</span> </span><span id="L-2"><a name="L-2"></a><span class="k">[mysqld]</span> </span><span id="L-3"><a name="L-3"></a><span class="na">default-character-set</span><span class="o">=</span><span class="s">utf8</span> </span><span id="L-4"><a name="L-4"></a><span class="na">default-storage-engine</span><span class="o">=</span><span class="s">innodb</span> </span></pre></div> </td></tr></table>
configuration, defaults, mysql, ubuntu

INI

passwordless access to mysql

1
2
3
4
#this should be in your ~/.my.cnf
[client]
user=root
password=<the password>
https://snipt.net/embed/138070396e31c714ba371c70285d5dda/
/raw/138070396e31c714ba371c70285d5dda/
138070396e31c714ba371c70285d5dda
ini
INI
4
2019-07-17T08:32:50
True
False
False
/api/public/snipt/422/
passwordless-access-to-mysql
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="c1">#this should be in your ~/.my.cnf</span> </span><span id="L-2"><a name="L-2"></a><span class="k">[client]</span> </span><span id="L-3"><a name="L-3"></a><span class="na">user</span><span class="o">=</span><span class="s">root</span> </span><span id="L-4"><a name="L-4"></a><span class="na">password</span><span class="o">=</span><span class="s">&lt;the password&gt;</span> </span></pre></div> </td></tr></table>
configuration, mysql, passwordless