Difference between revisions of "Sql notater"
From Teknologisk videncenter
m (New page: = Moodle = <source lang="sql"> [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...) |
m |
||
Line 33: | Line 33: | ||
[root@sun /usr/local/www/data/moodle]# | [root@sun /usr/local/www/data/moodle]# | ||
</source> | </source> | ||
+ | [[category:sql]] |
Latest revision as of 16:19, 2 April 2009
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]#