I have protected my MySQL server by setting the root password thus :-

SET PASSWORD FOR root = PASSWORD("dummy");

But now do not know how to create new databases under a new user.

MySQL is now not allowing me to create new databases.

Many thanks in advance,

Aaron

"Aaron Gray" <ang.usenet@gmail.com> wrote in message
news:5tt5bjF1evkphU1@mid.individual.net...
>I have protected my MySQL server by setting the root password thus :-
>
> SET PASSWORD FOR root = PASSWORD("dummy");
>
> But now do not know how to create new databases under a new user.
>
> MySQL is now not allowing me to create new databases.

Whats more I cannot seem to get to change this password again using the
above command. I am getting :-

Can't find any matching row in the user table

,

Aaron

On Mon, 31 Dec 2007 21:30:26 -0000, "Aaron Gray"
<ang.usenet@gmail.com> wrote:

>I have protected my MySQL server by setting the root password thus :-
>
> SET PASSWORD FOR root = PASSWORD("dummy");

You forgot to tell MySQL on what host that should be.
The user value should be given in user_name@host_name
format, the correct syntax can be found at:
http://dev.mysql.com/doc/refman/5.0/...-password.html


>But now do not know how to create new databases under a new user.
>
>MySQL is now not allowing me to create new databases.
>
>Many thanks in advance,
>
>Aaron

Perhaps you need the procedure to reset a root password:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

HTH
--
( Kees
)
c[_] I'm fascinated by the way memory diffuses fact. (#125)