MYSQL :: Logging In To Monitor Thru Dos

MySQL Monitor?
I recently downloaded the latest stable release and once activated it
requested access to the net. Without access it would come up with
recognition and 'localhost' connection errors?

Can anyone please tell me:

1. What is the MySQL Monitor

2. Why this version needs internet access to it, and (if not [and even if]
benign)

3. Can I prevent it without causing errors

Monitor A Table For Any Changes
how can I monitor a table for any changes that have occurred to it? Ive considered watching 'CHECKSUM TABLE table' for a change, and then checking the table, but that still requres checking the entire table for the actual change.

Big Problem With Monitor
The majority of my problems come down to this:

whenever I change a user's password in the mysql monitor, via...

mysqladmin -u root -p password 'newpass'

...it fails. It accepts the argument as expected, but any time after that I have to use the root password it fails to connect. whether I try the old password or the new one, it seems I'm locked out. why is the change password command setting it to something unbeknown to me?

Database Monitor
I am trying to write an application which will run on a web server which will monitor a table in my MySQL database. If there are entries in this table, then try to service those entries. Keep checking every 5 seconds or so to see if there are any entries which need to be serviced.
I'm pretty new to web development so I'm not sure how to set this up and how the "monitor" application would run. What is the preferred method of approaching this sort of problem? I need to make sure that this application is running all the time, so how can I ensure this? The web page is mainly comprised of php code with some javascript. Would I need a Java program or a per script running on the server to do this?

Monitor Disappears
I have just installed MySQL and when i double click mysql.exe the monitor appears for a split second and disappears. There is no welcome message

Monitor Newlines
Does anyone here work with the command line on win xp? The thing is it's easier for me to read/write commands when creating a newline, though if I notice a typo I don't know how to get back to the line I want to fix which is a frustrating thing.

Monitor Every SQL Query
How To monitor every SQL query that hits the database?
(something like Log files).
So i can record ever query, so i can see it or manipulate that log files.
is any internal utility in mysql can do that with automaticly ?

MySQL Monitor
A total Newby with, possibly, a daft question? However, until I can get a
reasonable explanation I am disinclined towards going further. Here goes:
I recently downloaded the latest stable release and once activated it
requested access to the net. Without access it would come up with
recognition and 'localhost' connection errors?
Can anyone please tell me:
1. What is the MySQL Monitor
2. Why this version needs internet access to it, and (if not [and even if]
benign)
3. Can I prevent it without causing errors
I have spoken to others using earlier versions who have not encountered this
particular problem.

Monitor / Tuning Of MYSQL
Can anyone tell me of documention/tutorials/software for monitoring and or tuning MYSQL databases. We currently run something called foglight (Quest Software) which tracks and monitors our Oracle Instances (sends us emails about things). I think we can code stuff to monitor the MYSQL databases that we are due to take over at some point, however I am not quite sure what to look for.

MySQL Monitor Access
I am having trouble connecting to the MuSQL monitor via Command prompt, every time i try to open the Monitor i get the following error

"ERROR 1045 (28000): Access denied for user `ODBC`@`localhost` (using password: NO) "

