Heres your problem.
define(‘DB_USER’, ‘mitchelldickson’); // Your MySQL username
define(‘DB_PASSWORD’, ‘*****’); // …and password
Where is says “mitchelldickson” that should have your Cpanel/FTP login name in front of it. For example ‘name_mitchelldickson’
Same goes for your password 😉
Hope that helps.
And actually. Your Database name is wrong i believe. Its whatever SQL database name you made in your My SQL Databases. I doubt you named it a link. But it is possible 😉
so, if my login name for ftp is mitchell613 my user should be mitchell613_mitchelldickson and my pw mitchell613_*****
???
thanks for your help
i changed my database name to my username and it’s still not working.
Yes. Thats correct.
And look at my post. I edited it as i believe your Database name is wrong 😉
Did you ever create an SQL Database? If not, you need to create one first. Then edit that file with your new Database info.
i did create one. it gave me the location listed in the first post along with my user and pass.
You dont want the location there. In the Database name section you want the name you gave the Database. It should be a name you made, not a location.
it does and i tried that. i don’t know why it isn’t working.
Are you using cPanel or another admin panel at your host to do this? It is likely both your username and database name you chose got prefixed with yourhostaccountname_ and also got truncated to a certain length, I suggest you look in the MySQL Databases section of your admin panel and see what they were actually created as.
your database name will be what you created it as:
define(‘DB_NAME’, ‘mydatabase’); // The name of the database
your username can either be that of your login for your website account, or if you were required to create another username in the control panel for the database you created.
define(‘DB_USER’, ‘mitchell613’); // Your MySQL username
sometimes ISP’s use a different value for DB_HOST also, I have to use an IP address for mine (ie: 192.168.0.1)
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
good suggestion, greatnorth. do you use godaddy?
did anyone set this up on godaddy who’d be willing to give some advice?