On Mon, 20 Dec 2004, Sherm Pendley wrote: > No, it doesn't matter what user you use to grant the privileges. If > 'mysqluser' is your normal admin user, just log in to the mysql shell > as that user: > > mysql -u mysqluser -p > > For that matter, you could use phpMyAdmin to grant the privileges too. > The important part is that the user '[EMAIL PROTECTED]' needs full access > to the database 'test' - how you grant it that access is incidental.
To clarify, '[EMAIL PROTECTED]' is an account with the MySQL database. It has no relation at all to the system 'root' account on your computer. MySQL has its own set of accounts which generally have no connection to the ones on the system that the database server is running on. -- Chris Devers