WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] XAMPP phpMyAdmin login info ?? (43 posts)

  1. BillyG
    Member
    Posted 8 years ago #

    Hi. I just downloaded, installed and have the Apache & mysql services running on my box but even though I am looking at the ID & PW in the WinMySQLadmin .ini file (that came with XAMPP), those are not working for me when trying to login to phpMyAdmin as discussed 3/4's of the way down this page:
    http://www.tamba2.org.uk/wordpress/xampp/.

    I have been to their homesite (http://www.phpmyadmin.net/home_page/index.php) as well as to Sourceforge for questions but have never heard back from either one of them. Surely there is an easy way to get into phpMyAdmin that I'm just not aware of, can someone help me out here? TIA.

    Oh yeah, I haven't heard back from the XAMPP people either so 3 strikes, I'm out lol.

  2. BillyG
    Member
    Posted 8 years ago #

    I reloaded everything, apparently my FF cookie was pulling something else in that wouldn't work... I uninstalled, reloaded and can now get in. Thx anyway.

  3. BillyG
    Member
    Posted 8 years ago #

    (Please disregard the earlier two statements this thread, but I still can't get my WP blog up in XAMPP)

    No matter how many times I do it according to the instructions here http://www.tamba2.org.uk/wordpress/xampp/, when I load the URL they mention: http://localhost/wordpress/wp-admin/install.php, all I get is a 404 NOT FOUND.

    I am using this in the config file because that is what we are told to use (and because it is the only login info I have anyway):

    define('DB_NAME', 'wordpress'); // The name of the database
    define('DB_USER', 'root'); // Your MySQL username
    define('DB_PASSWORD', ''); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

    As usual, any help is appreciated since I just wasted the better part of 24 hrs trying to install WAMP on my machine individually (not even wanting to get to the part where I would have to load the WP tables to mySQLAdmin lol) so while XAMPP certainly sounds alot easier, all I get is a 404 when doing what the instructions say.

  4. MichaelH
    Member
    Posted 8 years ago #

    So xampp is running successfully on your box, good!

    Your WordPress folder is where? On my machine it's here:
    c:xampphtdocswordpress

    I can get into xampp and ultimately phpMyAdmin with this:
    http://127.0.0.1/xampp/index.php

  5. vkaryl
    Member
    Posted 8 years ago #

    I've always accessed phpmyadmin as "localhost/phpmyadmin/" in the browser addy bar (no quotes around string). My username has always been "root" (no quotes), and at first you'll get an error message about root with no password; use the available tools in phpmyadmin to set a password for root to use from then on....

  6. BillyG
    Member
    Posted 8 years ago #

    I can get into phpMyAdmin fine now but I'm trying to get my WP blog up, which is why I posted all the login info but if you want to point me to where I need to go to for direction on loading the WP tables to the XAMPP mySQLAdmin db I created, that would be great too (for use after I finally get WP up lol). Basically, I'm trying to use XAMPP to get my blog up but the sparse directions at the site I mentioned above don't nearly cover enuff for my thick head (especially when doing it gives me a 404). TIA

  7. vkaryl
    Member
    Posted 8 years ago #

    All you should have to do at this point then is put "localhost/path*to*wp/wp-admin/install.php" in the browser addy bar....

  8. BillyG
    Member
    Posted 8 years ago #

    damn that sounded so good when you said it too, I was making up your dinner order...

    I tried this but no joy, still getting 404 (it added the %20)

    http://localhost/Program%20Files/xampp/htdocs/WP2.0/wp-admin/install.php

    and yes, the localhost link at the bottom takes me to the XAMPP screen which is fine but...

    I took XAMPP's default settings, everybody has a space between Program and Files so ??

    How is your's set vkaryl?

    EDIT: attempting move to my root now...

    no joy here either

    http://localhost/xampp/htdocs/WP2.0/wp-admin/install.php

    any suggestions? already way passed the site description but I'd just be happy to get it working

  9. moshu
    Member
    Posted 8 years ago #

    Normally it should be:
    http://localhost/WP2.0/wp-admin/install.php
    supposed WP is installed in a directory "WP2.0" - not sure the dot in the folder name is a healthy thing, though. I always avoid that kind of names, and use things like "wp_20".

  10. vkaryl
    Member
    Posted 8 years ago #

    Weeeelllll.... as per normal, I don't ever do things "normally"....

    XAMPP is installed where it wanted to install 5 years ago or so: c:\apachefriends\xampp\xampp\. I tried once to move it, it borked, I put it back.

    Only thing I use it for is designing websites, and that's the whole of my e:\ drive, so I don't use htdocs.

    So server root is c:\ (the entire drive, just in case - at one point in the intervening years, I had to change it to that to make it work, so I've never changed it back [if it ain't broke DON'T FIX IT!]) and my document root is e:\. My httpd.conf file is vanilla - I didn't have to do anything to it.

    I don't think that's going to help you much. And since I don't have a setup like yours, I doubt I've much more info you can use.

    Did you dig around on the English forum at apachefriends? There could I suppose be something you need to customise in the httpd.conf file....

  11. BillyG
    Member
    Posted 8 years ago #

    <EDIT>: I didn't see English the other day (and still haven't heard back from them, will go back now, ARGH! Thx for trying guys. (I wish the tamba site was current and correct, after all, I'm just doing what it said)<EDIT>

    But how does that reference XAMPP at all Moshu?

    anyway, I tried this and still get a 404 (after changing folder name)

    http://localhost/WP/wp-admin/install.php and
    http://localhost/wordpress/wp-admin/install.php

    (which is exactly how they have it on their website, no joy)

    EDIT: guess I didn't go far enuff down when I kept seeing non-English, typical American lol

    http://www.apachefriends.org/f/

  12. Mark (podz)
    Support Maven
    Posted 8 years ago #

    I wrote that xampp stuff so I'll take the blame :)

    Can we go back to the start ?
    C:/xampp/htdocs/wordpress/
    is where you have all your files ?
    and they follow as such:
    C:/xampp/htdocs/wordpress/index.php
    C:/xampp/htdocs/wordpress/wp-content/
    C:/xampp/htdocs/wordpress/wp-admin/
    C:/xampp/htdocs/wordpress/wp-includes/
    and a lot of other files.
    Is that correct ?
    Or are you certain that you have the wordpress folder inside the htdocs folder ?

  13. vkaryl
    Member
    Posted 8 years ago #

    You have to tell apache where to find server root and doc root - in the httpd.conf which is found in the xampp\apache\conf folder. MAKE A BACKUP OF IT before you edit it!

    (I should have said above that the only changes I made to httpd.conf were server root and document root - sorry for that bit of misinfo....)

    About line 57, find:

    ServerRoot "0:/apache" [this is what my default one shows, yours may vary]

    Change this to read:

    ServerRoot "wherever apache is installed" [in my case, this is ServerRoot "c:/"]

    Around line 228 find:

    DocumentRoot "O:/apache/htdocs" [same caveat entered above]

    Change it to read:

    DocumentRoot "entire path to wherever your htdocs is" [mine reads DocumentRoot "e:/AWebsites" - as I said, I'm not "normal", but fortunately apache doesn't care....]

  14. BillyG
    Member
    Posted 8 years ago #

    podz, everyway I posted above is the way I tried it at that time, including http://localhost/xampp/htdocs/WP2.0/wp-admin/install.php

    but no matter now, I deleted it all and uninstalled (in case renaming wp2.0 to wp then wordpress (as tamba suggest) may have screwed up my linkage, I was ready to fish their forum when I came back to let vkaryl know I found the English part but since I'm here, I'll read this first...

    read it, starting over podz, planning on putting at root, just like you have in your post (although I don't recall the option for me to edit, will check)

    vkaryl, thx will use your tips too of course

    I already have the zips so if I shouldn't attempt the root location, let me know podz Thx both.

  15. Mark (podz)
    Support Maven
    Posted 8 years ago #

    Installing to C: is fine - the screenshots you see are from when I did my install.

    You can get all the way to this part of the guide:
    "After you have clicked your language and entered the program, click phpMyAdmin."
    and after that it all goes wrong ?

    You can always download the 29meg Installer version and unzip that to C:

    It doesn't have to be at root though - almost anywhere will do, so long as you put your files into the 'htdocs' directory.

  16. BillyG
    Member
    Posted 8 years ago #

    truthfully, I wasn't even looking at your screenshots, just following the install instructions

    I was using the full package though, not the LITE version which I wouldn't think would affect anything

    my problem is come WP install time after creating the db (with no tables in it, so how do they get created?), yes I put the wp folder inside the htdocs folder but all I get is a 403 coming out... I need to incorporate V's tips though and see if that helps, was waiting for anything else you might have to add, thx so much guys, gotta go get some Friday night sushi with my wife, my fav, peace!

    btw: last look at my bloglines account, I was at 900+ feeds unread, I'm not even going there until I get this straight once and for all, meaning I am my own host!

    Vkaryl, just tried to leave a msg in the "English" section but all the instructions are french or whatever lol... besides, they never did answer my registration request ARGH, love the support lol, oh yeah sushi, l8tr

  17. vkaryl
    Member
    Posted 8 years ago #

    Well, enjoy your sushi! But you don't have to do anything with tables, wp does that itself during install....

  18. BillyG
    Member
    Posted 8 years ago #

    too much sushi lol

    went to apply your changes to the httpd.conf and they were already set correctly on lines 42 & 176 but that did remind me to make the change that podz mentions in his last panel on the tamba site (see above) while I'm here (thx podz, I did read those bottom panels, over & over again lol).

    fyi: my XAMPP 2.1 as of today (although their README version below needs to be updated apparently) and this is the full package, misleading cause basic means not LITE, their other package, but then they have a add-ons package also, which adds Perl components.

    ApacheFriends XAMPP (basic package) version 1.5.1

    + Apache 2.2.0
    + MySQL 5.0.18
    + PHP 5.1.1 + PHP 4.4.1-pl1 + PEAR
    + eAccelerator 0.9.4-rc1
    + PHP-Switch win32 1.0 (from Apachefriends, use the "php-switch.bat")
    + XAMPP Control Version 2.1 from http://www.nat32.com
    + XAMPP Security 1.0
    + SQLite 2.8.15
    + OpenSSL 0.9.8a
    + phpMyAdmin 2.7.0 pl1
    + ADOdb 4.68
    + FPDF 1.5.3
    + Mercury Mail Transport System v4.01b
    + FileZilla FTP Server 0.9.11
    + Webalizer 2.01-10
    + Zend Optimizer 2.6.0

    good thing is, the first 3 items are very current as of my individual downloads just yesterday :-)

    okay, changes made, images folder brought into the htdocs folder along with an index.html for a non-WP site I have, so now, somehow WP creates the tables?? this is where I get lost, wish me luck, will post back...

  19. BillyG
    Member
    Posted 8 years ago #

    E:\Program Files\xampp\htdocs\WP\wp-admin\install.php tweaked for the install to http://localhost/Program%20Files/xampp/htdocs/WP/wp-admin/install.php didn't work (%20 happened after hitting <enter>), yes Apache is running, gonna reboot for giggles and look at the MySQL & PHP settings

  20. BillyG
    Member
    Posted 8 years ago #

    As usual, going back, reading what Moshu said earlier, and doing http://localhost/wp/wp-admin/install.php, worked... well almost. I had to install the MySQL ODBC Connector file from Microsoft that I already had from my MySQL escapades 2 days ago, add some ports to the Windows FW, and several XAMPP FAQ setting tweaks but that was the correct URL, thx again Moshu). I am finally seeing the WP screen but it's telling me I'm not connected to the db. This is with using the default settings as per the tamba site:

    define('DB_NAME', 'wordpress');
    define('DB_USER', 'root');
    define('DB_PASSWORD', 'PASSWORD');
    define('DB_HOST', 'localhost');

    My 3 XAMPP services are running, Apache, MySQL, & ftp so now I guess I need to investigate my db connection problem, just updating.

  21. Mark (podz)
    Support Maven
    Posted 8 years ago #


    define('DB_PASSWORD', '');

    ?

    Are you XP pro ?

  22. BillyG
    Member
    Posted 8 years ago #

    no XP Home, I've been looking but haven't seen anything saying I couldn't use XAMPP with XP Home..

    but I just came back to let you know that, at least with the XAMPP full-package download as of today (version 2.1), using the last panel you have on the tamba site (to enable permalinks) definitely prevents Apache from starting

    I had it running, turned it off to make the file change, and it wouldn't turn back on, I put the file back as orig, and Apache turned on. I went thru 3 uninstalls this morning taking away one tweak at a time before I finally got to this one just now. Not yelling or anything lol, just learning as I go.

    Unless I find a workaround for that, and the fact that I haven't gotten pics to display that are on my own site (with an images folder inside htdocs also, just like WP), there really isn't any reason for me to use this setup. I'm assuming others that are using it now do have permalinks and do display pics so I 'll keep messing with it. I did see in their FAQ a specific statement about pics earlier so now that I know what was causing Apache to not start again, I'll try that tweak. (mid-way down this page: http://www.apachefriends.org/en/faq-xampp-windows.html)

    the problem is their forum is in French, even though they have an English section, I never recv'd an answer when registering for it and once you get past the front page of English questions, you get French answers, I don't have time for French lessons lol

  23. BillyG
    Member
    Posted 8 years ago #

    turns out any changes I make to the httpd.conf prevent Apache from starting back up (because I turn it off to edit the file first), sounds like I just wasted a bunch of hours for nothing

    just curious: I can see my non-WP site thru XAMPP because it is an index.html inside the htdocs folder (even though I don't see the pics lol) and since I can plug in outside-world URL to display the site and the pics appear, I know that i am not affecting anything on the outside so what good is XAMPP for anyway? I know they recommend you don't use it for production (which of course I was going to try to do anyway), but if it doesn't push anything off my machine, what's the use? I don't know if I still don't have something right with my box interacting with the XAMPP software or if it really never leaves anyway, can an XAMPP WP user please clear this up for me? TIA. Other than that, I'm done this thread.

  24. vkaryl
    Member
    Posted 8 years ago #

    I use a local apache server for viewing site design in IE for one thing (I NEVER access the 'net with IE, so local server is my only option).

    I also never "turn apache off" to edit httpd.conf. It's enough to simply stop then restart apache once the edits are done.

  25. BillyG
    Member
    Posted 8 years ago #

    maybe I'm just getting too tired, but I don't understand your last...

    Does the first sentence mean you don't push anything thru XAMPP to the web??

    Your second sentence, that's what I mean, I was doing a stop, edit, and try to start but with the edits in place, it wouldn't start back up, so I took the edits out, and then it Apache restarts when I hit the start button from the control panel. Are you saying you don't stop it at all in the 2nd sentence? But then you say you stop it so I'm confused AND VERY TIRED LOL.

    If you could tell me whether or not any changes you make to your site go thru XAMPP to the web, that would really help. Basically, are you paying for a host (unless of course you have a sweet deal with one), or are you using a physical server of your own? I should've asked this in the beginning but I assumed that you act as your own host with XAMPP, but when I have Apache running and I see my site thru XAMPP (with the localhost or 127.0.0.1 address), it is not the same as what is live on the net now (because the pics aren't pulled in) so at that point, I had to ask myself what all this was for (unless I still don't have something right). TIA. dazed and confused

  26. vkaryl
    Member
    Posted 8 years ago #

    I'm a reseller for a great host provider. I run my management sites and my own sites on the reseller partition. No I don't push anything "through XAMPP" to the web; I use WS_FTP Pro to upload to web space. I simply use apache locally to view pages with includes etc. which can't be done without a server, and to run php programs locally while developing.

    As to editing httpd.conf, here's my process: open file in notepad2; make changes, save file; stop apache; restart apache.

    There's a thread around here somewhere in the last few days from a guy who is apparently doing what you thought you were doing. Let me see if I can find it; I'll post back.

  27. vkaryl
    Member
    Posted 8 years ago #

    Okay, look over this thread, it may have some further thoughts for you:

    http://wordpress.org/support/topic/56590?replies=15

  28. Mark (podz)
    Support Maven
    Posted 8 years ago #

    I have and use xampp purely as a way to play with code on my machine. It IS possible to run your blog to the net using xampp but there are security issues you need to take care of first. There are also potential problems with any referencing of stylesheets / images.

  29. BillyG
    Member
    Posted 8 years ago #

    that would be awesome!

    "what you thought you were doing" LOL EXACTLY

    pardon me if I don't get back until this evening or so, I gotta crash, thx again.

    fwiw: I just can't understand all the work that was put into this awesome package only to be used for a local version for testing, etc., my mind says there has to be more to it than that... out

    EDIT: yes podz, I found out about the images but my non-WP site is definitely grabbing the stylesheet from the htdocs folder that I put in it (but not the pics) but it is different than what I have live so...? I made several security edits, that's what I was doing all morning, finding out what I could do and not do... i just haven't found out yet how to push it thru to the net.

    got it V, thx again

  30. flammobammo
    Member
    Posted 8 years ago #

    BillyG,

    I have used XAMPP and WP running from my computer for six months, regularly updating both. I used the automatic installer for XAMPP, using all the default directories. It's worked successfully all the time, and I've never had any troubles (apart from right now I'm offline for a week whilst I change ISP's). I use dyndns.org for a domain name with my dynamic IP address, and to cloak transfer other domains for other web sites I run also. I'm not sure how I can be of any help to you, and how the thread you recently posted in is relevant, but I can tell you it all works well!

    I use SyndBack (free synchronisation software) to automatically backup my website(s) at regular intervals, which automatically stops the xampp/apache/mysql services whilst copying files, and reboots the computer when finished, so I've always got a backup copy at hand. Every couple weeks I transfer this backup to a portable hard drive in case of a power surge / theft, etc. Ideally I should store this drive off-site.

    All in all, I do recommend you run your blog off your computer like myself (providing you don't mind running it 24/7), but as for the lack of security with XAMPP that's something I'd like to find out more about. All I can tell you is it's so much more convenient as a novice web programmer to be able to work on your site from your computer, without having to use FTP, and the hassle's associated with using a web host provider.

    Cheers,
    Tom

Topic Closed

This topic has been closed to new replies.

About this Topic