Turn On General Logging
In my.ini insert this option in the [mysqld] section
log=C:\MySQLLogging.txt
and restart mysql
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoL
I'm running Windows XP and I'd like to capture the SQL commands that are
sent to the MySQL server. Is there a way to do this on Windows?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Anyone using this? I'm looking to install it to see how it works. I read in
some of the documentation that it could be used to set up a replication
server and would automatically roll forward using binlogs. I've done
rollforward using binlogs manually before but I was wondering what kind of
mechani
Exactly, you need as many rows as many combination user/host
we can also say that an account in MySQL is not the username BUT the
username AND host combination.
If you want to duplicate any account (also the root/localhost) do this:
mysql> show grants for 'root'@'localhost';
then have fun!
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni wrote:
> I don't know if you are now more ore less confused!
>
> Claudio
I would say less because you basically explained that I need to have
localhost & 127.0.0.1.
Now my problem is that no longer have this and would like to know what
I can do to re
It is important to understand deeply mysql client access control.
Basically you need only one root account from the localhost for
administration purposes.
Keep in mind that when you login specifying 'localhost' (either by the
-h flag or implicit) MySQL will use the mysql client socket interface
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
Agreed. And don't forget to listen to the warnings MySQL sends back,
e.g.:
mysql> create table temp_date(d date default null);
Query OK, 0 rows affected (0.15 sec)
mysql> insert into temp_date(d) values('2009-13-99');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> show warnings;
+---
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date
is entered instead of the default null, and this is not good.
Can I do
Hi Octavian,
One approach is to use a trigger,
mysql> set sql_mode = '';
mysql> create table temp_date(d date default null);
mysql> create trigger temp_date_bi before insert on temp_date for each row set
new.d = if(new.d = '-00-00', null, new.d);
mysql> insert into temp_date(d) values('20
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date is
entered instead of the default null, and this is not good.
Can I do som
Hi!
blackwater dev wrote:
> I have a hold car data such as color, model, make, year, etc. I want to
> allow the user to answer some questions and I'll present them with the car
> that 'best' matches their criteria. How do I do this? I still want to
> return ones that don't match exactly but wa
History (Arrow Up/Down)
COPY: Select (click + drag)PASTE: right click (or middle click)
2009/5/15 jean claude babin
> Hello,
>
> I'm pretty new in MySql. I would like to know how you can copy a statement
> like
> mysql> INSERT INTO customers ( firstname, surname, title, phone) values (
> '
On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
1. Ensure binlogging is enabled on the master.
2. Ensure you setup grant permissions so the slave can connect to
the master.
3. Configure on the slave the replication (which databases need to
be replicated)
4. Get the master and slave in syn
14 matches
Mail list logo
