On my hosted Moodle I can get to the database with phpmyadmin and I am just a tiny bit beginning to get my head around this. How do I get to the database in a local install? I can see all the folders and the tables and a folder that says sql and one that says phpmyadmin -but after that I am lost? I want to replicate what I did on the online one but can't see where to/how to
Go here to download the latest PHPMyAdmin http://www.phpmyadmin.net/home_page/downloads.php then hopefully this doc should help you get it setup: http://www.phpmyadmin.net/documentation/#quick_install
Personally I prefer typing "sudo apt-get install phpmyadmin" on Ubuntu but there you go
Jon
Personally I prefer typing "sudo apt-get install phpmyadmin" on Ubuntu but there you go
Jon
This one looks quite good too... http://www.trap17.com/index.php/installing-phpmyadmin-local-machine-windows_t63977.html
Well -I failed on the first hurdle - tried this one http://www.trap17.com/index.php/installing-phpmyadmin-local-machine-windows_t63977.html
and it said extract to htdocs -where's that? Do they mean in my moodle folder? in the server folder? Or in one of the folder within there?
and it said extract to htdocs -where's that? Do they mean in my moodle folder? in the server folder? Or in one of the folder within there?
Hi Mary,
XAMPP for Windows comes with phpmyadmin so there should be no need to install it again. I don't know why http://localhost/phpmyadmin/ doesn't work for you. Perhaps you can ask for help in the Apache Friends Support forum discussion PhpMyAdmin is unreachable.
XAMPP for Windows comes with phpmyadmin so there should be no need to install it again. I don't know why http://localhost/phpmyadmin/ doesn't work for you. Perhaps you can ask for help in the Apache Friends Support forum discussion PhpMyAdmin is unreachable.
Ok -I have definitely missed something out somewhere - I deleted my last install and started all over again:
Moodle 2 dev package - extracted it
clicked on start moodle.exe
just agreed to whatever it said, added my details, password etc
I now have a working Moodle 2 again on local host
but the phpmyadmin is still object not found
was I meant to do something in addition to all this?
(yes, I know - I should have read up on it but I like to just dive straight in!)
Moodle 2 dev package - extracted it
clicked on start moodle.exe
just agreed to whatever it said, added my details, password etc
I now have a working Moodle 2 again on local host
but the phpmyadmin is still object not found
was I meant to do something in addition to all this?
(yes, I know - I should have read up on it but I like to just dive straight in!)
Mary - you have not missed anything...
Moodle 2 is using a modified folder structure for files of XAMPP in complete Windows package.
I have used myself in my local Windows Vista (test PC) the original XAMPP found from http://www.apachefriends.org/en/xampp-windows.html
(easy to use installer package) and standard packages from moodle.org (not complete packages). Using that original XAMPP phpmyadmin is found from http://127.0.0.1/phpmyadmin/ or http://localhost/phpmyadmin and the usual place for XAMPP is C:\xampp (then localhost is in C:\xampp\htdocs)
In complete packages modified versions of phpmyadmin used to be found from administration menu (server...) but I have not checked if it still is there in moodle 2.0.
Htdocs is the standard Apache document root. In a Xampp install, the root is usually changed to path/moodle, in mine it reads:
DocumentRoot "G:/Moodle20/server/moodle"
This is about line 178 in the httpd.conf file.
Just reading your comments here, Mary et. al. got me curious so I downloaded and installed the Xampp installation, installed it and have been looking at it. It looks like the phpMyAdmin is not present, in my download, but it is hard to tell, it does not appear in the moodle/admin folder and have not found it anywhere under the phpMyAdmin foldername. There is a phpMyAdmin.css.php file in the mySQL folder in moodle/Admin.
However, it seems to be present as the database is displaying as it should when I click the database link. Clearly it has been more thoroughly integrated than in 1.9. But, having said that, it may be possible that it is accessing it from the 1.9 install, there is no return header in the top frame of the phpMyAdmin window.
If you want access to the tables direct, then in
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\(databasename)=mdle2
(mdle2 was the name of the database I used to not interfere with my 1.9 installations.)
Good luck with it..
DocumentRoot "G:/Moodle20/server/moodle"
This is about line 178 in the httpd.conf file.
Just reading your comments here, Mary et. al. got me curious so I downloaded and installed the Xampp installation, installed it and have been looking at it. It looks like the phpMyAdmin is not present, in my download, but it is hard to tell, it does not appear in the moodle/admin folder and have not found it anywhere under the phpMyAdmin foldername. There is a phpMyAdmin.css.php file in the mySQL folder in moodle/Admin.
However, it seems to be present as the database is displaying as it should when I click the database link. Clearly it has been more thoroughly integrated than in 1.9. But, having said that, it may be possible that it is accessing it from the 1.9 install, there is no return header in the top frame of the phpMyAdmin window.
If you want access to the tables direct, then in
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\(databasename)=mdle2
(mdle2 was the name of the database I used to not interfere with my 1.9 installations.)
Good luck with it..
Sorry, my assumption was that you were using an XP laptop. duh!!!
OK, if you can see a database link in the Site Administration > Server > Database then phpMyAdmin is installed. If you cannot then phpMyAdmin is not installed.
Assuming that php is connectionless and there does not need to be any specialized installation process of a plugin, then you should be able to install phpMyAdmin into your Moodle 2.0.
You can download it from Modules and Plugins, and install it simply by unzipping it to the moodle/admin folder. You should then see the Site Administration > Server > Database link.
EDIT: Well, that is how it has worked for me in the past, but my new Xampp/Moodle2.0 install looks like it has it native.
OK, if you can see a database link in the Site Administration > Server > Database then phpMyAdmin is installed. If you cannot then phpMyAdmin is not installed.
Assuming that php is connectionless and there does not need to be any specialized installation process of a plugin, then you should be able to install phpMyAdmin into your Moodle 2.0.
You can download it from Modules and Plugins, and install it simply by unzipping it to the moodle/admin folder. You should then see the Site Administration > Server > Database link.
EDIT: Well, that is how it has worked for me in the past, but my new Xampp/Moodle2.0 install looks like it has it native.
I've installed it on a Vista laptop .
Right - now I am totally confused -I went to site admin>server>database
and there is my phpmyadmin that I understand (sort of) that I have been looking for all over elsewhere - what's it doing in there?? I think I'll give up on this Moodle lark -it's too complicated
oh and this is the url http://localhost/admin/mysql/frame.php
Anyway.. now I know where it is, I can break my Moodle 2 again!
Right - now I am totally confused -I went to site admin>server>database
and there is my phpmyadmin that I understand (sort of) that I have been looking for all over elsewhere - what's it doing in there?? I think I'll give up on this Moodle lark -it's too complicated
oh and this is the url http://localhost/admin/mysql/frame.php
Anyway.. now I know where it is, I can break my Moodle 2 again!
Always good practice to break it, then spend time fixing it...
Have a look in the top part of the frame, mine did not display the link back to the front page.. real odd..
Where do I post comments and complaints and such about Moodle 2.0, btw..?
Have a look in the top part of the frame, mine did not display the link back to the front page.. real odd..
Where do I post comments and complaints and such about Moodle 2.0, btw..?
Mary, glad to hear you found phpmyadmin eventually! Perhaps the documentation MySQL Admin explains why you found it where you did.
Colin, please post comments etc about Moodle 2.0 in the Testing and QA forum (apart from obvious bugs which should, as always, be added to the Moodle Tracker).
Colin, please post comments etc about Moodle 2.0 in the Testing and QA forum (apart from obvious bugs which should, as always, be added to the Moodle Tracker).