Re: [SLUG] problem with mysql

From: billt (billt@ifelse.org)
Date: Fri Jul 20 2001 - 12:04:05 EDT


On Fri, Jul 20, 2001 at 10:51:33AM -0400, Grantham, Patrick wrote:
> clarification: The systems' root login and password does not work when
> logging into mysqladmin or any admin utility (i.e. webmin)

> -----Original Message-----
> From: Grantham, Patrick [mailto:Patrick.Grantham@vacationclub.com]
> Sent: Friday, July 20, 2001 8:26 AM
> To: 'slug@nks.net'
> Subject: RE: [SLUG] problem with mysql
>
>
> No. The systems' root login does not work. Every utility if used won't
> proceed past the login. What utilities did you use?

the mysql_install_db doesn't ask for anything and will recreate
the database and tables that mysql uses to manage access. It will
create them from _scratch_ so the root password will be null. And
granted access will have to be re-added.

mysql is designed so that you can't just bypass the root password
without already having system-level access to mysql's access database
Without this design consideration, what would be the point of a mysql
root password in the first place?

Why doesn't the system root password work? Why should it? It would
require mysql to run with greater privs. than it needs to function as
a database server.

> I have made a blunder. I changed the root password to a "virgin"
> install of mysql. By that I mean that was the first thing I did
> after installing from the suse distribution disk set. Problem is
> now the root password is being rejected.

what command did you use to change the password to the "virgin"
password. and what command are you now using to try to get access?



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:22:18 EDT