Well I followed your very clear examples and I was happily able to stop the processes (after changing to root user) and I then removed the mysql directory. I reinstalled MySQL but still when I connect the MySQL Adminsitrator I can (and always have been able to) conenct as localhost and root with no password, but when I go to the Accounts button, I am still being get told 'Could not retrieve user list: SELECT command denied to user 'root'@'localhost' for table 'user' (error 1142)' and at that point I cannot actually do anything !
Seems like there is something I must not be deleting before reinstalling, or maybe it is a simple matter to amend a user list somewhere ?? Baffled - trying to work out why it let me delete the blank user in the first place if it is so important....but that's another issue - for now I just want to get it back working.... Andy On 7/21/05 4:03 PM, "Brent Baisley" <[EMAIL PROTECTED]> wrote: > There is a bunch of things you can do to recover your database > environment, but since it seems you don't have any data in your > database, I'm not going to get into the other stuff. > > From the terminal, type: > ps ax | grep safe > > That's a pipe symbol, shift \, not a capital i. > > That should show you two processes, your grep process and the > mysqld_safe process (or safe_mysqld). The first number on each line > is the process number. You can type: > kill -9 # > > With # being the number of the process you want to kill. > > You can then kill the mysql process... > ps ax|grep myslqd > kill -9 # > > Then you can just reinstall MySQL to reset everything. > > On Jul 21, 2005, at 2:48 PM, Andy Hilton wrote: > >> Brent >> >> Thanks for your reply - that all sounds like good advice but... >> Cannot see any process other than mysqld running - is there a way >> to kill a >> process from the terminal command line ? >> >> When you say 'easiest route is to just kill it and reinstall' do >> you mean to >> remove it and reinstall, or kill the process then reinstall ? >> >> Thanks again >> Andy >> >> On 7/21/05 2:39 PM, "Brent Baisley" <[EMAIL PROTECTED]> wrote: >> >> >>> MySQL is actually started using a little program called mysqld_safe, >>> which monitor MySQL and restarts it if it "crashes". You first need >>> to kill the mysqld_safe process. I assume you have no data so the >>> easiest route is to just kill it and reinstall. You may have deleted >>> the admin user. In cases like this you would normally relaunch MySQL >>> without the grant tables, which would allow open access (generally a >>> bad thing). >>> >>> If you are serious about using MySQL (which is good), pick up a book. >>> I learned by reading MySQL by Paul DuBois. It's an excellent book >>> which will walk you through nicely. You can search the archives for >>> other good books, but this one is recommend a lot. Learning how to >>> interact with MySQL through the command line will really help you a >>> lot, especially when there are problems. >>> >>> On Jul 21, 2005, at 2:07 PM, Andy Hilton wrote: >>> >>> >>>> Sorry for appearing like a dummy but I am not a Unix person ! >>>> >>>> I installed MySQL on an OSX client stumbling around the >>>> administrator app >>>> all I wanted to do was to create a database I inadvertently >>>> deleted what >>>> looked like a blank user and now I cannot connect to MySQL at all >>>> ok I >>>> will rephrase, the MySQL Administrator app connects but doesn¹t >>>> allow me to >>>> do or see anything so is pretty near useless.... >>>> >>>> Things I don¹t know how to do : >>>> How do I kill the MySQL process ? Every time I force quit the >>>> process in >>>> Activity monitor it just starts a new one.... >>>> Do I have to remove the MySQL installation in order to re-install >>>> and get my >>>> blank user back ? >>>> If I have to remove it what/where/how do I do that ? >>>> >>>> Are there any decent documented sites that can help me to >>>> administer MySQL >>>> under OSX ? So far I have found diddly squat of any real use... >>>> >>>> Many thanks >>>> Andy Hilton >>>> >>>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql? >> [EMAIL PROTECTED] >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
