It's SOOO frustrating ! Yes that let me set a password for root - thanks....
But no change on the admin app - still tells me it cannot get the catalog list - 'Could not retrieve user list: SELECT command denied to user 'root'@'localhost' for table 'user' (error 1142)' I tried for interest using a different app Aqua Data Studio - to see if that would let me see the MySQL stuff - it gives a Java error big time - could all be the same thing I suspect.... If I knew what to delete I have no problem deleting any and all to do with MySQL and starting again, but I just don't know what it puts where - what can the blank name I deleted be a part of ? Is it something outside of mysql or within mysql ? If within MySQl then deleting it all and reinstalling should resolve - but yesterday when I removed the /usr/local/bin/mysql directory and reinstalled it made no difference so I am assuming the 'users' are stored elsewhere - I just have no clue where.... Thanks for the continued assistance - I do appreciate it for sure Andy On 7/22/05 10:16 AM, "Brent Baisley" <[EMAIL PROTECTED]> wrote: > Sounds like it could be a problem with the graphical management tool. > Maybe it just doesn't like a system with no password set, which is a > very bad thing. > > It sounds like you may not have set an initial root password for > mysql. It defaults to being nothing, which is not good. > In your terminal type the following: > /usr/local/mysql/bin/mysqladmin -u root password NEWPASSWORD > > That will set a password for the root account and maybe the graphical > tool will start working. > > Here is a link that may help you along. Marc Liyange did a phenomenal > job making MySQL available for OSX before MySQL picked up compiling > and creating and installer for Mac. His instructions are still > applicable. > > http://www.entropy.ch/software/macosx/mysql/ > > > On Jul 21, 2005, at 4:58 PM, Andy Hilton wrote: > >> 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/mysql? >> [EMAIL PROTECTED] >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]