phpMyAdmin - #1044 - Access denied for user

		Wrox Programmer Forums > PHP/MySQL > PHP Databases
phpMyAdmin - #1044 - Access denied for user

PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases 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)

October 21st, 2007, 09:32 AM

crmpicco

Friend of Wrox

Points: 8,019, Level: 38

Activity: 0%

Join Date: Jan 2005

Location: Mauchline, East Ayrshire, Scotland

Posts: 1,525

Thanks: 0

Thanked 0 Times in 0 Posts

phpMyAdmin - #1044 - Access denied for user

I am attempting to setup my database with my host, Turtle Hosting. I'm using phpMyAdmin, but it is giving me the error:

Code:

SQL query:
CREATE DATABASE IF NOT EXISTS `crmpicco_mini` ;

MySQL said: Documentation
#1044 - Access denied for user 'ayrshire'@'localhost' to database 'crmpicco_mini'

I logged into my MySQL Client on my local machine, and entered:
"GRANT ALL PRIVILEGES on crmpicco_mini.* TO 'ayrshire' IDENTIFIED BY 'mypassword';"

I log into my control panel with Turtle Hosting with the username 'ayrshire', so i presume that is why it has defaulted to 'ayrshire' as the db username.

Cheers,
Picco

www.crmpicco.co.uk
www.ie7.com

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
access denied for new user, Chapter 3	kanjigirl	BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0	5	February 19th, 2006 05:08 PM
ERROR 1045: Access denied for user: OBDC@localhost	kara333	BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6	2	December 4th, 2005 07:57 AM
1044: Access denied for user '@localhost ...	ajutla	PHP Databases	3	April 16th, 2005 03:27 PM
Access Denied For User -Chapter 9	AMP_Engineer	BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6	5	September 25th, 2004 02:18 AM
Access denied for user	wisconsin	MySQL	13	June 17th, 2004 08:46 PM