Mysql problems

BODBOD
edited March 2005 in Software
I downloaded the Mysql source from Mysql's site and then configured it with the following configure line:
./configure --prefix=/usr/local/mysql --enable-assembler

And then, as recommended by the documentation, I used gmake to compile it

gmake
gmake install

Next, I changed to where mysql had been installed; and ran this:

bin/mysql_install_db --user=mysql

and it gives me lots of errors about files not being found, here is a few of them:
PuTTY wrote:
050304 21:33:59 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys
ql/help_keyword.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_keyword.frm' (errno: 13)
050304 21:33:59 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys
ql/help_keyword.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_keyword.frm' (errno: 13)
050304 21:33:59 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys
ql/help_keyword.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_keyword.frm' (errno: 13)
050304 21:33:59 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys

When I try to start the server it wont start and gives me this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Any ideas?

Comments

  • The user and all related content has been deleted.
  • What man pages would i find it under?
  • The user and all related content has been deleted.
  • Ok thanks Tom it's compiled but one slight snag, which is probably me trying to do this at 1am.

    when i run:
    bin/mysql_install_db --user=mysql
    

    it gives me the error:
    Could not find help file 'fill_help_tables.sql' in /usr/local/mysql/share/mysql or inside /usr/local/mysql.

    how do I change where it looks for those files?
  • The user and all related content has been deleted.
  • Yes I'm root for all of this, I used the configure line that you posted. And I have done "make install"
  • The user and all related content has been deleted.
  • The user and all related content has been deleted.
  • I'm using whatever the lastest version is (4.1.10 i think)

    I was meddling around earlier and got this
    bod# /usr/local/bin/mysql start
    /libexec/ld-elf.so.1: Shared object "libmysqlclient.so.14" not found, required by "mysql"
    bod#
    

    i looked in the source folder and coudlnt find anything that seemed to be related to that...
  • The user and all related content has been deleted.
  • Would it be easier to reinstall FreeBSD? The things a mess anyways
  • I just reinstalled everything, one question though, how do I start it at boot time? when i start it from the prompt it just hangs there and wont let me logout or anything
  • The user and all related content has been deleted.
Sign In or Register to comment.