Re: grant all won't grant global privileges

[Colin Charles]

You seem to have granted all, to the user 'root', as opposed to another username. Have you connected form your other PC, using the user 'root' as well?

Read: http://dev.mysql.com/doc/refman/5.0/en/grant.html for a reference on what GRANT is meant to do

'root' is meant to be the mysql username you prefer...

http://dev.mysql.com/doc/refman/5.0/en/database-use.html has an example on how this can be done, as well

--
Colin Charles, Chief Evangelist, Monty Program Ab
Download MariaDB: http://www.mariadb.org/
Get all your answers at the Knowledgebase: http://kb.askmonty.org/
Blog: http://www.bytebot.net/blog/