Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    62

    Question Cannot install mysql 4.1.21 succesfully

    # mysql 4.1.x ??
    cd /usr/local/src
    wget http://dev.mysql.com/get/Downloads/M...rs.hoobly.com/
    tar -xzvf mysql-4.1.*.tar.gz
    cd mysql-4.1.*
    make uninstall
    make distclean
    rm config.cache
    make clean
    ./configure --prefix=/usr/local/mysql --with-static --enable-static --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/tmp/mysql.sock --with-charset=euckr
    make
    make install
    /usr/local/mysql/bin/mysql_install_db
    groupadd mysql
    useradd -M -c MySQL_Server -d /usr/local/mysql -g mysql -s /bin/nologin mysql
    useradd -g mysql mysql
    chown root.mysql -R /usr/local/mysql
    chown mysql.mysql -R /usr/local/mysql/data
    cp /etc/my.cnf /etc/my.cnf.original.bak
    cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf
    echo "/usr/local/mysql/bin/mysqld_safe &" >> /etc/rc.local
    These are the steps I've taken trying to install mysql on my vps server without success, tried installing 4 times now, no dice. What am I doing wrong? The /etc/my.cnf is either " /usr/local/mysql/share/mysql/my-huge.cnf" this one or my default one I tried too,

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    [mysql.server]
    user=mysql
    basedir=/var/lib
    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    tried changing it all up and making it as close as I could guess for my install directory of /usr/local/mysql but all without success, been trying all day withouth any progress.

    any help is very much appreciated!!!

    EDIT:

    Sorry I forgot to post the error I keep getting when trying to connect to mysql.

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    I've googled the error and tried many things, nothing is helping, lol.......
    Last edited by n00ber; 10-07-2006 at 07:48 PM.

  2. #2
    Join Date
    Nov 2004
    Location
    HK
    Posts
    310
    is your mysql daemon started?

    service mysqld restart

    if it fails to start, try looking into the log file /var/log/mysqld.log
    Rails in DA - Ruby on Rails plugin for Directdmin | DA-Tomcat - Tomcat Manager plugin for Directdmin
    DA-PgSQL - PostgreSQL plugin for Directdmin | IP Deny Manager - IP Deny Manager plugin for Directdmin
    DeeperAdmin - Manager your DirectAdmin server "deeper"
    Order now at http://www.daplugin.com

  3. #3
    Join Date
    May 2006
    Posts
    560
    Run: /etc/init.d/mysqld start

    If that doesn't work, check your logs and post back here!

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore
    Posts
    1,889
    From your post, you install mysql from source and it is in /usr/local... thus your datadir shouldn't be in /var/lib/mysql I guess... Please find out which is your correct mysql datadir or simply remove the /etc/my.cnf and start mysql to see whether is mysql able to get started?
    Giam Teck Choon
    :: Join choon.net Community today to share your tips and tricks on server issues please ::
    :: Singapore Dedicated Servers :: Singapore Virtual Private Servers :: Linux/FreeBSD Server Management ::

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •