Hi,
I have been watching the list for a while now as I get to know
MySQL. I must admit that it is one of the more vibrant communities I
have encountered. I have seen many good answers and even better
questions, but I haven't seen my particular issues come up. I have two
questions, one specific and one general.
First, I'm having trouble determining whether or not it is possible
to drop a user, or whether I have to go in and delete all that user's
records in the grant tables. I revoke ALL PRIVILEGES from the user, but
his entry still apears in the mysql.users table. I have heard it is
undesirable to directly manipulate the users table.
Second, I need to migrate a MyISAM MySQL server from one machine to
another, where the target MySQL server is set up using InnoDB as the
default table type. I am planning to use the mysqldump files to
recreate the databases on the InnoDB machine. My question is, what is
the best method to get the users and grants to transfer to the new
machine? I have heard that I should disable the default table type (set
it to MyISAM), make a mysqldump of the host 'mysql' database, grep
through the dump file and globally replace the old hostname with the new
hostname, and then use that file to recreate the 'mysql' database on the
target machine. Does this sound reasonable? What, if anything, will
this do to the InnoDB catalog? I would like to avoid manually
recreating each user if possible.
I suppose my best bet is just to try it out, but I wanted to get a more
seasoned opinion, if possible.
Thanks a million!
Joshua Horton
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
