:-\
FLUSH privileges is a very old convention that pretty much all RDMS will
need to be executed to operate and maintain states.
FLUSH
COMMIT
ROLLBACK
are all some of the most basic (transactional) RDMS conventions.
I have seen a lot of questions asked about MySQL and databases in general
not doing things authors want being posted in here - or wanting to do things
and the system doesn't allow it.
I would suggest a good starting point being a quick guide to RDMS in a
nutshell - as MySQL and all RDMS are not applications like Excel or Word or
Netscape. There are a very complicated and powerful set of tools that
unfortunately people often over simplify in their usage of them and that
leads to thinking something is a problem or a limitation - when it isn't.
People do not attempt to do crazy things with programming before they learn
how to properly - yet the same respect isn't given to DB design? IMHO DB
design and management is as hard if not more involved than normal procedural
programming at times.
Such a book would also be good as an exposure to relational algebra and
normalisation so that a database you =think= is ok - actually is and is as
fast as possible. I have built many databases and I still manage to find
myself being able to generate a query and data result that is not unique or
allowable - simply because I got lazy and skipped some ER rules and started
building the system like a human looking at tables and mapping out how they
would want to retrieve data - as opposed to mapping out how relationships,
keys, parent tables, foreign keys, uniqueness and constraints should be
enforced (Or to make a database designer joke - "should NOT be enforced"
:) ) - as that is the heart of DB design, 3NF Boyce-codd and 4NF, etc.
Anyway just my 0.02 cents. Hair pulling is not necessary! :) Then again I
guess this list is populated by a very "dive in first" look later crowd. :)
Cheers,
Richard.
----- Original Message -----
From: "David J. Boccabella" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 08, 2001 8:28 AM
Subject: RE: [e-smith-devinfo] [DRAFT]
e-smith-adm-phpmyadmin-2.2.0-0.noarch.rpm
> I'm using phpmyadmin - though I installed it myself.
>
> One of the thing that threw me quiet often is that one has to
> FLUSH-PRIVILEGES before the MySQL will find any new password settings
etc.
> I spent numerous hours tearing my hear out only to realize that MySQL had
> made the changes but had not yet loaded them..
>
> So.. Do a password change.,. do a mysqldadmin -u root -p
> flush-privileges and things might work..
>
> Dave
>
>
>
> At 9/09/2001 03:41 AM, you wrote:
>
> > >
> > > Something doesn't sound right. Do this. Simply login as
> > > root. From the
> > > root directory enter the command mysql. Do you get this:
> > >
> > > [root@e-smith /root]# mysql
> > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > Your MySQL connection id is 250 to server version: 3.23.32
> > >
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer
> > >
> > > mysql>
> > >
> > > Type exit to return to the command prompt.
> > >
> > > --
> >
> >
> >Not exactly, I have to type:
> >
> > [root@e-smith /root]# mysql -u root -p
> >
> >then enter my root password to get in.
> >
> >Mark.
> >
> >---
> >Outgoing mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.274 / Virus Database: 144 - Release Date: 8/23/2001
> >
> >
> >--
> >Please report bugs to [EMAIL PROTECTED]
> >Please mail [EMAIL PROTECTED] (only) to discuss security issues
> >Support for registered customers and partners to [EMAIL PROTECTED]
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >Archives by mail and
http://www.mail-archive.com/devinfo%40lists.e-smith.org
>
>
> --
> Please report bugs to [EMAIL PROTECTED]
> Please mail [EMAIL PROTECTED] (only) to discuss security issues
> Support for registered customers and partners to [EMAIL PROTECTED]
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Archives by mail and
http://www.mail-archive.com/devinfo%40lists.e-smith.org
>
>
--
Please report bugs to [EMAIL PROTECTED]
Please mail [EMAIL PROTECTED] (only) to discuss security issues
Support for registered customers and partners to [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Archives by mail and http://www.mail-archive.com/devinfo%40lists.e-smith.org
