 Trying To Make Phpmyadmin Work, Missing file or Missing line? |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.| Important Announcement: The winners of the BC Million Post contest have been announced. You can read who the winners are at this post. - BleepingComputer Management |
  |
 Mar 1 2007, 08:11 AM
Post
#16
|
|
 Forum Addict  Group: Banned Posts: 1,327 Joined: 18-October 06 From: Planet Earth Member No.: 90,873  |
no#1. Make sure you have Administration rights to the computer.. I assume you do. no#2. You need to have a password set for your computer. If not.. your problems will begin when trying to setup/run those services. no#3. You need to make sure your server is up and running before trying to install any other services, including phpmyadmin. no#4. There is a Unix version and a Windows version. If you have the Windows version, it'll work. If you have the Unix version, it won't work, since you're on Windows. no#5. When installing your Apache, you need not modify anything to get it to work. Allow it to install with the default information. You can always change it later, after it's up and running. You need to test your server by going to either of the 2 addresses below: http://localhost http://127.0.0.1 .. as a matter of fact,, clicking on any of the 2 links should bring up your Apache default page. If you can't get to your Apache default page using either of the 2 addresses above, then your server isn't setup correctly, and your server won't work, but your database would. If you do get the Apache default page once you've set it up, but still having problems installing the phpmyadmin, then chances are that you don't have your PHP configured correctly, and (or) you don't have your php.ini file in it's correct location and configured correctly. Tools I suggest you get, because you're going to need them anyway, plus they will help you with your servers and the configurations.... MySQL Administrator <------------------(you should have) MySQL System Tray Monitor <----------(you should have) MyODBC <--------------------------------(you should have) MySQL Query Browser <-----------------(useful for working with MySQL queries and databases) MySQL Migration Toolkit <---------------(useful for converting databases into MySQL format) You can get all of the above at: http://mysql.org/ but....... if you want to use a tool, in my opinion that is much better and easier to use than phpmyadmin, then you will want to download this FREE tool: DBManager Freeware/Standard Edition http://www.dbtools.com.br/ The program will install, and all you have to do is run it. There is nothing to configure, except the database name, username, password. You can run this AND phpmyadmin at the same time. But this one is easier, and more straight forward. phpmyadmin requires you to configure it in order for it to work, plus phpmyadmin is browser based, whereas this one is a GUI.. no browser needed. I've been using it for 3 years now, and I use it more than phpmyadmin. Once you install it, and if you still can't connect to your database, then you have not setup your server correctly. Also.... make sure you have your listening port set to port 80 in your Apache httpd.conf file. Using the MySQL Administrator, your port should be set to port 3306 on localhost Keep in mind:.. the initial thing is to get everything working as they should... at first.. but you can always make the changes later on, and phpmyadmin doesn't seem to be what the problem is. I may be missing something, but the above is very important to setting up your server, and getting it ready to use along with Privoxy, Vadalia, Tor services. This post has been edited by Walkman: Mar 1 2007, 08:16 AM -------------------- Walkman
One Man's Opinion "What I didn't know yesterday, I know today, and I'll remember it tomorrow" by Walkman |
 |
 
|
|
Mar 3 2007, 01:56 AM
Post
#17
|
|
 Senior Member  Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi Walkman, Thanks for the reply.
