0

So I recently formatted, and reset up my lamp server on Ubuntu 12.04. I have everything right, accept I can't seem to edit anything on mysql from a remote account, though I can view it. I know I have the remote access set up correctly (as I can view my databases fine) but I can't edit anything. I thought it was a user privilege error at first but after trying to log in I viewed my privileges and confirmed that:

mysql> show grants for 'tom'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'tom'@'%' IDENTIFIED BY PASSWORD 'BLAHBLAHMYENCRIPTED PASSWORDISN'TIMPORTANT' WITH GRANT OPTION

I can not figure out what is wrong. I have searched, and searched, and no one else seems to have this problem.

user1993766
  • 1
  • What exactly happens when you try to edit something? – Pekka Jan 19 '13 at 23:23
  • I'm editing it via a java program I wrote (that worked fine before the reformat on the exact same database) and it gives me a communication link error when I try to edit something (insert,delete, and update only) but as long as I am only using the select command, it works fine. – user1993766 Jan 19 '13 at 23:26
  • Does it give some more enlightening details than that? You should be getting an error from mySQL.... – Pekka Jan 19 '13 at 23:28
  • ahh, yes, sorry it tells me: The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. – user1993766 Jan 19 '13 at 23:30
  • Hmm, I think that won't help to get clarity about what happens... It would probably be good if you could use a proper mySQL client so you can get the real message from the server – Pekka Jan 19 '13 at 23:48
  • alright, give me a few minutes to get that info to you. – user1993766 Jan 19 '13 at 23:53
  • from SQL Workbench: 0 18:58:20 UPDATE User_Data SET Value='7' WHERE User_Name = 'tom' Error Code: 1205. Lock wait timeout exceeded; try restarting transaction – user1993766 Jan 20 '13 at 00:04
  • In the same instance(no error): 3 19:05:25 select * from User_Data LIMIT 0, 1000 2 row(s) returned – user1993766 Jan 20 '13 at 00:06
  • Hmm, that doesn't seem related to privileges. See eg. [Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction](http://stackoverflow.com/q/5836623) – Pekka Jan 20 '13 at 00:10

0 Answers0