I want to administer MySQL on my database server from a remote PC (across the room in this case, but later somewhere across the known universe).
Using MySQL Administrator on the server, I can give a ‘user’ schema privileges to each individual database. I can then use MySQL Admin or SQLyog on the remote PC to connect to the database as that ‘user’ and can add/modify/etc tables in each database from the remote PC. That’s useful.
However, I cannot create a new database because I would need to connect as ‘root’, and cannot. I think that I read on MySQL site that this is a feature, but I would nontheless like to be able to do it.
Is there a way?