one table updates,the other doesnt (MYSQL)

[juve11]

hello,
i have an app (WICH IS NOT MINE so i dont have source code) installed on 5 computers and a mysql server.

this app works with two tables from a mysql database (lets say table_A and table_B)

i need to change the server,so i made a backup of mysql database and put it on the new server,i created a mysql user to handle connections and i also changed the ODBC data source on the work machine with the new IP adress of server.

what is the problem?well with the new server i have connection to the database,i can write rows to it (using another app but same mysql connection string), i can view rows, BUT when i want to update a row it just updates table_A, leaving table_B with no changes.

i have made also a special right to my table , for example database.tableA with full rights to the user but it still doesnt updates.

the app worked fine on the old server.

i am thinking that maby there is an advanced thing to do that i dont know about


PS : actually it doesnt make an update on table_A , it just inserts the date and time that you made an update,so its just INSERT,but on table_B should do an UPDATE of the address..

[debasisdas]

That might be some PRIVILEGES issue.

[juve11]

That might be some PRIVILEGES issue.

i have this

GRANT USAGE ON *.* TO 'mihai'@'%' IDENTIFIED BY PASSWORD '*password' WITH MAX_QUERIES_PER _HOUR 10000 MAX_UPDATES_PER _HOUR 10000 MAX_CONNECTIONS _PER_HOUR 10000;


GRANT ALL PRIVILEGES ON `dbase1`.* TO 'mihai'@'%' WITH GRANT OPTION;

GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `dbase1`.`table 1` TO 'mihai'@'%';