The parent dir, /usr/local/mysql, owned by root is fine. We can see
that the data dir is owned by mysql, but what about its contents? Try
chown -R mysql:mysql /usr/local/mysql/data
(as root or using sudo), then try mysqladmin again.
Michael
Jonathan Villa wrote:
nevermind that webmaster s
nevermind that webmaster stuff...wrong 'send as' setting...
On Wed, 2004-03-03 at 12:59, HPGM Webmaster wrote:
> 1.- did you create the data dir as root?
> > chown mysql.mysql -R /var/dir-where-you-install
> Well, the data dir was created when I untarred mysql...
> > 2.- who owns the mysql dat
A few things to try:
1.- did you create the data dir as root?
chown mysql.mysql -R /var/dir-where-you-install
2.- who owns the mysql data dir and it's parent dirs?
ls -lka /var/dir-where-you-installed
3.- try using mysql client
Best Regards
On Tue, 2004-03-02 at 21:55, Jonathan Villa wrot
They are currently set to 775...(which I would prefer to have them
unreadable by the world and only group and owner)
anyway, I changed them to 777 for testing and still received the same
message.
On Tue, 2004-03-02 at 22:13, Sahil Aggarwal wrote:
> check file permissions on the database director
Ok, I have installed MySQL many times and have never come across this...
when try to run
./bin/mysqladmin -u root password 'new-password'
I get the following
./bin/mysqladmin: unable to change password; error: 'Table 'user' is
read only'
I've never had this happen, and unfortunately do not kn