installed MySql - can't connect to local MySql: server error

david yellowdog-general@lists.terrasoftsolutions.com
Thu Jun 20 23:55:01 2002


>Aurel writes:
>"Did you start the daemon (safe_mysqld) before running
>mysql?,..."

david wright writes:
 > checking the error logs produces:
 > [root@RR bin]# cat /var/log/mysqld.log
 > 020620 02:32:00  mysqld started
 > 020620  2:32:01  /usr/libexec/mysqld: Can't find file: './mysql/host.frm' 
 > (errno: 13)
 > 020620 02:32:01  mysqld ended
 > 
 > 020620 02:35:22  mysqld started
 > 020620  2:35:22  /usr/libexec/mysqld: Can't find file: './mysql/host.frm' 
 > (errno: 13)
 > 020620 02:35:22  mysqld ended


>rshapiro@bbn.com writes:
>Sounds like you started the daemon improperly, in particular with
>wrong working directory.  That's what happens when you're playing
>around at 2:30 in the morning :)
>How did you start it?  Did you use safe_mysqld?


- i did use safe_mysqld, it appears that i had an oversight, 
Shouldn't these be mysql.root rather than root.root?
chown -R mysql /var/lib/mysql

- thanks