This is my note on how to prepare for installation moodle in centos 5 ..
via command prompt MySQL command.
1. Enter MySQL command prompt with password :
mysql -u root -p
2. Create Blank database.
mysql> create database edu_namran;
Query OK, 1 row affected (0.05 sec)
3. Verify database.
mysql>show databases;
4. create a user
mysql> create user 'someuser' @'localhost' IDENTIFIED BY 'somepass';
Query OK, 0 rows affected (0.06 sec)
5. grant user access to db
mysql> GRANT ALL on edu_namran.* to 'someuser'@'localhost';
Query OK, 0 rows affected (0.04 sec)
6. verify :
[root@fedora html]# mysql -u edunamran -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 147
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| edunamran_db |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use edunamran_db;
Database changed
mysql> show tables;
Empty set (0.00 sec)
7. check the required packaged .. before installing
yum install php-mbstring php-xmlrpc
Your machine might already have these package.
And if you're on someone else hosting with cpanel and all..
you might want to get administrator help to get this package added to the machine.
But it was kinda optional, will work without these also.Only a bit optimization advantage if these packages are installed.
8. then.. just proceed with the install.php interface under admin section..
Reference :
1. http://www.debuntu.org/how-to-create-a-mysql-database-and-set-privileges-to-a-user
Here are five key communication skills that help you speak with clarity and influence: Speak…
Are you ready to unlock your full potential as a man?Discover powerful insights, real-life transformations,…
One day we will set aside one whole day to review the whole lesson we…
Last weekend, 07/12/2024 I managed to join Dev Fest Kuala Lumpur 2024, organized by Google…
TIPS BACAAN AL-QURANOleh: Dr. Muhd al-Muhaysni.1. Jangan engkau berikan (fokus membaca) al-Quran pada lebihan waktumu…
Selawat yang ringkas, yang mana apabila kamu membacanya satu kali sebanding 100 ribu kali, jadi…
Leave a Comment