I have completed a fresh install of Moodle and unpacked phpmyadmin in the moodle folder. I can access phpmyadmin with the root password but the moodle database is not visible on the left even though the new site is working. What do I need to check to ensure that I can see the database?
This is really outside the scope of these forums, but ... some thoughts as to why this is a bad idea ...
- when you update/upgrade your moodle code, since you have phpmysadmin ... another application ... you will have to be aware of that and adjust what one normally does in updating/upgrading moodle.
- phpmyadmin gets updates from time to time ... I see scans on my moodle servers everytime there is an update to phpmyadmin ... so it's something you will have to watch/be aware of and update outside of Moodle.
- If you are on a dedicated hosted server, you should see the root user DB's ... those that control MySQL/MariaDB ... what DB's do you see?
If you are on a shared hosting plan and have cPanel, the DB's are created with a MySQL tool and the DB names have the account login as prefix to the DB names. No way to circumvent that - as you have discovered, me thinks.
Just for moodle, you will be better off installing a moodle plugin - Moodle Adminer.
That won't give you root level access to the DB's on server but will give you an interface into the DB for the moodle.
My 2 cents of course ...
'SoS', Ken
Thanks for the advice.
I am working on a dedicated VM running Windows server. It's a test server set up to get Moodle up and running.
I just did an unpack of the Moodle for Windows package which comes with XAMPP and ran 'Start Moodle.exe' and installed the site. I added phpmyadmin afterwards as it is not included.
I'm just confused why I can't see the 'moodle' database.
I can only see information_schema, mysql and performance_schema.
I need root access as I need to import a 'moodle' backup from another server.
I am working on a dedicated VM running Windows server. It's a test server set up to get Moodle up and running.
I just did an unpack of the Moodle for Windows package which comes with XAMPP and ran 'Start Moodle.exe' and installed the site. I added phpmyadmin afterwards as it is not included.
I'm just confused why I can't see the 'moodle' database.
I can only see information_schema, mysql and performance_schema.
I need root access as I need to import a 'moodle' backup from another server.
I tried Moodle Adminer and it also doesn't show the moodle database. Could this be a port issue?
Don't use the Moodle for Windows package for a server. This is for testing on a local computer only; not for production. If you are planning on using this Windows Server VM for a production Moodle instance you are far better off installing the components manually to set up your web server, PHP and MySQL/ MariaDB separately...
If you spawn a VM anyway, why not Linux? The Debian gang (including Ubuntu server) and the RedHat faction (including AlmaLinux, etc.) are well represented here. And also well documented. See Installing Moodle.
True. There are very few persons who run their production Moodle on Windows - especially using a package that was designed for localhost testing only.
+ 20 to what others have said already - major difference in total environment, and one would be better off cloning the production site to another instance on same server (Linux based) for testing purposes.
Take the path of least resistance!
'SoS', Ken
OT - @Mr. V ... Maybe it is ... if using the 'right platform'!
@OP two more suggestions
Install your test instance using git.
https://docs.moodle.org/404/en/Git_for_Administrators
or if using Ubuntu ..
https://docs.moodle.org/404/en/Installation_on_Ubuntu_using_Git
Also install the cli only 'Swiss Army Knife' for Moodle called moosh.
https://moodle.org/plugins/view.php?id=522
'SoS', Ken