#1 [check] I do, #2 [check] it does, #3 [check] it is, #4 [check] that's a no brainer [unless you're blond], #5 [check] that's what I did. Getting Apache up and running wasn't problem. I let it set its self up like it wanted to but put it at C:\Apache as opposed to its chosen default of C:\Program Files then went through the httpd.conf file and made a few changes. When I got happy with the changes that I'd made I did the testing thing that you mentioned it it had worked so I was pretty sure that Apache was working right. That was all I had actually wanted to do but then while I was running around on the www trying to learn something about Apache I ran into a couple of different articles that mentioned using PHP, MySQL and phpMyAdmin in connection with Apache. So I followed some instructions and installed PHP and tested it with Apache. I guess the test was successful because I got a mile long page of facts about PHP just like the instructions had said I would. That said; I have got to say that I haven't got the slightest idea what PHP is supposed to do with Apache [but I'm trying to learn]. OK so those two things had seemed to be working right together so I went the next step and installed the MySQL Server. There wasn't any type of test laid out for MySQL so I took the next step and installed phpMyAdmin and that's where my troubles started. I have uninstalled MySQL, deleted phpMyAdmin and defragged my hard drive [since I started this thread] and reinstalled MySQL in an attempt to isolate my problem. When I reinstalled MySQL this time I didn't put in a root password and now I am able to access the MySQL Server and I've been able to get a couple of the commands listed in the reference manual to work so I'm thinking I did something right this time. Now I've got to figure out how to get into MySQL and put in a user name and set a root password. Thanks for the list of tool and the link to get to them. I'll be checking them out later but right now I want to get that password thing done and make sure that the MySQL Server is working right before I install phpMyAdmin again or do anything else. Why do you say --> make sure you have your listening port set to port 80 <-- I have got to agree with this too --> Keep in mind:.. the initial thing is to get everything working as they should... at first.. but you can always make the changes later on, and phpmyadmin doesn't seem to be what the problem is. <-- That's why I backed up a couple of steps here and am testing MySQL to be sure that it works and that I have a username and password in it that I can actually use. I'm now fairly sure that the bulk of my misery has been coming from MySQL and not from phpMyAdmin. Thanks for your time and help on this. Wendy -------------------- Democracy is what allows two starving wolves to sit down at the kitchen table, with a nice fat sheep, to discuss what to have for dinner. Freedom is what the sheep has because he has a gun.
Windows XP Home Edition SP 2 |
|
|
|
|
Apr 11 2007, 09:21 PM
Post
#18
|
|
 Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Hello Wendy, Sorry i haven't been about lately (satellite problems
 ) did you manage to get this problem resolved? Hopefully you did, but if you didn't let me know and we can continue. Oh and by the way I'm in South Australia  My humble apologies again..Cheers, Lucent. --------------------  Special thanks to efizzer for the signature |
|
|
|
|
Apr 11 2007, 10:06 PM
Post
#19
|
|
|
Forum Addict Group: Banned Posts: 1,327 Joined: 18-October 06 From: Planet Earth Member No.: 90,873 |
I'm still here too if you need further assistance.
[Added info] You may already know this by now, but since MySQL is a database server, and phpMyadmin is a database manipulator, you must have MySQL up and running 1st, because phpMyadmin needs to access the MySQL server in order to do anything. That's why I said I believed the phpMyadmin wasn't the problem. This post has been edited by Walkman: Apr 11 2007, 10:18 PM -------------------- Walkman
One Man's Opinion "What I didn't know yesterday, I know today, and I'll remember it tomorrow" by Walkman |
|
|
|
|
Apr 28 2007, 01:16 AM
Post
#20
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi lucent,
Thanks for the reply. Glad to hear that you are traveling down under, hope all is well there. No I haven't gotten any farther than I had been. I've had other things keeping me busy and I haven't had time to do any more studying on the matter so I just pushed it aside for now. I'll get back to it in the future though. Thanks for checking in. Hi walkman, Thanks for the offer of help. When I get back to it I'll let you guys know. Hey whats with you being in the Banned group? ♥ Wendy -------------------- Democracy is what allows two starving wolves to sit down at the kitchen table, with a nice fat sheep, to discuss what to have for dinner. Freedom is what the sheep has because he has a gun.
Windows XP Home Edition SP 2 |
|
|
|
|
Dec 17 2007, 04:38 AM
Post
#21
|
|
|
New Member Group: Members Posts: 1 Joined: 17-December 07 Member No.: 177,032 |
Hi All,
Have to say that i am in the middle of getting MyPHPAdmin to work. This maybe a bit late for Wendy but just thought i would share what knowledge i have learnt from trying to implement this myself. If and only if you need to reinstall MYSQL i found the following sequence to work:
Then i rebooted my system and reinstalled MYSQL and asked for a "new" root password for the database. I am still struggling with the same error: MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) and trying to configure config.inc.php file. Things i am confused about are:
other than that, I have to say thee discussion on this board about the subject has been excellent. Even though i can feel the frustration at not getting things to work as they seem to be documented. Gray |
|
|
|
|
Jan 6 2008, 05:47 AM
Post
#22
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi gray_ie, Thanks for the reply.
I hope that you have had more success with all of that than I have. I finally gave up and uninstalled\deleted everything. I'll give it another go in a few month, maybe it'll work for me then. Wendy -------------------- Democracy is what allows two starving wolves to sit down at the kitchen table, with a nice fat sheep, to discuss what to have for dinner. Freedom is what the sheep has because he has a gun.
Windows XP Home Edition SP 2 |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 21st November 2008 - 08:55 PM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.