I have installed MySQL on a Suse Linux 10 PC (I'm new to LINUX too!).

I've created a MySQL user and granted everything to it.

I've now installed MySQL on my WinXP machine to administer the database
remotely. I can connect using my created user and create tables etc, but:

with my user "adrian" I can't create a schema
I can't login as root

So here's the problem. When I run the Migration Tool, I can only login with
my user "adrian", but it fails to create the new schema and I hit a brick
wall.

Can someone please point me in the right direction?


I also note that when I use the MySQL Administrator tool on the Suse
machine, I have to leave the password blank when logging in....