CentOS Linux Server Installation , FAQ, Tips and Tricks

Install Moodle2.x on Centos 5.5

Create MySQL database, Grant Privileges and convert MySQL database to utf8 unicode

Step1: Login to mysql

mysql -u root -p

Step2: Create moodle database

create database moodledb20;

Step3: Grant privileges to moodledb20. Note: moodledbuser is my moodle database admin

GRANT ALL PRIVILEGES ON moodledb20.* TO 'moodledbuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Step4: This is optional, because my database is not qualified for Moodle 2.x. I need to convert my moodledb to utf code

ALTER DATABASE moodledb20 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Step5: Refresh database roles

FLUSH PRIVILEGES;

Step6: Verify database

Show databases;

Back to Moodle Installation on CentOS Linux

CentOS Server Guide by http://www.1a-centosserver.com is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

All trademarks are the property of their respective owners.