Hello all:
Just started digging into MySQL.
I've installed/configured successfully and want to know how to add root@neoverse.net?
I guess root@localhost is default, right?
www.neoverse.net is my domain name.
look into using mysql_setpermission. It is cool little commandline util that creates user perms on databases. Gives you an option of what hosts to allow.
Or read the MySQL manual about how to use the GRANT command in SQL.
http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/G/R/GRANT.html
Do not, I repeat, do NOT change the user-tables manually, you will mess up and have to re-install MySQL.