Solved

MySQL ERROR 1045 (28000)

Posted on 2016-11-16
2
63 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 21

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 53

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
OfficeMate Freezes on login or does not load after login credentials are input.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

912 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now