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]

Reply via email to