Re: MySQLd Password

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