Bingo@bingo:~/proxypool/payout$mysql -u proxypool -p proxypool < db.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'proxypool'@'localhost' (using password: YES)
What is the correct password?
You created that password just a little earlier.
CREATE USER 'proxypool'@'localhost' IDENTIFIED BY 'insert-password-here'; <--that password.
Pardon,
begin with
CREATE USER 'proxypool'@'localhost' IDENTIFIED BY 'randomp@ssw0rd';
$ mysql -u proxypool -p proxypool < db.sql
Enter password: <--- entered randomp@ssw0rd, then
ERROR 1049 (42000): Unknown database 'proxypool'
What is missing here?