Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > BOOK: PHP and MySQL 24-Hour Trainer
| Search | Today's Posts | Mark Forums Read
BOOK: PHP and MySQL 24-Hour Trainer
This is the forum to discuss the Wrox book PHP and MySQL 24-Hour Trainer by Andrea Tarr ; ISBN: 978-1-1180-6688-1
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: PHP and MySQL 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 15th, 2012, 08:58 AM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default Problem with phpmyadmin mysql password

Hi - i've just started doing the tutorials in the book - however i'm having a problem getting xampp to work properly - it's all installed fine and was working perfectly until i created passwords in the phpmyadmin privileges section.
I changed the appropriate config.inc.php file but it doesn't connect - i get the following msg:

Error
MySQL said:

#1045 - Access denied for user 'mitchlowther'@'localhost' (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

no i notice it's trying to connect as mitchlowther @ localhost but should probably be 'root'@'localhost' - i have no idea how this works or the relationship between mysql, xampp and the phpmyadmin section?

how can i get it to work?
  #2 (permalink)  
Old February 15th, 2012, 06:57 PM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default solution

I fixed it by uninstalling xampp and everything - then re installed and did the process over again - the difference is the i changed the password only for users with 'all privileges'. That was the fix.
works fine now.
The Following User Says Thank You to mitchlowther For This Useful Post:
codebert (February 24th, 2012)


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem MYSQL password() Function everetts PHP Databases 2 March 23rd, 2007 11:34 PM
all in one, php4/mySQL/phpMyAdmin/Apache server? adamhh PHP How-To 5 September 17th, 2006 05:29 AM
Forgot password for phpmyadmin AMP_Engineer BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 3 September 8th, 2004 04:59 AM
MySQL password reset tdewitt274 BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 2 August 10th, 2004 06:24 AM
Changing password in MySql thegooner BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 May 24th, 2004 05:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.