bayworth

Regarding your comment about database export etc. I used the phpadmin function to export the database. I used the same function to import the old one into the new database.

OK Lee I think I am drifting into choppy waters and might be making things worse. Firstly I have to admit an ID10T error. Yes I was being stupid. When I took your advice and jotted down each database name and user information next to each I realised I had missed a “o” out of the user information and had assumed it was the same as the DB name. Secondly I was loading my modified wp-config file to the wrong folder and hence why my changes were doing nothing. I have since go things round the right way and that seems to have fixed it. Well its working.
However, following on from you comment I am not sure if I am making things worse and I am still a little confused about the password entry.
Using my real information now as an example. My original database was labelled db589834258 under this database I had tables all starting with ZctfvVr and then followed by Ucomments etc. So I assume from your comment that the ZctfvVr bit is the table prefix.
I then have my second database (new) which is called db590009115. However, this seems to contain more tables. It has some tables labelled wNvQHsBcomments, Boptions etc. plus it has a list of tables labelled ZctfvVrUcomments etc. I am assuming the latter tables are were created when I imported the old database and the first ones were created whent he database was first setup. I suppose my question now is, should I have both sets of tables present? Do I need to delete some or am I creating a future problem?
Finally I have a comment on the password issue in wp-config. I ammended my database password via the phpadmin panel. I then updated the wp-config to reflect the same password and as I said it seems to work fine. But the password is no longer encrypted in the wp-config. Also the password I set on the database does not seem to reflect the password set on the wp-login panel that I access via the website. So it seems there are multiple passwords in use which is all very confusing.