08-18-09, 22:26 #1Registered User
- Join Date
- Aug 2009
Unanswered: Newbie to mySQL, alot of questions!
Basically i'll try to keep this short and simple.
I have had a spot the ball game designed by a programmer for my new website that i am no longer in contact with. He also produced a database for saving the coordinates of where the customer clicks and their contact details.
Im having trouble uploading the .sql file to myphpadmin.
It comes back to me with Access denied for user '********'@'localhost' to database 'spottheball'
I have been told that the username is incorrect and that I need to edit it in the "database configuration file"
How do i do this? I need to know in simple terms as this is my first experience with databases and to be honest im at a bit of a loose end.
If anyone can be of assistance it would be greatly appreciated, i'll even offer some money to whoever can help me and my web designer.
08-19-09, 02:53 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
go to the ISP who is hosting your site and make certain that you have adequate privileges. although in this case its "localhost". so its down to you or your developer.
the way MySQL security works is on a GRANT of privileges to specific users on specific machines or IP Addresses.
the error message you are getting could be
incorrect hostname or IP addresss
so you need to either open a command line copy of MySQL and apply the GRANT command
downlaod a copy of the MySQL GUI tools from their website and apply the privlieges from MySQL Administrator
if you do use the command line client then make certain you MySQL FLUSH PRIVILEGES before leaving to make certain the server loads the new privileges otherwise it will continue with the old privileges until the server is restarted
MySQL :: MySQL 5.1 Reference Manual :: 5.5.2 Adding User AccountsI'd rather be riding on the Tiger 800 or the Norton