 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 |
  |
 Feb 17 2007, 03:00 PM
Post
#1
|
|
 Senior Member  Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107  |
I'm trying to get phpMyAdmin to work and I'm having a fit. First off the download seems to be missing a crucial file. I Googled till I was all blue in the face and found a sample file that was close to what I needed BUTT when I looked for --> $cfg['PmaAbsoluteUri'] <-- in the file that I found it was no where to be found. Can I just add that line myself? If I can where do I add it? Thanks for any help. 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 |
 |
 
|
|
Feb 21 2007, 11:52 PM
Post
#2
|
|
 Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Hello Wendy,
It sounds like a variable from the config.inc.php which is located in the phpmyadmin root folder (/var/www/phpmyadmin/ for *nix and I'm not sure where for windows). But there are a few files with the same name if you look in the sub dirs......... Actually I just had a bit of a scour around and found this: QUOTE 1. Untar or unzip the distribution (be sure to unzip the subdirectories): tar -xzvf phpMyAdmin_x.x.x.tar.gz in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp. 2. Open the file config.inc.php in your favorite editor and change the values for host, user, password and authentication mode to fit your environment. Here, "host" means the MySQL server. Also insert the correct value for $cfg['PmaAbsoluteUri']. Have a look at Configuration section for an explanation of all values. Here's what mine look like for local development: $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; 3. It is recommended that you protect the directory in which you installed phpMyAdmin (unless it's on a closed intranet, or you wish to use HTTP or cookie authentication), for example with HTTP-AUTH (in a .htaccess file). See the multi-user sub-section of the FAQ for additional information, especially FAQ 4.4. 4. Open the file <www.your-host.com>/<your-install-dir>/index.php in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode. The actual page is located at http://www.webmasterworld.com/forum88/4953.htm The thread is titled Install & Test phpMyAdmin so hopefully it will be of some use. By the way what are you running this on (*nix, windows etc.)? Hope this helps. Cheers, Lucent. --------------------  Special thanks to efizzer for the signature |
|
|
|
|
Feb 22 2007, 06:27 PM
Post
#3
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi lucent,
OK first off I'm using Windows XP SP2 and I've been told that all of the programs that I'm trying to set up were all meant for use in Linux so nothing seems to work without a lot of effort. I found this --> $cfg['PmaAbsoluteUri'] = ''; <-- line squirreled away in config.default.php in my phpMyAdmin folder. The install didn't generate a config.inc.php file when I had ran setup so I did the copy/paste/change name thing with the config.sample.php and the $cfg['PmaAbsoluteUri'] line isn't in it. Now I just noticed something strange about that tile is it supposed to be "config.inc.php" as stated in the documentation or "config.ini.php" ? .inc doesn't right but that's what I used because it was stated that way in the doccumentation. This is what my config.inc.php file looks like right now; <?php /* $Id: config.sample.inc.php 9675 2006-11-03 09:06:06Z nijel $ */ // vim: expandtab sw=4 ts=4 sts=4: /** * phpMyAdmin sample configuration, you can use it as base for * manual configuration. For easier setup you can use scripts/setup.php * * All directives are explained in Documentation.html and on phpMyAdmin * wiki <http://wiki.cihar.com>. */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pmausr'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?> OK so where would I stick the "$cfg['PmaAbsoluteUri'] = '';" line and what the heck goes between the " '' " marks? Does anything in the above file jump out at you as something that might be problematic? Thanks for any help. Wendy PS I forgot to say 'Thanks' for that link. I already had it and have been doing a lot of reading there too. Wendy This post has been edited by Wendy K. Walker: Feb 22 2007, 06:33 PM -------------------- 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 |
|
|
|
|
Feb 22 2007, 08:00 PM
Post
#4
|
|
|
Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Hello, I have to head off now, well a while ago but i just noticed your reply. I have a sample of a default install on a fresh ubuntu server. I'll be in windows next time i promise
 QUOTE $cfg['PmaAbsoluteUri'] = ''; From memory this is the absolute path to your phpmyadmin webroot directory, so point this to where the actual directory is located on the hard drive eg, c:\somefolder\with\the\phpmyadmin\directory\here\ And that is what goes between the quote marks (one each side as in 'C:\blah\blah\') PmaAbsoluteUri = PhpMyAdminAbsoluteUnifiedRescourceIndicator....... maybe, just off the top of my head though. Here is the sample: CODE <?php /** * Debian local configuration file * * This file overrides the settings made by phpMyAdmin interactive setup * utility. * * For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz */ /** * Server(s) configuration */ $i = 0; // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can disable a server config entry by setting host to ''. $i++; // Uncomment to override the default configuration //$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address //$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port //$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket //$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket') //$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') //$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // // (requires PHP >= 4.3.0) //$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // // (this user must have read-only //$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // // and "mysql/db" tables). // // The controluser is also // // used for all relational // // features (pmadb) //$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)? //$cfg['Servers'][$i]['user'] = 'root'; // MySQL user //$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // // with 'config' auth_type) //$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only // // this db is displayed in left frame // // It may also be an array of db-names, where sorting order is relevant. //$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname // //$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';// Database used for Relation, Bookmark and PDF Features // // (see scripts/create_tables.sql) // // - leave blank for no support // // DEFAULT: 'phpmyadmin' //$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';// Bookmark table // // - leave blank for no bookmark support // // DEFAULT: 'pma_bookmark' //$cfg['Servers'][$i]['relation'] = 'pma_relation';// table to describe the relation between links (see doc) // // - leave blank for no relation-links support // // DEFAULT: 'pma_relation' //$cfg['Servers'][$i]['table_info'] = 'pma_table_info';// table to describe the display fields // // - leave blank for no display fields support // // DEFAULT: 'pma_table_info' //$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';// table to describe the tables position for the PDF schema // // - leave blank for no PDF schema support // // DEFAULT: 'pma_table_coords' //$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';// table to describe pages of relationpdf // // - leave blank if you don't want to use this // // DEFAULT: 'pma_pdf_pages' //$cfg['Servers'][$i]['column_info'] = 'pma_column_info';// table to store column information // // - leave blank for no column comments/mime types // // DEFAULT: 'pma_column_info' //$cfg['Servers'][$i]['history'] = 'pma_history';// table to store SQL history // // - leave blank for no SQL query history // // DEFAULT: 'pma_history' //$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables // // are up to date. This prevents compatibility // // checks and thereby increases performance. //$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login //$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use // = ''; //$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults // = array(); ?> This may be no help to you whatsoever, but if you cross reference this one and the one in the previous link you may be able to work something out. Also if you read pma as PhpMyAdmin it might make a bit more sense. Sorry i have to go i'm getting yelled at  Cheers, Lucent -------------------- Special thanks to efizzer for the signature |
|
|
|
|
Feb 23 2007, 02:45 AM
Post
#5
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi lucent,
*passes extra set of ear plugs* Hope that you didn't get fussed at too much because of me Boo. I'm pretty sure that you're right about $cfg['PmaAbsoluteUri'] = ''; needing an absolut path there but I found this in the config.default.php * Your phpMyAdmin URL. * * Complete the variable below with the full url ie * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ So that puts two stumbling blocks in front of me: I don't have a web site. All I have is Apache2 setup on my PC at --> C:\Apache\Apache2\http\phpMyAdmin. I don't see anything named "directory" so where do I get the "directory" part from? That sample that you posted looks king of like the .default.php that I've been going over too. I've got to cut this short cause I have to catch someone when they get off of work. Thanks for your help. 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 |
|
|
|
|
Feb 25 2007, 07:59 PM
Post
#6
|
|
|
Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Hello again
sorry about the wait......big weekend. Okay, so a couple of questions first.
QUOTE * Your phpMyAdmin URL. * * Complete the variable below with the full url ie * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ So that puts two stumbling blocks in front of me: I don't have a web site. All I have is Apache2 setup on my PC at --> C:\Apache\Apache2\http\phpMyAdmin. I don't see anything named "directory" so where do I get the "directory" part from? The directory path you need to fill in is the one you have stated above. QUOTE C:\Apache\Apache2\http\phpMyAdmin\ This is what you want to fill in for the $cfg['PmaAbsoluteUri'] = ''; line. So it should look like this, CODE $cfg['PmaAbsoluteUri'] = 'C:\Apache\Apache2\http\phpMyAdmin\'; I'm not sure but you may have to have the slashes (\) reversed so it would look like this: CODE $cfg['PmaAbsoluteUri'] = 'C:/Apache/Apache2/http/phpMyAdmin/'; Once again i'm a bit rusty on the Windows side of things....... As for your website, it should reside in C:\Apache\Apache2\http\ and if you open a browser to point to http://127.0.0.1/ you should see the default install apache webpage I hope this covers your questions properly. Again if you just want to get coding and don't want to deal with all of the configuration details, unistall apache and php then give the WAMP5 option a go. Cheers, Lucent. -------------------- Special thanks to efizzer for the signature |
|
|
|
|
Feb 26 2007, 09:27 PM
Post
#7
|
|
 Hail Groovicus! Group: Site Admin Posts: 6,215 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Does Apache have a default port that it runs on? I use Tomcat for my web apps, and by default it runs on port 8080. To access it I use: localhost:8080/sample
Have you tried on: http://localhost/ Not that I know too much about Apache, but I already have several other servers and databases already running on my development system. I have been considering putting Apache on it and PHP, since I've never tinkered with either. -------------------- |
|
|
|
|
Feb 27 2007, 12:30 AM
Post
#8
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi lucent,
First to answer your second question. I wanted Apache so that I could access the .onion network. If I did it right I have it set so that Apache will only bind to localhost. It's not supposed to be accessible by everybody and their dog that goes out trolling across the Internet and is only supposed to be accessible by someone with the right address for my server like http://6sxoyfb3h2nvok2d.onion. [EDITED] That URL it "IS NOT" a URL that will get you to my server, however, it is a valid URL to an information page that is hiding somewhere out there in cyberspace. So at first I was just setting Apache up for that but then my curiosity took over  when I was doing some reading [Here] to learn how to set Apache up. Then I decided to give it a go so I downloaded, installed and tested PHP to make sure that it was working with Apache. [It was]Then I downloaded and installed MySQL. Then downloaded and installed phpMyAdmin and that's where I'm at right now. I'm kind of stuck trying to figure out what all should go into the confic.ini.php file to make that thing work right though. I mean according to the documentation phpMyAdmin looks for config.default.ini.php [first] at start-up then for config.ini.php to get its self going. I don't understand 'why' it does that but it does and I have to get the config.ini.php set up so that it overrides the .default thing. Right now I'm like kind of stuck right outside of the door to phpMyAdmin so to speak because I can't figure out what password its welcome screen is asking for when I enter http://localhost:8080/phpMyAdmin in my browser. I keep getting --> Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES) or Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: NO) <-- every time I try to use the Log in Username: Password: boxes. I don't understand how to get past that because I haven't set a username name or password yet. I tried using 'root' and root as usernames but that didn't work so right now I'm at a loss. As for the URL thing --> $cfg['PmaAbsoluteUri'] = 'C:\Apache\Apache2\http\phpMyAdmin\'; seems to be right because when I tried it with '/' I got a different ERROR message about bad syntax or something to that effect. I think it might be in MySQL and Apache that I have to use the '/' or the '\\'. Thanks for the info on WAMP5. I had given it a look and it didn't seem like it would be letting anyone get to me through the .onion network so I decided against using it. Besides I'm really trying to learn how this stuff works and how to make it all work together and a precompiled kit-n-a-can kind of defeats that. Maybe I'm just a glutton for punishment. Thanks for that video link too, I'll give it a peep. Here's some of what my config.ini.php looks like right now. Does anything just jump out at you that might be keeping me from being able to log into phpMyAdmin? Or maybe that needs to have something added between the --> '' <-- to make it work better? I've tried adding a password to blowfish_secret but that didn't work either. $cfg['PmaAbsoluteUri'] = 'C:\Apache\Apache2\http\phpMyAdmin'; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['compress'] = FALSE; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pmausr'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; /* * End of servers configuration */ Hi groovicus, Thanks for the reply Boo. Yeah Apache uses port 80 for its default but I set it to 8080 when I set it up. Http://localhost:8080 gets me to my Apache Index page, and that works just fine. If you're planning on tinkering with Apache and PHP you better get a big bottle of Aspirin cause this stuff can sure give you a head ache. Thanks for any help that you guys might be able to give me with this. Wendy This post has been edited by Wendy K. Walker: Feb 27 2007, 12:39 AM -------------------- 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 |
|
|
|
|
Feb 27 2007, 05:04 AM
Post
#9
|
|
|
Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Hello
It seems like we are on the right track. Just quickly, sorry but i don't have much time again, Sorry , but it looks like you need to change these lines:CODE $cfg['Servers'][$i]['controluser'] = 'pmausr'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; To this: CODE $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = ''; Then depending on how MySQL has been configured you may have to reset the root password or create one. I'm not too sure how MySQL functions under windows but if it is like *nix environments it will install without a password set. So when you get to the phpmyadmin page on your browser try entering: QUOTE Username:root Password: Note: Just leave the password field blank and hit enter or click on th "Go" button. If you still get errors you may have to manually reset the password you can see how to do this here: http://dev.mysql.com/doc/refman/5.0/en/res...ermissions.html If all goes well and you don't have to reset the password, please, please make sure you set one once you get in there. Also have a read of this: http://dev.mysql.com/doc/refman/5.0/en/sec...guidelines.html The link is also available in the first link I gave you and is quite brief but touches on a couple of things you should be aware of. I hope you finally have success. Cheers, Lucent. Oh, Groovicus thanks for checking in on this post Is there anything else that you can think of. Sadly I'm realising how badly my Windows programming has lapsed.....
This post has been edited by lucent: Feb 27 2007, 05:10 AM -------------------- Special thanks to efizzer for the signature |
|
|
|
|
Feb 27 2007, 08:24 AM
Post
#10
|
|
|
Hail Groovicus! Group: Site Admin Posts: 6,215 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Nope. You already caught that Wendy was getting a MySql error. On Windows, it should have prompted to put in a user name and password for top level access. When you install on Linux, it uses the 'user' password.
Would I be correct to assume that PHP needs to have a database set up for it, or does the install take care of that. -------------------- |
|
|
|
|
Feb 27 2007, 07:54 PM
Post
#11
|
|
|
Forum Regular Group: Members Posts: 172 Joined: 6-January 05 Member No.: 8,797 |
Groovicus, I have always thought that because PHP by itself is not dependant on MySQL it doesn't need to to have access to a database to run. My thinking is that while the language itself is capable of making calls to databases it doesn't rely on them to function but rather relies on hard coded or on the fly variables that are written in scripts or entered into forms (still hard coded i guess, just not defined?). PhpMyAdmin on the other hand ships with it's own set of SQL scripts to create and populate it's own database and tables as well as granting default root privileges. These are run on installation. That being said, I don't know what would happen if you installed everything out of "order" or if it's even possible to do so. I guess you would be able to but you would have to do a fair bit of config file hacking to get it right and probably would have to run the SQL scripts yourself to create a working database for PhpMyAdmin to function correctly. It would be interesting to try though.....
Thanks again for your input, it is always (very much) appreciated. Cheers, Lucent. -------------------- Special thanks to efizzer for the signature |
|
|
|
|
Feb 27 2007, 08:01 PM
Post
#12
|
|
|
Hail Groovicus! Group: Site Admin Posts: 6,215 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Ok, so my thinking on the issue (given that I know nothing of PHP, but am very well versed in mysql) is that mysql will not allow access except to those who have been granted the necessary permissions. IMHO, it would be a huge security issue if an installed application (like PHPAdmin, or whatever) could issue itself admin permissions. I may tinker with this next week since it is something I have been wanting to do for awhile anyway.. this gives me a perfect excuse.
<me shudders> I just remember Apache being a bear to get to work properly with Tomcat..on Linux it is a breeze (relatively speaking). On Windows it just sucks. Sorry Wendy, didn't mean to hijack your thread.
-------------------- |
|
|
|
|
Feb 27 2007, 10:56 PM
Post
#13
|
|
|
Senior Member Group: Members Posts: 511 Joined: 28-June 05 Member No.: 25,107 |
Hi lucent,
Thanks for the reply. OK I changed these as you suggested --> $cfg['Servers'][$i]['controluser'] = 'pmausr'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; and succeded in getting a different ERROR message; --> Error The configuration file now needs a secret passphrase (blowfish_secret). <-- So I added one and tried it again and got this --> Log in Username: root Password: So I entered the new password and got this --> Error #2003 - The server is not responding so I restarted Apache made sure that the MySQL Server was running then tried again and got this --> Error #1045 - Access denied for user 'root'@'localhost' (using password: NO) <-- I had used the password that I had set for 'blowfish_secret' then tried it with no password, then tried it with several different passwords that I've used during previous installs of MySQL but all I keep getting is the same ERROR message. Thanks for that link to the MySQL reference manual. I've been reading in it for several days and have already tried just about everything there and the best I can get from it is; C:\>C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --init-file=C:\mysql-init.txt 'C:\Program' is not recognized as an internal or external command, operable program or batch file. <-- or some similar message depending on what I had tried to do. Actually the only thing that I've found in that manual that works in a command console window is the commands --> NET START MySQL, NET STOP MySQL. Other than those two commands I haven't found any commands in that manual that will work as set forth. This is killing me here! There is yet one other possible answer to my dilemma but I don't know the name of the file to look for or even exactly where to look for it. On one of the re-installs that I did with MySQL I saw a notice saying that if I had uninstalled a previous installation of MySQL that the uninstall program DOES NOT automatically remove the old password and that I will need to edit a file in the Windows Directory manually, however, the named file was no where to be found in the Windows directory so I'm stumped. Hi groovicus, Hey Boo, Hi-Jack all you want cause I need all the help I can get here. I installed Apache > tested it > it worked right > then I installed PHP > tested it > it worked right > then I installed MySQL I didn't see anywhere to enter a username but there was a place to enter a 'root' password which I did > no test was called for so I don't know if it works > then I installed phpMyAdmin > when I try to test it I can't get past the the sign in screen! I've uninstalled and reinstalled all of those programs several times over in an attempt to over come this problem but haven't gotten anywhere with it past being able to get Apache up and running and PHP doing whatever it is that it does with Apache. Thanks for anything that you might want to toss into the mix that might help. 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 |
|
|