Solved

MySQL ERROR 1045 (28000)

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This article describes how to reset your Windows 10 password when you've forgotten it.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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