Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

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
0
gmechev
Asked:
gmechev
  • 3
  • 2
  • 2
  • +3
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 3
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now