How to see log files in mysql?

⇧

⇩

32 views

I am just a beginner in Mysql.
I read out that MySql maintain a log file where he keep all activity done by admin
[ like when he create database, when and what he insert, time , date etc] ,
I want to see it, how it look like, can anybody tell me how i can see it? where it exixt in the system.

mysql

asked March 26, 2011 2:08 am CDT

rohitamitpathak

posted via StackOverflow

1 Answer

⇧

⇩

Depends on your operating system:

http://www.cyberciti.biz/faq/location-of-mysql-logs-in-linux-unix-bsd-apple-osx/

answered March 26, 2011 2:23 am CDT

kriegar

Your answer

Similar discussion threads

Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL 5.1 + mysql-connector 5.1.x
January 27, 2011 01:47:26 AM
Hi all, I have a problem with: Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6 I configured the connection in tomcat like this: <Resource driverClassName="com.mysql.jdbc.Driver" …

MySql overload: auth mysql + cache?
March 24, 2011 07:42:41 AM
Hello all, I'm facing a major issue on one of my DB after an application upgrade that switch to AuthMysql for a subversion server authentication My DB server is overloaded by tons of: > SELECT user.unix_pw, length(user.unix_pw) FROM user,…

Re: Mysql to Postgresql
February 24, 2011 06:50:59 AM
2011/2/22 Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>: > Dear all, > > Today I need to back up a mysql database and restore in Postgresql database > but I don't know how to achieve this accurately. In addition to other…

metastore with mysql
February 23, 2011 06:29:37 AM
Hello, I am running hive with a hadoop mini cluster and want to switch to mysql as a metastore because I need multiple connections at same time (not sure if this will work at all). I tried the local metastore config. The DB and two tables in mysql…

Mysql to Postgresql
February 22, 2011 03:17:43 AM
Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma

connecting jsp with mysql
February 21, 2011 07:55:44 AM
Hi, I am having difficulty in connecting jsp and mysql using Tomcat 7.0 . I downloaded jdbc driver "mysql-connector-java-5.1.15-bin.jar" and placed it in two locations: - CATALINE_HOME\lib - C:\Program Files\Apache Software…

mysql 2 pg script...
February 18, 2011 11:51:49 PM
hi all, I need to load mysql dump to postgre 8.3 . Is there a script to do that? I hoped to use my2pg.pl , but couldn't find it. It looks like it's not a part of /contrib in debian lenny. what shoud I use for 8.3? thanks.

Tomcat 7 and mySQL
September 19, 2010 01:26:08 AM
Hello, I try to connect the Tomacat 7 to a mySQL. My server.xml looks like that <?xml version='1.0' encoding='utf-8'?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license…

Re: verify db with mysql
January 5, 2011 05:47:47 PM
On Tuesday, 14th of December 2010, 20:09:26 Wietse Venema wrote: <snip> > > Yes, I have tested that and it worked without problems. If you > > are interested then I will send you the logs of that test. > > Yes, it would…

storeconfig / mysql
December 6, 2010 12:18:28 AM
hello! centos 5.5, puppet 2.6.4, storeconfig, mysql, about150 clients. time to time i recive following error: Puppet (err): Could not retrieve catalog from remote server: Error 400 on SERVER: Mysql::Error: MySQL server has gone away how can i…

Mysql Admin
December 10, 2010 05:35:22 AM
I'm trying to administer the mysql database on some servers using puppet. When I'm done, I want: *) The DB to have a root password. *) I want to define a few databases, users and grants. Any advice what to use? I want to use the…

migration from mysql
August 24, 2010 09:42:45 AM
Hello there, I am new to Riak, but we are thinking of migrating some of our data from mysql into it and running with it for some of our website. Temporarily we would need to keep the data in sync whilst we make other changes. So for some time we…

Re: mysql apache md5
March 8, 2011 06:21:21 PM
On 3/8/2011 5:47 PM, Noel Butler wrote: > > Incidentally, when will httpd accept sha2? Planned in 2.2.x? or only 2.3/4.x ? We won't implement the hash itself... so it would likely originate from tighter integration with openssl (which…

moving from mysql
October 16, 2010 03:09:08 PM
Hi there, I am thinking of moving from mysql to sqlite3 and want to know if there are any gotchas? My current situation is a web based school booking system using a mysql database with four tables. The busiest of the tables may have 6000 rows…

Re: mysql apache md5
March 7, 2011 05:32:47 PM
On Mon, 2011-03-07 at 13:51 +0100, Johan De Meersman wrote: > Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime, afaik - part of the build kit…

Re: mysql apache md5
March 8, 2011 03:53:37 PM
From the peanut gallery: Oh dear. The password encryption is called "MD5 based crypt" (as opposed to the DES based crypt used in the early days by various systems). "MD5 based crypt" is now standard with modern systems. There's nothing…

Migration DB from MySQL to Mongodb
March 7, 2011 10:49:04 AM
Hello, I am trying to mirgrate a large database (1.8GB) from mysql to mongodb. I've write a program in PHP.But it didn't work when mirgrating about 20% .Mongodb server came out error likes "map/reduce failed" or somewhat. I didn't use…

Dovecot MySQL Schema
March 5, 2011 07:36:24 PM
Hi, where can I find the MySQL schema for Dovecot on Debian? Regards, alokat

Installing MySQL on FreeBSD
September 12, 2010 09:33:00 AM
Hi everyone, I have an interesting problem I think. I'm trying to install MySQL on FreeBSD. This is what I have in my init.pp of the module: ---------------- start

UTF-8 characters and mysql lookups
February 24, 2011 03:07:56 PM
Let me first say that I have been googling, testing, tcpdumping, and in-general-studying for the past 2 days trying to get my autoresponder to display something other than question marks when it encountered multi-byte characters. In the end, I…

Questions and Answers are licensed under cc-wiki license.

How to see log files in mysql?

1 Answer

Your answer

Join with account you already have