?
Solved

MySQL ERROR 1045 (28000)

Posted on 2016-11-16
2
Medium Priority
?
134 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
JesterToo earned 1000 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 56

Assisted Solution

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

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

801 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