NanaTechie
asked on
MySQL ERROR 1045 (28000)
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:
and I receive:
I've tried flushing privileges and starting again, but I get the same result.
Many thanks in advance!
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;
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.