Re: read only table 'user' at install

2004-03-03 Thread Michael Stassen
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

Re: read only table 'user' at install

2004-03-03 Thread Jonathan Villa
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

Re: read only table 'user' at install

2004-03-03 Thread Victor Medina
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

Re: read only table 'user' at install

2004-03-02 Thread Jonathan Villa
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

read only table 'user' at install

2004-03-02 Thread Jonathan Villa
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