Solved

MySQL db problem

Posted on 2001-06-02
11
341 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database Owner 3 45
user database (login sql or login windows) 3 52
SSIS Loading Excel file to SQL database 10 62
T-SQL: need to reset a declared variable 4 33
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…

739 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