no root user in mysql user table

Hi all,

I am using a 1and1 dedicated linux server. They already have mysql
database installed ready to use. But it doesn't have root user in the
user table.

when I run this command line,
select user from user

I got
"
admin
psa-ds9a9ds
"

, there is no a root user in this table.


What is the problem here? Should I inster a root user to this table?
Is there some installation problems I should fix?



thank s

>I am using a 1and1 dedicated linux server. They already have mysql
>database installed ready to use. But it doesn't have root user in the
>user table.
>
>when I run this command line,
>select user from user
>
>I got
>"
>admin
>psa-ds9a9ds
>"
>
>, there is no a root user in this table.
>
>
>What is the problem here? Should I inster a root user to this table?

There's no reason the administrative user HAS to be named "root".
(although some scripts may assume it). There are advantages to not
having a "root": someone trying to crack the root password will
fail, period. You do need an administrative user, and if 'admin'
is it, fine, use it.


>Is there some installation problems I should fix?

On Jan 11, 5:14 pm, gor...@hammy.burditt.org (Gordon Burditt) wrote:
> >I am using a 1and1 dedicated linux server. They already have mysql
> >database installed ready to use. But it doesn't have root user in the
> >user table.
>
> >when I run this command line,
> >select user from user
>
> >I got
> >"

> >admin

> >psa-ds9a9ds
> >"
>
> >, there is no a root user in this table.
>
> >What is the problem here? Should I inster a root user to this table?
>
> There's no reason the administrative user HAS to be named "root".
> (although some scripts may assume it). There are advantages to not
> having a "root": someone trying to crack the root password will
> fail, period. You do need an administrative user, and if 'admin'
> is it, fine, use it.
>
> >Is there some installation problems I should fix?

Thanks a million!