MySQL db problem

I have a smalll MySQL database which I use to keep some logs and other similar info. I access this db by Java application which has to make inserts in one table of the db. The problem is that there no entries in the table. There is connection to the db, but the application can't insert data. On the second machine the configuration is the same and everything is OK. I am DBA, but not a MySQL expert I started 1 week ago with MySQL. Can someone help me - where and what to look for and to check in the db? How can I monitor user activities(is there something similar to v$session and v$sqlarea in Oracle)?
Many thanks in advance

Georgi
gmechevAsked:
Who is Participating?
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0
 
a.marshCommented:
My first thought would be that the username and password you use to connect does not have write permissions on the database.

You can check this by looking in the mysql database and the users table.

Compare the one on the machine that is working to that on the machine that is not working.

:o)

Ant
0
 
drittichCommented:
You can use

show full processlist

to see what is going on on the server.  If it works successfully on one machine and not another, it could be a security issue.  Can you do a

SELECT * FROM USER
SELECT * FROM HOST
SELECT * FROM DB

and psot the results?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Al_a_DdinCommented:
Sometimes it depends on platform.
for example, I had the same problem under FreeBSD. There were table created by root and theUser had not permissions to work with this table. You have to set rigth permissions for database files for theUser.
0
 
a.marshCommented:
Al_a_Ddin, please read the EE guidelines on proposing answers.

gmechev, please feel free to reject the proposed answer in order to unlock the question and get further help.

:o)

Ant
0
 
MoondancerCommented:
This question was LOCKED with a PROPOSED ANSWER and awaits your decision today.  Once a question is LOCKED with a Proposed Answer, few new experts will step in to help on that question, since the assumption is, you've been helped.  If the Proposed Answer helped you, please accept it and award that expert.  If it did not help you, please reject it and add comments as to status and what else is needed.
 
If you wish to award multiple experts, just comment here with detail, I'll respond as soon as possible.  As it stands today, you asked the question, got help and not one expert was awarded for the contribution(s) made.  Your response is needed.  I'll monitor through month end, and if you've not returned to complete this, we'll need to decide.  Expert input is welcome (as always) to determine the outcome here if the Asker does not respond.
 
Your response in finalizing this (and ALL) your question(s) is appreciated.
 
Moondancer
Community Support Moderator @ Experts Exchange
0
 
a.marshCommented:
For this question to get any further, input was needed from the questioner.

Unfortunately this hasn't happened - I personally feel the question should be deleted.

Ant
0
 
drittichCommented:
>I personally feel the question should be deleted.

I feel the *account* should be deleted. :)
0
 
Al_a_DdinCommented:
Sorry...
If I'd able to delete my Proposed answers instead of comments, I wanna do it...
0
 
MoondancerCommented:
It is done.
Thank you,
Moondancer
Community Support Moderator @ Experts Exchange
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.