phpMyAdmin - #1044

crmpicco · October 21st, 2007, 09:32 AM

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