Could someone please help me with the following situation?
I receive the following error when trying to sign in to Mysql with an user I have just created using the grant command.
ERROR 1045: Access denied for user: 'dave@localhost' (Using password: YES)
This is the syntax that I used to set up the user.
mysql> grant all
-> on *
-> to dave identified by 'dave5678'
-> with grant option;
Query OK, 0 rows affected (0.00 sec)
This is the syntax I used to connect to Mysql
mysql -u dave -p
I am telneting into this site, but I also recieve the same error on my local machine.
I have also flushed the privileges before trying.
Root works fine.
If you could help with this it would be appreciated.
Thanks Dave