No i can use phpmyadmin to create a DB and I can access a DB via PHP but it won`t let me open the Monitor in Command Promt.

Monitor SQL Statements Being Executed
How can I monitor what SQL statements are being executed on any table in realtime for any user? Example... I use Oracle Session Manager to do this with oracle. I want the same ability in MySQL 4.1.5

Monitor A Table Query
Environment: mysql 5.0.22 on Fedora Core 5
I have a mysql table that contains user IDs and passwords.
These IDs and passwords are used to allow access various web pages.
But the initial web page that does the authorization lookup may not be working correctly.
Is there a way to monitor the mysql (table) in realtime to see if the lookup is being performed?

MySQL Performance Monitor
Wanting to do some performance testing of MySQL on my Windows 2003 Server, and was wondering if there was anyway to setup some basic MySQL performance counters to monitor and log in perfmon? Things like queries per second, connections, traffic, etc? Doesn't have to be a permon counter, just something that can log usage values to a CSV at one second intervals

Monitor A Long Insert
Is there a way to know at what stage is a long Insert/Replace query, as how many rows have been inserted? Besides the time counter I've found nothing to do it.

Cygwin Xterm As `mysql` Monitor
I have used MySQL on linux before, but have installed to win32 (XPsp2)
for the first time (running from commandline, not as service). I
usually use cygwin xterm's on win32, as well as running other apps
(e.g. emacs) via cygwin X. After installing MySQL, I noticed I could
do the following in 2 xterm's: Code:

Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local.

1. I have installed MYSQL Server to my localhost [Windows].
MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt.

2. I have installed the MYSQL Network Monitor to my local system [Windows]
With all options like admin login, agent and other details.

But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor.

I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor.

We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?

MySQL Monitor To Generate SQL Script For Table
Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table.

MySQL Monitor To Generate SQL Script To Create Table?
Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table.

Logging In
I'm having trouble logging into my sql server, I'm running version 4.0 just about anything I type in gives me this error message

"Error
SQL query:

mysql

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql' at line 1 "

Can anyone help me with this problem?

Logging
Is there a way to turn on some sort of logging? I am attempting to connect to a db through VB, just learned it and am not sure if I am getting in and not retrieving data or not even getting in yet. Can this be done through the console and then left on?

How Do I Set Query Logging
I have a situation where my database is deleting records.

I would like to enable logging but this produces a huge text file. Also I am not sure how to read the results.

I am using MySQL 3.23 (the IT department won't upgrade).

Can anyone tell me the most efficient way to set logging for a specific database? I just need to monitor whether a process is deleting these records.

Also how would I read this information?

Are there any known problems like this with MySQL 3.23?

IIS Logging To Mysql?
Can you setup mysql ODBC so that IIS can log into mysql? if so is there any good article/ instructions on the setup?

Query Logging?
I cannot get my query logging to work.

I put

log=hostname.log

in my.ini and at some point it WAS recording a log, but it since stopped. I started the service, stopped the service, did everything. I logged into my machine as admin, as the user, did it all again... cant get it to work.

I am running mysql 5 as part of the XAMPP stack. I installed it on this machine as admin and can run it as a service, but I cant get the log to work.

Any help would be appreciated. I really need to see what SQL is being executed.

MySQL 5 Logging
I've installed MySQL Server 5.0 on Win2K IIS as well as PHP 5.0. PHP works fine, and so does MySQL...the problem is that I can't get the two to talk to each other

Logging On For The First Time
I've downloaded the XP Windows standard version, installed it and logged on without a problem.

I've also downloaded the Linux standard version, installed it(Mandriva 2000 powerpack), and attempted to log on. However, I keep getting a message telling me that it can't find a socks in /var(whatever that is).

Logging Problem
I have a problem with mysql general log, regarding query logging. I'm
running Win2K, mysql 4.1.10 with JBoss 4.0.2. When I turn on logging,
the statements executed from JBoss and logged by mysql look like this:

SELECT uuid from tablex AS a WHERE a.id = ?;

MySQL never logs the parameters of the statements. Can somebody tell me
how to turn this on or what I am missing here?

How Do I Enable Logging?
I need to enable MySQL logging. I looked in the my.ini file and did not see any logging options. Where do I turn on logging? I am using Windows.

Logging Into Server
I have a linux box with MySQL.

The following fails. If I try to login locally using

mysql -u USERNAME -p

If I go to another computer on the network and try using the same user
name and password by:

mysql -h SERVER ADDRESS -u USERNAME -p

This login is successful.

Does anyone know why the first operation fails?

Logging With Trigger
I am designing a chatsystem with logging-functionality. And i want to handle the logging-stuff within a trigger. As a procedure the code works, so the syntax in ok. As a trigger i get no errors but nothing is logged.

create trigger messages_insert
before insert on messages
for each row
begin
declare a tinyint(1) unsigned;
select logging into a from users where id = 1;
if a = 1 then
insert into logfile set content = 'A';
end if;
end

Logging In / Cookies
I've been writing some code for site I'm creating, and I got stumped this far in. I have my login code, and it works, sorta - the page that displays right after logging in says that I'm logged in, but the I guess the session is destroyed after that.

I'm sort of fighting blindly here - I just started learning PHP a few months ago and don't know much about sessions and cookies yet. Here's the code that processes the login form; I originally borrowed it from an open-source browser-based RPG (which is why users are referred to as 'players'), but now only about lines 7-17 are the same. Also, it worked fine for that game, so I don't know what's wrong here. Code:

Logging Into Server
I am running Mac OS X 10.4 (PPC) I have installed MySQL server and have the use account mysql but I have no idea of the password. When the install ran it did not give me the opportunity to set a password and I can not find anywhere that states a default password.

Logging Doesn't Work
I have WinXP, and MySQL 5.0.18 running as a service. I followed the instructions for
setting up general query log file (mysqld --log), and the file was created (Nebo.log),
but it does not display any logs.
This is all I have after executing a few queries:

Nebo.log

mysqld, Version: 5.0.18-log. started with:
Tcp port: 3306 Unix socket: (null)
Time Id Command Argument

Can anyone offer any help?

Using A Database For Logging
I need to log the number of "brochure Requests" on a per Region, Per
date basis.

eg for say 20 Regions , have a 366 columns (one per day of the year).
Obviously I can write a script to Create all the tables, but it seems
kind of clumsy.
Do arrays exist in Mysql?
It might also be easier to organise it into 52 weeks of 7 days.

How do I design the tables?

Stats Not Logging
My stats arnt being logged. Page loads with no errors..

$update = "UPDATE `log` SET hits='hits + 1' WHERE ip='$ip' AND date='$date'";
if (mysql_query($update) or die(mysql_error()) ) {
} elseif($logged[username]) {
mysql_query("INSERT into log (ip, hits, date, user) VALUES ('$ip', '1', '$date', '$logged[username]'" or die(mysql_error()) );
}
else{
mysql_query("INSERT into log (ip, hits, date, user) VALUES ('$ip', '1', '$date', '$user'" or die(mysql_error()) );
}?

Transaction Logging
I am reading up on transaction logging, and am wondering whether MySQL's binary log is its "UNDO/REDO log"? I'm a beginner to all this, and not sure whether that's the correct interpretation of the MySQL binary log.

How does MySQL's transaction logging, or any transaction logging mechanism, work? I was reading up on general transaction logging principles but it was getting far too specific to SQL Server and other DBMSs, so I figured that I could come here and someone here might point me to some MySQL-specific resources on this, or perhaps help to explain how this all works.

e.g. Does the transaction log get rid of all transactions once committed, what's the difference in how UNDO and REDO logs work, are these logs stored in a more complex manner than just logging the plain text statement (I'd imagine so, because otherwise how would an undo operation work)?

In fact, I find it funny that I'm asking all the questions above because I'm still not quite clear on what the purpose of transaction logs is in the first place!

While it would be great if somebody could help clear up the confusion I'm having, it would also be good if you could point me to some MySQL-specific resources on this topic. I browsed through the MySQL documentation and did a web search, but either did not find any resources period, or did not find resources that "dumbed it down" enough for me.

Logging Parameters
I can't see any useful-looking log files in my current localhost MySQL setup, and I can't see a way to specify logging in the Server Instance Configuration Wizard (1.0.8) either.

There are plenty of logging parameters listed in mysqld --help --verbose, but I'm not sure why I need to run that when I already have the service set up by the Wizard, which is working fine apart from logging. If I have to do it the mysqld way, how can I shut off the service, and is that a good idea anyway?

Replication Logging
Im wondering if there is some method to automatically "clean up" the binary logs left by replication even after they are used. For example, I have a number of mysql replication logs sitting on a server. There are about 25 of them, a GIG in size each.

My MYSQL replication is UP TO DATE. This means everything is properly sync'd. But I dont want to just 'DELETE' everything.

Logging On And Off MySQL
How does MySQL manage connections/sessions that are not formally and
properly closed?

What are the possible negative consequences if many of the
software/operators on the client side fail to properly close the sessions
they open? Will the MySQL server be able to handle this gracefully? Or will
they consume server resources until the system crashes?

Will the open sessions eventually time out close automatically?
Is there a timeout value that can be set on the server?

Can one query the server for information about open connections?

MySQL Logging Out
I'm not sure if this is related to MySQL or just happens to be occuring with MySQL on the Linux box, but MySQL will -- at random intervals -- log out without my explicit action and be followed by this message

[X]+ Stopped mysql -u <user> -p <database>
(where X is a number)

Now I don't have admin or root access to this server, but is there anything I can do or talk about with the administrator?

Error Logging
I'd like to be able to capture errors and write them to an error log table from the stored procedure. This is fairly simple in MS SQL ... I haven't found much information about how to do it in MySQL. Has anyone else run into this?

Turning On Logging
I have a database that has various information submitted to it from the internet. I am having problems with people hacking/submitting info that shouldn't be submitted. I don't know how they are doing it but I though that if I turned on the Logging for that particular DB maybe it would give me some clues i.e. IP addresses, ISP, date/time info, SQL Statement executed etc.What form of logging would I need to turn on?

Logging On To MySQL - Problem
I'm trying to log on to MySQL for the first time. I only installed MySQL and PHP for the first time yesterday.

When I click on the mysql.exe (in C:Program FilesMySQLMySQL Server 5.0in) nothing happens.

I thought I was meant to get a command prompt to type in my username and pw. The following actually happens to me: I double click on it, the command box opens for about 2 seconds and then closes down.

Statistics Logging, Too Big Of A Table?
If you are logging hits/statistics in a table by each page view this logging/statistics table will grow very large.

Logging Record Deletions
I want to create a script to monitor when deletions are taking place from my database.

I thought something like using SQL count to check the number of records every minute so I can log when authorised deletions are occuring.

Server Log Not Logging All Queries
I started the general query log with

mysqld --log

On my machine this command works fine and every select, update and all
statements are logged. I tried the same command on another machine and
many many queries are missing, I am running apache, PHP on that machine
and all the queries come through the web on localhost.

I wonder why this is happening?

Mysql Logging Compiled In?
i'm trying to turn on mysql logging as follows, but it doesn't seem to
work: mysqld --log=/root/log

the logfile never shows up after a connection or query. so i want to
know if logging support is compiled into mysql. i did not install it
and i cannot ask the hoster. does anyone know how to check that? i
don't even know where to begin.

Mysql Logging Compiled In?
i'm trying to turn on mysql logging as follows, but it doesn't seem to work:

mysqld --log=/root/log

the logfile never shows up after a connection or query. so i want to
know if logging support is compiled into mysql. i did not install it
and i cannot ask the hoster. does anyone know how to check that? i
don't even know where to begin.