cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot access mySQL tables

orthohin
Grand Master

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
0 REPLIES 0