We help IT Professionals succeed at work.

Installed but Cannot Create User

REA_ANDREW
REA_ANDREW asked
on
Medium Priority
390 Views
Last Modified: 2010-08-05
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
Comment
Watch Question

Freelancer
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I get this

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

Windows System

Author

Commented:
I am using MySQL Turbo Manager
I have used it before and it does everything, lol when I can use it

Author

Commented:
got it, root was right, but I did create a password. Thanks again
FilipsFreelancer

Commented:
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?
FilipsFreelancer

Commented:
Oops, didn't see you already solved it.
Great for you.
Have fun

Filips
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.