Installation - Reg
Title
Question
While installing moodle in Windows platform the following error occur in database page
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'moodle-st'@'localhost' (using password: YES) in C:\\\\Moodle\\\\server\\\\moodle\\\\lib\\\\dml\\\\mysqli_native_moodle_database.php on line 79
Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'moodle-st'@'localhost' (using password: YES) in C:\\\\Moodle\\\\server\\\\moodle\\\\lib\\\\dml\\\\mysqli_native_moodle_database.php on line 79
Kindly support for overcoming this error as soon as possible
Moodle-Learning-Management-System Installing-Moodle-on-Local-Server 00-01 min 0-10 sec
Answers:
This error occurs commonly, if you are using default username "root" and empty password for mysql connectivity, Create separate user name and password for moodle database and grant all privileges the moodle database for that user.
Refer following query to create users and granting privileges.
1. CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
2. GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'localhost';
Login to add comment