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.
C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u myusername -p;
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)
I've tried flushing privileges and starting again, but I get the same result.
Many thanks in advance!