chown -R mysql:mysql /usr/local/mysql/data
(as root or using sudo), then try mysqladmin again.
Michael
Jonathan Villa wrote:
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
[EMAIL PROTECTED] 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!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]