I am trying to have a simple mysql Database on a server and another database on another server that connects to it.
I have done the following :
mysql -u admin -p -h <address>
ERROR 1045 (28000): Access denied for user 'admin'@'X.X.X.X' (using password: YES)
I do not really know why, but appareantly, it worked when I used the
with grant option and first gave access to the database, and then to its tables.
Here is the list of commands that I entered :
mysql> create user 'admin'@'localhost' identified by 'admin'; mysql> grant all privileges on confWeb to 'admin'@'10.69.101.%' identified by 'admin' with grant option; mysql> grant all privileges on confWeb.* to 'admin'@'10.69.101.%' identified by 'admin' with grant option; mysql> flush privileges;
Again, I don't really know why it didn't work before and the answers that I saw look like all the documentation I have seen but it looks my problem was somewhere else.