![]() Remember the username and password you have set, as you'll need it in the configuration screens later. It's a good idea to change these for your installation however most people keep the username as "moodleuser". We'll call the user "moodleuser" and set the password as "yourpassword". Create a username and password to access the database "moodle" and grant database access permissions.Mysql> ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci Query OK, 1 row affected (0.00 sec) Leave this out if you are installing Moodle 1.5 or earlier): Change the default character set and collation of the "moodle" database to UTF8.Mysql> CREATE DATABASE moodle Query OK, 1 row affected (0.00 sec) We'll call this "moodle", as there are none with that name already in the above list, but change it if you need to. Create a database to store the Moodle tables.Begin by checking for any existing databases called "moodle" - if there are any you should change the name in all the commands which follow:.(If you hit the Enter key without the final semi-colon, you'll get the line continuation symbol '->' this is your second chance to type the semi-colon and hit Enter.) When working in MySQL, all commands which you type-in must end in a semi-colon. Note: The prompt changes to "mysql>" to indicate that you are now working in the MySQL Client program. Your MySQL connection id is 2 to server version: 5.0.22-log # mysql -u root -p Enter password: MartinMoodle Welcome to the MySQL monitor. In Linux, here are some command line prompts using a MySQL Client program (commands which you type-in are shown in bold): See the create the MySQL database section in the XAMPP installation page. Tip: Be sure that it includes one of the UTF standard formats for Moodle 2.x. ![]() If you have access to phpMyAdmin you can use this program to create an empty database which the Moodle Installer will then populate with its tables. 6 Caution- be aware of Moodle version requirements.
0 Comments
Leave a Reply. |