Hi,

I am using MySQL v4.1 on Linux (CentOS v4.2))

I don't how, but when I list the databases available, "mySQL" databases
doesn't exist anymore !!!
As far as i know, this database stores all the infomation on users and
rights ?

How can I do to restore it ? , instead of reinstalling completely the RPM
package ? :-(

thanks
Steph

Stephane M wrote:
> I don't how, but when I list the databases available, "mySQL" databases
> doesn't exist anymore !!!

Another possibility is that you're connecting without specifying the
correct user/password combination to see the database.

A typical MySQL installation allows any user (including anonymous
connections that specify no user) to see only the "test" database. You
need to specify a user that has privilege to see the "mysql" database in
order to see it.

For instance, this command:

mysqlshow

Shows only the "test" database.

mysqlshow -u root -p

The latter command shows several databases, including your "mysql"
system database.

Note that operating system user and MySQL user are totally separate
identities; one does not imply the other, even if they have the same
names (e.g. there's a root for Linux and a root for MySQL, and they are
not the same). So you can log in to Linux as root, and still have no
privileges in MySQL unless you specify the user/password as options when
you use "mysql" or other tools.

Regards,
Bill K.

"Bill Karwin" <bill@karwin.com> wrote in message
news:e0q1iu016li@enews3.newsguy.com...
> Stephane M wrote:
>> I don't how, but when I list the databases available, "mySQL" databases
>> doesn't exist anymore !!!
>
> Another possibility is that you're connecting without specifying the
> correct user/password combination to see the database.
>
> A typical MySQL installation allows any user (including anonymous
> connections that specify no user) to see only the "test" database. You
> need to specify a user that has privilege to see the "mysql" database in
> order to see it.
>
> For instance, this command:
>
> mysqlshow
>
> Shows only the "test" database.
>
> mysqlshow -u root -p
>
> The latter command shows several databases, including your "mysql" system
> database.
>
> Note that operating system user and MySQL user are totally separate
> identities; one does not imply the other, even if they have the same names
> (e.g. there's a root for Linux and a root for MySQL, and they are not the
> same). So you can log in to Linux as root, and still have no privileges
> in MySQL unless you specify the user/password as options when you use
> "mysql" or other tools.
>
> Regards,
> Bill K.

Unfortunately, I cannot connect to mySQL database even as Root

Do you know how to reset the Root password ?
All there password are stored inot the database calles mySQL ???
Thanks

Stephane

Stephane M wrote:
> Do you know how to reset the Root password ?

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

> All [their] password[s] are stored [into] the database [called] mySQL ???

Correct.

Regards,
Bill K.

In article <e102tt$2g6$1$8300dec7@news.demon.co.uk>,
"Stephane M" <Stephane@.com> wrote:

> "Bill Karwin" <bill@karwin.com> wrote in message
> news:e0q1iu016li@enews3.newsguy.com...
> > Stephane M wrote:
> >> I don't how, but when I list the databases available, "mySQL" databases
> >> doesn't exist anymore !!!
> >
> > Another possibility is that you're connecting without specifying the
> > correct user/password combination to see the database.
> >
> > A typical MySQL installation allows any user (including anonymous
> > connections that specify no user) to see only the "test" database. You
> > need to specify a user that has privilege to see the "mysql" database in
> > order to see it.
> >
> > For instance, this command:
> >
> > mysqlshow
> >
> > Shows only the "test" database.
> >
> > mysqlshow -u root -p
> >
> > The latter command shows several databases, including your "mysql" system
> > database.
> >
> > Note that operating system user and MySQL user are totally separate
> > identities; one does not imply the other, even if they have the same names
> > (e.g. there's a root for Linux and a root for MySQL, and they are not the
> > same). So you can log in to Linux as root, and still have no privileges
> > in MySQL unless you specify the user/password as options when you use
> > "mysql" or other tools.
> >
> > Regards,
> > Bill K.
>
> Unfortunately, I cannot connect to mySQL database even as Root
>
> Do you know how to reset the Root password ?
> All there password are stored inot the database calles mySQL ???
> Thanks
>
> Stephane

You should be able to connect using mysqladmin. If you continue to have
problems, you might invest in a MYSQL Reference book. It has most of
what you need to know to manage a MySQL environment. Required reading
if you use MySQL.

--
DeeDee, don't press that button! DeeDee! NO! Dee...