The permission of directory /usr/local/mysql/data and it's contents
must be mysql/mysql
so open the terminal and type
cd /usr/local/mysql
chown -R mysql:mysql ./data
and try to restart mysql.
Santino Cusimano
At 12:40 -0400 22-07-2005, Andy Hilton wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
