I have uploaded all the coppermine files to my web server and changed all permissions to 777.
I am also using mySQL server on my local machine. Can I do this or does mySQL have to be on my webserver.
Also, when I try and run the install script then I get this error: mySQL could not locate a database called 'tmtgallery' please check the value entered for this
This is my main problem. I have set up all the details like this:
MySQL Host : localhost
MySQL Database Name : tmtgallery
MySQL Username : catemina
MySQL Password (no password at the moment)
MySQL table prefix : cpg135_
What am I doing wrong & how can I fix this problem? Any help would be much appreciated.
If the db is on the webserver itself then use localhost. This is the simplest option. If you want to use a remote database however then specify it's address instead of localhost and make sure you have allowed remote access to the user and to the db in general.
Also the database needs to be stand created before running the install script.
"localhost" means: on the same server as coppermine resides on, so if you don't have mySQL on the webserver your coppermine files reside on, this definitely is wrong. As suggested above, you could have a remote machine (i.e. your local box) set up there as well, however your box would have to be accessible from the internet at all times, which is not a good idea - in fact, you'd be running your own web server on your box publicly available. Not recommended at all for newbies.