MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jonathan Villa Date:March 3 2004 7:01pm
Subject:Re: read only table 'user' at install
View as plain text  
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 data dir and it's parent dirs?
> drwxrwxr-x    4 mysql    mysql        4096 Mar  3 21:07 data
> 
> and the parent dir is owned by root, should I try making the
> /usr/local/mysql dir owned by mysql?
> 
> >     ls -lka /var/dir-where-you-installed
> > 3.- try using mysql client
> Never used this before, I will try...
> 
> here is an ls -la from /usr/local/mysql
> 
> [root@localhost mysql]# ls -la /usr/local/mysql
> total 92
> drwxrwx---   14 root     mysql        4096 Mar  3 02:35 .
> drwxr-xr-x   15 root     root         4096 Mar  3 02:27 ..
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 bin
> -rwxrwx---    1 root     mysql         773 Feb 10 12:59 configure
> -rwxrwx---    1 root     mysql       19106 Feb 10 12:50 COPYING
> drwxrwxr-x    4 mysql    mysql        4096 Mar  3 21:07 data
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 docs
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 include
> -rwxrwx---    1 root     mysql        7633 Feb 10 12:50 INSTALL-BINARY
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 lib
> drwxrwx---    3 root     mysql        4096 Feb 10 12:59 man
> drwxrwx---    6 root     mysql        4096 Feb 10 12:59 mysql-test
> -rwxrwx---    1 root     mysql        1937 Feb 10 12:15 README
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 scripts
> drwxrwx---    3 root     mysql        4096 Feb 10 12:59 share
> drwxrwx---    5 root     mysql        4096 Feb 10 12:59 sql-bench
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 support-files
> drwxrwx---    2 root     mysql        4096 Feb 10 12:59 tests
> 
> 
> 
> 
> 
> 
> 
> 
> On Wed, 2004-03-03 at 07:27, Victor Medina wrote:
> > 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 wrote: 
> > > 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 know enough about
> > > read/write perms on tables to try to debug it. 
> > > 
> > > I promise that I'll study up on it, but right now I'm kinda of in
> > > rush...
> > > 
> > > I'm using : mysql-standard-4.0.18-pc-linux-i686.tar.gz
> > > 
> > > thanks!
> > 
> > -- 
> > 
> >  |...........................................................|
> >  |____  _____ ____   _    |Victor Medina M                   |
> >  |\ \ \| ____|  _ \ / \   |Linux - Java - MySQL              |
> >  | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
> >  | / / / |___|  __/ ___ \ |linux@stripped                  |
> >  |/_/_/|_____|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
> >  |                        |geek by nature - linux by choice  |
> >  |...........................................................|
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 

Thread
read only table 'user' at installJonathan Villa3 Mar
  • Re: read only table 'user' at installVictor Medina3 Mar
Re: read only table 'user' at installJonathan Villa3 Mar
Re: read only table 'user' at installJonathan Villa3 Mar
  • Re: read only table 'user' at installMichael Stassen3 Mar