mysql troubles

Dennis Olvany dennisolvany at gmail.com
Mon Mar 14 07:03:33 PST 2005 

just installed it and having trouble getting it going
fresh mysql4.1 install on fbsd5.3


bsd# mysqladmin flush-privileges
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
bsd# mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_category.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_category.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_category.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:34 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_topic.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)
050314  7:15:35 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_relation.frm' (errno: 13)

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h bsd.carcass.us password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
bsd#

More information about the freebsd-questions mailing list