Alexander Dalloz wrote:
Am So, den 01.02.2004 schrieb Nicholas Evans um 22:40:
Hello I installed a mySQLd from the Fedora disc last night, and got it running. I did the mysql_install_db to set up the user table and stuff, and when I went to set a password for it it says...
mysqladmin: unable to change password; error: 'Table 'user' is read only'
I've tried running it as owlmanatt (user account), root, and mysql, but it refuses to work. Could it be a chmod problem? I can't find where mySQL keeps it's database files, so I don't know where to go to fix it. I've been looking on google and trying to make it work since last night, but I can't get it.
Any pointers would be much appreciated!
(And yes, servers don't seem to like me today.)
Thanks!
Nicholas Evans
It would have been enough to run /etc/init.d/mysqld start to run the initial process for creating the base mysql database. Now after manual run of mysql_install_db you have to run manually "chown -R mysql.mysql /var/lib/mysql".
Alexander
Hey
That didn't work, but I know why now. I was talking with Clint over AIM, and he gave me a few pointers which lead me to chmod the files, then I had to reload the grant tables.
Thanks all, you were a big help!
Regards, Nicholas
