I installed my Moodle server from straight download and "standard" install on top of XAMPP 1.4.5 for windows.
Yes, Floyd Collins and Daryl Hawes have compiled a Moodle 1.4+ with Xampp.
You can find the download at http://goohio.com/moodle/
Go into phpMyAdmin and select the mysql database from the drop down list. When that loads, select the user table , then click on browse. You should see the moodle user you created in the list. If so, go on. If not, stop here. You'll need to recreate the user. Post here and someone will explain how to go about this (note: the entry in the user table doesn't need any privileges, those are given in the db table below).
If the user is in fact in the user table, click on the db table in the left-hand frame. Again click on browse. You should see an entry that looks similar to:
Db: moodle (or whatever name you gave the moodle database)
User: moodleuser (or whatever name you gave your moodle user)
This entry should have all privileges EXCEPT grant, references, create tmp table, and lock tables.
Again, if you don't see the entry, stop and post again.
Tom I can get into the database with the user I created. I am using a Mysql administrator call Navicat. It lets me connect to and see all the tables in the moodle db as the moodleuser.
The problem is my moodle configuration setup use the root user to connect to the Mysql db and install and setup the moodle tables. I am running the installation of moodle fine. I can login as admin. I looked in the moodle directory on the server and did not see a config.php. Is this file stored somewhere else after installation? Does moodle use this file to restart? How can I change it now to the moodleuser instead of root.
It should be there unless the XAMMP package is doing something decidedly odd.
Make sure you're looking in the web directory where all the moodle php files are located and not the moodle data directory.