snipt

Ctrl+h for KB shortcuts

MySQL

insert new domain into mail db on slicehost

INSERT INTO `domains` (`domain`) VALUES ('demoslice.com');
https://snipt.net/embed/0f0109e582cc198f16f3ee90a9914761/
/raw/0f0109e582cc198f16f3ee90a9914761/
0f0109e582cc198f16f3ee90a9914761
mysql
MySQL
1
2019-08-16T00:23:11
True
False
False
/api/public/snipt/3515/
insert-new-domain-into-mail-db-on-slicehost
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">INSERT</span> <span class="k">INTO</span> <span class="ss">`domains`</span> <span class="p">(</span><span class="ss">`domain`</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="s1">&#39;demoslice.com&#39;</span><span class="p">);</span> </span></pre></div> </td></tr></table>
email, mysql

MySQL

insert user into mail db

INSERT INTO `users` (`email`, `password`) VALUES ('[email protected]', ENCRYPT('secretpassword'));
https://snipt.net/embed/dd9511a6ed734fa7bb38ae59c8229e7f/
/raw/dd9511a6ed734fa7bb38ae59c8229e7f/
dd9511a6ed734fa7bb38ae59c8229e7f
mysql
MySQL
1
2019-08-16T09:43:02
True
False
False
/api/public/snipt/2071/
insert-user-into-mail-db
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">INSERT</span> <span class="k">INTO</span> <span class="ss">`users`</span> <span class="p">(</span><span class="ss">`email`</span><span class="p">,</span> <span class="ss">`password`</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="s1">&#39;[email protected]&#39;</span><span class="p">,</span> <span class="nf">ENCRYPT</span><span class="p">(</span><span class="s1">&#39;secretpassword&#39;</span><span class="p">));</span> </span></pre></div> </td></tr></table>
email, mysql

MySQL

setup email forwarding in mysql

INSERT INTO forwards (source, destination) 
VALUES ('[email protected]', '[email protected]');
https://snipt.net/embed/ececc5f5260b4684af760ce9678f74b6/
/raw/ececc5f5260b4684af760ce9678f74b6/
ececc5f5260b4684af760ce9678f74b6
mysql
MySQL
2
2019-07-31T09:13:07
True
False
False
/api/public/snipt/6/
setup-email-forwarding-in-mysql
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">INSERT</span> <span class="k">INTO</span> <span class="nf">forwards</span> <span class="p">(</span><span class="n">source</span><span class="p">,</span> <span class="n">destination</span><span class="p">)</span> </span><span id="L-2"><a name="L-2"></a><span class="k">VALUES</span> <span class="p">(</span><span class="s1">&#39;[email protected]&#39;</span><span class="p">,</span> <span class="s1">&#39;[email protected]&#39;</span><span class="p">);</span> </span></pre></div> </td></tr></table>
email, mysql