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
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
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
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 beand did a
re-install...
What happens now is I have an
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
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 beand did a
re-install...
What
This would appear to be the relevant stuff - the err file was in the
mysql/data directory
050722 14:23:32 mysqld started
050722 14:23:32 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050722 14:23:33 InnoDB: Database was not
OK
Now open the terminal and type:
cd /usr/local/mysql/
./scripts/mysql_install_db
and restart mysql.
Santino Cusimano
At 14:34 -0400 22-07-2005, Andy Hilton wrote:
This would appear to be the relevant stuff - the err file was in the
mysql/data directory
050722 14:23:32 mysqld started
Gentlemen
Thank you VERY much ! Am now back to working again
Then when Amazon delivery my MySQL books I should be a lot wiser too !
Very much appreciated all the assistance
Andy
On 7/22/05 3:12 PM, Santino [EMAIL PROTECTED] wrote:
OK
Now open the terminal and type:
cd
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
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
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
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
13 matches
Mail list logo