Solved

MySQL db problem

Posted on 2001-06-02
11
302 Views
Last Modified: 2012-08-14
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
Comment
Question by:gmechev
  • 3
  • 2
  • 2
  • +3
11 Comments
 
LVL 15

Expert Comment

by:a.marsh
ID: 6148816
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
 
LVL 8

Expert Comment

by:drittich
ID: 6148977
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
 

Expert Comment

by:Al_a_Ddin
ID: 6166585
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
 
LVL 15

Expert Comment

by:a.marsh
ID: 6185574
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
 
LVL 1

Expert Comment

by:Moondancer
ID: 6402627
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 15

Expert Comment

by:a.marsh
ID: 6403088
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
 
LVL 8

Expert Comment

by:drittich
ID: 6403803
>I personally feel the question should be deleted.

I feel the *account* should be deleted. :)
0
 

Expert Comment

by:Al_a_Ddin
ID: 6403862
Sorry...
If I'd able to delete my Proposed answers instead of comments, I wanna do it...
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6404294
It is done.
Thank you,
Moondancer
Community Support Moderator @ Experts Exchange
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7257047

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
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7282195
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
Creating and Managing Databases with phpMyAdmin in cPanel.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now