Santino - many thanks (thanks to Brent too but I cannot reply to him directly - seemingly I am not allowed !)
I had removed all of the mysql folder and the 'other' directory - the one with the really long name where most stuff seemed to be....and did a re-install... What happens now is I have an error file which says 050722 11:51:01 mysqld started 050722 11:51:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 050722 11:51:08 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 050722 11:51:10 mysqld ended Now this is kind of weird....All I can assume from this is that I didn't remove some other part of the original installation and it is now upset with permissions on the re-install - cannot see where InnoDB lives but suspect this to be a part of the issue now - obviously until I can get MySQL to start then I am nowhere but I do feel I am only a single step away from getting it going again now.... Andy On 7/22/05 12:07 PM, "Santino" <[EMAIL PROTECTED]> wrote: > The directory where MySql install bin script and data is: > /usr/local/mysql > this is a symbolic link to another directory in /usr/local/. > > Try to open a terminal and type: > cd /usr/local/mysql > bin/mysqlsafe & > this command launches the server. > > bin/mysql > launches the client. > > There is a file in script folder that creates users & groups > (mysql-install-db). > > It is possible that you have 2 versions of mysql (one from system > installer, the other from you). > Santino Cusimano > > PS: In the installer .dmg disk you have 2 installers (one for mysql > database and the other install a script to launch mysql at boot > time). Be sure to install both. > > > > At 10:37 -0400 22-07-2005, Andy Hilton wrote: >> 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
