Cannot access mySQL tables

orthohin — Thu, 04 Oct 2012 19:46:22 GMT

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)

________

Orthohin

topic Cannot access mySQL tables in Archive

Cannot access mySQL tables