View Single Post
 
Old October 21st, 2007, 09:32 AM
crmpicco crmpicco is offline
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default 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