Solved

MySQL ERROR 1045 (28000)

Posted on 2016-11-16
2
105 Views
Last Modified: 2016-11-17
Hello all,

I started this account because I've just started learning SQL and it's not going as smoothly as I'd hoped (does anything?)

So I've downloaded MySQL Server 8.0 and I'm trying to get started, but I've hit a bump in the road.

I've successfully installed MySQL in the command line (using the administrator command line), I've managed to log in as a root, and I've created a database with all privileges granted to 'myusername'@'localhost' identified by 'mypassword'.

Here's where the trouble starts.
I input:
C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u myusername -p;

Open in new window


and I receive:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'myusername'@'localhost' (using password: YES)

Open in new window


I've tried flushing privileges and starting again, but I get the same result.

Many thanks in advance!
0
Comment
Question by:NanaTechie
2 Comments
 
LVL 22

Accepted Solution

by:
JesterToo earned 250 total points
ID: 41890815
Remove the semicolon from the end of the command you are using to start mysql.  Semicolons are used to terminate sql statements once the client has started.

Also, be aware that version 8.0 may not be completely stable yet... it is a "development milestone" which means it is a "work in progress".  The "generally available" release is currently 5.7.16 and might be a better choice for someone just starting out.
0
 
LVL 54

Assisted Solution

by:McKnife
McKnife earned 250 total points
ID: 41890872
Without knowing anything about mysql: Are you sure the password is entered correctly?
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Suggested Solutions

Troubleshooting common task sequence error codes
Windows 10 came with  a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

749 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