Installed but Cannot Create User

Hi,

I have just installed the latest version of MySQL and to be frank the interface is not what I expected.  I need to create a user so I can use a GUI interface I have downlooaded which I can then use as normal.  The command line interface is something I am not familiar with.

Can anyone tell me how to create a new user with password so I can access the server and start creating databases.

Thanks in advance

Andtew
LVL 20
REA_ANDREWAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FilipsFreelancerCommented:
After installing you should be able to log in to mysql as root without password. So in the GUI try login with user root with a black password.
Are you talking about Linux installation?
This GUI is this phpMyAdmin?

Greetz
Filips
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
REA_ANDREWAuthor Commented:
I get this

1045
#28000Access denied for user 'root'@'localhost' (using password: NO)

Windows System
0
REA_ANDREWAuthor Commented:
I am using MySQL Turbo Manager
I have used it before and it does everything, lol when I can use it
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

REA_ANDREWAuthor Commented:
got it, root was right, but I did create a password. Thanks again
0
FilipsFreelancerCommented:
That's strange. Normally with installation user root is created with an empty password except when you installed it with the installer and gave the root account a password already.

Do you remember if you had to give a password when installing MySQL?
0
FilipsFreelancerCommented:
Oops, didn't see you already solved it.
Great for you.
Have fun

Filips
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.