Problem adminstering users and creating databases

I have set the 'root' password for my mysql instillation using :-

SET PASSWORD FOR root = PASSWORD( '###');

Since doing this I can no longer create databases under a new user name and
password.

I am confused as to how I go about creating and adminstering new users and
databases.

If someone could set me straight on how to do this please.

Many thanks in advance,

Aaron

Aaron Gray wrote:
> I have set the 'root' password for my mysql instillation using :-
>
> SET PASSWORD FOR root = PASSWORD( '###');
>
> Since doing this I can no longer create databases under a new user name and
> password.
>
> I am confused as to how I go about creating and adminstering new users and
> databases.
>
> If someone could set me straight on how to do this please.
>
> Many thanks in advance,
>
> Aaron
>
>
>

The manual is a good place to start...

http://dev.mysql.com/doc/refman/5.1/...ement-sql.html

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:v6-dnYmHiseKxj7anZ2dnUVZ_gydnZ2d@comcast.com...
> Aaron Gray wrote:
>> I have set the 'root' password for my mysql instillation using :-
>>
>> SET PASSWORD FOR root = PASSWORD( '###');
>>
>> Since doing this I can no longer create databases under a new user name
>> and password.
>>
>> I am confused as to how I go about creating and adminstering new users
>> and databases.
>>
>> If someone could set me straight on how to do this please.
>>
>> Many thanks in advance,
>>
>> Aaron
>>
>>
>>
>
> The manual is a good place to start...
>
> http://dev.mysql.com/doc/refman/5.1/...ement-sql.html

Ah I have been looking at OReilly's MySQL Packet Reference which only covers
version 4.0 which does not show CREATE USER command.

Many thanks,

Aaron

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:v6-dnYmHiseKxj7anZ2dnUVZ_gydnZ2d@comcast.com...
> Aaron Gray wrote:
>> I have set the 'root' password for my mysql instillation using :-
>>
>> SET PASSWORD FOR root = PASSWORD( '###');
>>
>> Since doing this I can no longer create databases under a new user name
>> and password.
>>
>> I am confused as to how I go about creating and adminstering new users
>> and databases.
>>
>> If someone could set me straight on how to do this please.
>>
>> Many thanks in advance,
>>
>> Aaron
>>
>>
>>
>
> The manual is a good place to start...
>
> http://dev.mysql.com/doc/refman/5.1/...ement-sql.html

I am getting an error when logging on on a newly created user :-

ERROR 1045 (28000): Access denied for user 'test3'@'localhost' (using
password: YES)

Using :-

mysql -p -u test3

I am doing the following while logged on as 'root' to create the user :-

CREATE USER test3;
SET PASSWORD FOR test3 = PASSWORD('xyzzyx');

Help,

Aaron

Aaron Gray wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:v6-dnYmHiseKxj7anZ2dnUVZ_gydnZ2d@comcast.com...
>> Aaron Gray wrote:
>>> I have set the 'root' password for my mysql instillation using :-
>>>
>>> SET PASSWORD FOR root = PASSWORD( '###');
>>>
>>> Since doing this I can no longer create databases under a new user name
>>> and password.
>>>
>>> I am confused as to how I go about creating and adminstering new users
>>> and databases.
>>>
>>> If someone could set me straight on how to do this please.
>>>
>>> Many thanks in advance,
>>>
>>> Aaron
>>>
>>>
>>>
>> The manual is a good place to start...
>>
>> http://dev.mysql.com/doc/refman/5.1/...ement-sql.html
>
> I am getting an error when logging on on a newly created user :-
>
> ERROR 1045 (28000): Access denied for user 'test3'@'localhost' (using
> password: YES)
>
> Using :-
>
> mysql -p -u test3
>
> I am doing the following while logged on as 'root' to create the user :-
>
> CREATE USER test3;
> SET PASSWORD FOR test3 = PASSWORD('xyzzyx');
>
> Help,
>
> Aaron
>
>
>

See the notes on the CREATE USER page:

CREATE USER 'test3'@'localhost';

Do not use the PASSWORD function. MySQL encrypts it for you:

SET PASSWORD FOR 'test3'@'localhost' = 'xyzzyx';

Or, all in one statement:

CREATE USER 'test3'@'localhost' IDENTIFIED BY 'xyzzyx';


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:B96dnRVP9K1A-D7anZ2dnUVZ_orinZ2d@comcast.com...
> Aaron Gray wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>> news:v6-dnYmHiseKxj7anZ2dnUVZ_gydnZ2d@comcast.com...
>>> Aaron Gray wrote:
>>>> I have set the 'root' password for my mysql instillation using :-
>>>>
>>>> SET PASSWORD FOR root = PASSWORD( '###');
>>>>
>>>> Since doing this I can no longer create databases under a new user name
>>>> and password.
>>>>
>>>> I am confused as to how I go about creating and adminstering new users
>>>> and databases.
>>>>
>>>> If someone could set me straight on how to do this please.
>>>>
>>>> Many thanks in advance,
>>>>
>>>> Aaron
>>>>
>>>>
>>>>
>>> The manual is a good place to start...
>>>
>>> http://dev.mysql.com/doc/refman/5.1/...ement-sql.html
>>
>> I am getting an error when logging on on a newly created user :-
>>
>> ERROR 1045 (28000): Access denied for user 'test3'@'localhost' (using
>> password: YES)
>>
>> Using :-
>>
>> mysql -p -u test3
>>
>> I am doing the following while logged on as 'root' to create the user :-
>>
>> CREATE USER test3;
>> SET PASSWORD FOR test3 = PASSWORD('xyzzyx');
>>
>> Help,
>>
>> Aaron
>>
>>
>>
>
> See the notes on the CREATE USER page:
>
> CREATE USER 'test3'@'localhost';
>
> Do not use the PASSWORD function. MySQL encrypts it for you:
>
> SET PASSWORD FOR 'test3'@'localhost' = 'xyzzyx';
>
> Or, all in one statement:
>
> CREATE USER 'test3'@'localhost' IDENTIFIED BY 'xyzzyx';

Great that did the trick, obviously I was creating a hashed password value.
Duh !

Thanks alot,

Aaron