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/[EMAIL PROTECTED]
