I have been doing some reading in an effort to resolve the above issue so I can move on, however, I would really appreciate some clarification on some of what I am reading and a little help to fix the problem.
Firstly, some of the material I have read suggests the issue may be related to a config.php file in the moodle directory. Interestingly, that particular file does not exist until after the installation is completed. What I find really strange about the information is that it suggests that (in addition to that file), the user and database that was required during the procedure are only going to work if the software is being accessed directly on the machine on which it is installed. A different set of credentials (& perhaps another database) needs to be created if the software is to be used over a LAN and something different if it going to be accessed over the internet. Would someone please take a few lines in a post to clarify for me why none of this was pointed out in any of the documentation (including Moodle docs) and what was the purpose of creating the database and user during the MySQL install?
Secondly, I had a look at the file specified in the error and the actual line reads -
$conn = new mysqli($dbhost, $dbuser, $dbpass, '', $dbport, $dbsocket); // Connect without db
Are there any changes that should be made to this so that access to the created user would be able to access the created database?
Generally, I have been getting a number of calls from frustrated teachers who need an alternative to what they are being told to use by the Education Board in my country. It honestly is crap and they want to see if this is a better option (which I know it is). As such I am asking that those who know how to set up this platform give a hand. I can be beneficial to the entire community.