http://mars.merhot.dk/w/index.php?action=history&feed=atom&title=Sql_notater 2026-05-15T10:08:03Z Revision history for this page on the wiki MediaWiki 1.29.0 http://mars.merhot.dk/w/index.php?title=Sql_notater&diff=3203&oldid=prev 2009-04-02T15:19:16Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 15:19, 2 April 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l33" >Line 33:</td> <td colspan="2" class="diff-lineno">Line 33:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[root@sun /usr/local/www/data/moodle]#</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[root@sun /usr/local/www/data/moodle]#</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&lt;/source&gt;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[category:sql]]</ins></div></td></tr> </table>

Heth http://mars.merhot.dk/w/index.php?title=Sql_notater&diff=3027&oldid=prev 2009-03-29T10:07:35Z

<p>New page: = Moodle = &lt;source lang=&quot;sql&quot;&gt; [root@sun /usr/local/www/data/moodle]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is...</p> <p><b>New page</b></p><div>= Moodle =<br /> &lt;source lang=&quot;sql&quot;&gt;<br /> [root@sun /usr/local/www/data/moodle]# mysql -u root -p<br /> Enter password:<br /> Welcome to the MySQL monitor. Commands end with ; or \g.<br /> Your MySQL connection id is 3491<br /> Server version: 5.0.67 FreeBSD port: mysql-server-5.0.67_1<br /> <br /> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br /> <br /> mysql&gt; SHOW DATABASES;<br /> +--------------------+<br /> | Database |<br /> +--------------------+<br /> | information_schema |<br /> | mysql |<br /> | test |<br /> | wikidb |<br /> +--------------------+<br /> 4 rows in set (0.02 sec)<br /> mysql&gt; CREATE DATABASE moodle;<br /> Query OK, 1 row affected (0.02 sec)<br /> <br /> mysql&gt; ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; Query OK, 1 row affected (0.00 sec)<br /> <br /> mysql&gt; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES, DROP, INDEX, ALTER ON moodle.* TO moodleuser@localhost IDENTIFIED BY 'secret';<br /> Query OK, 0 rows affected (0.02 sec)<br /> <br /> mysql&gt; quit<br /> Bye<br /> [root@sun /usr/local/www/data/moodle]# mysqladmin -u root -p reload<br /> Enter password:<br /> [root@sun /usr/local/www/data/moodle]#<br /> &lt;/source&gt;</div>

Heth