A example of permission setup.

A common mistake is to forget that passwords are stored encrypted, which leads to something like:

INSERT INTO user VALUES ('%','jeffrey','bLa81m0','Y','Y','Y','N','N','N','N','N', 'N','N');

Then (of course) a mysqladmin reload to make the authentication change take effect, then trying to connect to the server:

$ ./mysql -h sqlserver -u jeffrey -p bLa81m0 test
Access denied

Try this instead:

INSERT INTO user VALUES
('%','jeffrey',password('bLa81m0'),'Y','Y','Y','N','N','N','N','N','N','N');

As before, mysqladmin reload to make the authentication change take effect.

Now things should work.

Go to the first, previous, next, last section, table of contents.