?
Solved

Installed but Cannot Create User

Posted on 2006-04-01
6
Medium Priority
?
379 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
0
Comment
Question by:REA_ANDREW
  • 3
  • 3
6 Comments
 
LVL 6

Accepted Solution

by:
Filips earned 2000 total points
ID: 16348999
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
 
LVL 20

Author Comment

by:REA_ANDREW
ID: 16349011
I get this

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

Windows System
0
 
LVL 20

Author Comment

by:REA_ANDREW
ID: 16349012
I am using MySQL Turbo Manager
I have used it before and it does everything, lol when I can use it
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 20

Author Comment

by:REA_ANDREW
ID: 16349016
got it, root was right, but I did create a password. Thanks again
0
 
LVL 6

Expert Comment

by:Filips
ID: 16349030
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
 
LVL 6

Expert Comment

by:Filips
ID: 16349031
Oops, didn't see you already solved it.
Great for you.
Have fun

Filips
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month16 days, 11 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question