hello!

i am just starting with mysql as a local db on my machine. i have
interacted with many database systems but this is my first time doing
it all solo.


i am attempting to create an admin user (me) with all access.
i tried:
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'some_pass';

and i got the following error:

ERROR 1227 (42000): Access denied; you need the CREATE USER privilege
for this operation

any help would be largely appreciated!!

jason wrote:
I believe the admin user is created by default. You have to change the
password for it. I managed to do it on my PC, altho I don't recall
exactly what I did. Try Google.

jason wrote:
You need to sign on first. You didn't say what OS you're using or how
you installed MySQL, but the default is often user 'root'. The password
is either blank or specified when you install MySQL, again depending on
how you did it.

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