I have a site that uses a mySQL table and it has all been working well for several years. I have just tried adding a new table to my database and have started running into all sorts of problems.
I first added the table to the existing database with phpMyAdmin. I can see that the table exists and I am able to add data to it. However, when I try to access it via my webpage, I get the error
SQLState: S Native Error Code: 1146 [TCX][MyODBC]Table 'myname_userdb.noticecomments' doesn't exist
The webpage is, however, able to access other tables (which were already there) on the same database.
I then tried creating a new database and copying a table which was working into it. When I tried accessing it through the webpage, I got the error
SQLState: S Native Error Code: 1045 [TCX][MyODBC]Access denied for user 'myname_username'@'localhost' (using password: YES)
________