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]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
