On Wed, 19 Mar 2008, Rolando Edwards <redwards@logicworks.net> wrote:
> Yes you will have all the GRANTS for every user sitting in the
> 'mysql' schema (from mysq.user) if you use the --all-databases
> option of mysqldump.

Can I safely assume that dumping the database named "mysql" dumps just
as well as using --all-databases? Our backup script does a mysqldump
for each separate database, and soon will separately dump every table
in every database. (Easier to do a diff when I change just one
table.)

--
Tim McDaniel, tmcd@panix.com

I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file allows security over rides. Please help

I have tried mysql -uroot. It didn't work
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles <CBrown@bmi.com> wrote:
> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database. I was told that
> the cnf file allows security over rides. Please help
>
> I have tried mysql -uroot. It didn't work

Did you use the -p flag and supply the root password?

You'll need to be root to dump all of the databases. If it's on a
cPanel/WHM server, you can use WHM to reset the MySQL root password if
you don't know what it is.

--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283

Hi,


On 3/19/08 3:51 PM, "Brown, Charles" <CBrown@BMI.com> wrote:

> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database. I was told that
> the cnf file allows security over rides. Please help
>
> I have tried mysql -uroot. It didn't work
> ********************************************

You can start the server so that you skip loading the grant tables. That
should let you get in and change the root password. Then you should have
access to do what you need to.

Instructions are here:
http://dev.mysql.com/doc/refman/5.0/...tml#resetting-
permissions-unix

-Dan

At 2:51 PM -0500 3/19/08, Brown, Charles wrote:
>I inherited a mysql server database. Stuff are not documented. My
>question is: Are there any security work-arounds in mysql. I have access
>to the cnf file. I need to get in and dump the database. I was told that
>the cnf file allows security over rides. Please help

If you were told that, perhaps you could ask the person(s) who
told you that what they meant and how to do it. :-)

Information in other followups about --skip-grant-tables is
useful, too. You can start the server that way, connect as root w/no
password, issue a FLUSH PRIVILEGES statement to re-enable the
grant tables (so that you can use CREATE USER, GRANT, etc.), and
then set up the accounts the way you want (new root password and
so forth).

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com