crmpicco
10-21-2007, 10:42 AM
I am attempting to setup my database with my host, Turtle Hosting. I'm using phpMyAdmin, but it is giving me the error:
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
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