Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL db problem

Posted on 2001-06-02
11
Medium Priority
?
354 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

721 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