Sql notater
From Teknologisk videncenter
Moodle
[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 3491
Server version: 5.0.67 FreeBSD port: mysql-server-5.0.67_1
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| wikidb |
+--------------------+
4 rows in set (0.02 sec)
mysql> CREATE DATABASE moodle;
Query OK, 1 row affected (0.02 sec)
mysql> ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; Query OK, 1 row affected (0.00 sec)
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES, DROP, INDEX, ALTER ON moodle.* TO moodleuser@localhost IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.02 sec)
mysql> quit
Bye
[root@sun /usr/local/www/data/moodle]# mysqladmin -u root -p reload
Enter password:
[root@sun /usr/local/www/data/moodle]#