The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql 4.0 and cpanel new installation

Discussion in 'General Discussion' started by heavypredator, Jul 12, 2006.

  1. heavypredator

    heavypredator Well-Known Member

    Joined:
    May 2, 2003
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    I see that with new cpanel installations we dont have mysql 4.0 opion in whm anymore.

    Im planning server upgrade but i still want to use mysql 4.0 - anyone know how to do this?
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    You would have to do this before creating any MySQL d/b's:

    edit /var/cpanel/cpanel.config and set mysql-version=4

    Run /scripts/mysqlup --force
     
  3. heavypredator

    heavypredator Well-Known Member

    Joined:
    May 2, 2003
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    thx

    another problem may be that i will get rhe4 and will have to update to 4.1

    i heard much about characters encoding in 4.1 - when updating mysql to 4.1 how can i chose what encoding will be used durning update?
     
  4. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    if you get a brand new server why don't you do mysql 5 ? you will be going on a brand new stable software with no need to upgrade to anything in the near future... my opinion
     
  5. elix

    elix Well-Known Member

    Joined:
    Jan 18, 2005
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    6
    MySQL 5 doesn't work with a fair amount of applications, even still. Though it's fine if you're just running some of your own sites and not any clients (who would complain if their sites break ;)).

    Though, I definitely would not recommend 4.0.x. 4.1.x is the version to run if you want a stable solution, IMHO. If you are moving from another server there should not be any problems and I don't think there are any character encoding problems either, but feel free to enlighten me if there are ;)
     
  6. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    that depends on the applications you might intend to run. still we're in 2006 not in the ace age.
     
  7. heavypredator

    heavypredator Well-Known Member

    Joined:
    May 2, 2003
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    1st problem durning mysqlup

    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    looks like mysql is not eaven starting.
     
    #7 heavypredator, Jul 17, 2006
    Last edited: Jul 17, 2006
  8. goodgbb

    goodgbb Well-Known Member

    Joined:
    Aug 15, 2005
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Thailand
    Connnection is impossible

    Code:
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    Unable to reset root MySQL password. at /scripts/securemysql line 150.
    Install Complete
     
  9. goodgbb

    goodgbb Well-Known Member

    Joined:
    Aug 15, 2005
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Thailand
    I can't start MySQL service.

    Code:
    060824 02:51:49  mysqld started
    060824  2:51:49  InnoDB: Started
    060824  2:51:49 /usr/sbin/mysqld: Can't open file: 'host.MYI'. (errno: 142)
    060824  2:51:49 Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
    060824  2:51:49 Aborting
     
    #9 goodgbb, Aug 24, 2006
    Last edited: Aug 24, 2006
  10. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    I am receiving this same issue as a result of :

    edit /var/cpanel/cpanel.config and set mysql-version=4

    Run /scripts/mysqlup --force

    Did you get it resolved?




    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

    I have ran

    rm -f /tmp/mysql.sock
    rm -f /var/tmp/mysql.sock
    /etc/init.d/mysql stop
    rm -f /var/lib/mysql/mysql.sock
    /etc/init.d/mysql start
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock

    but receive the same error when restarting mysql.

     
  11. heavypredator

    heavypredator Well-Known Member

    Joined:
    May 2, 2003
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    8
    i just upgraded to 4.1 - did not have any problems with that.
     
  12. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    With 4.1 I wouldn't think so.

     
  13. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Rebuilding my.cnf and then running

    cp -fr /var/lib/mysql /var/lib/mysql.old
    rm -fr /var/lib/mysql
    rm -f /usr/sbin/mysqld
    /scripts/mysqlup --force

    does the trick.
     
  14. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    cPanel does recommend new servers run MySQL 5 instead of 4 mainly due to the fact it is nearly inevitable that at some point in the future you will need to upgrade to version 5.x or higher.

    It's a lot easier to upgrade now and have all of your code functioning on MySQL 5 than to experience a painful upgrade later on when you may need to re-code your applications to work with MySQL 5 (which it appears many have already been forced to do). A MySQL upgrade may be smooth but on some systems it can be quite bumpy.

    Personally, I'd rather be doing this now on a fresh server rather than when there's some mission critical website on that server.
     
  15. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
    im running mysql 5 for a few months already and i have seen no broken apps with it. i always prefer to stick with applications that are current and recommended, and not with software that might become EOL soon, this is why i have chosen centos over fedora as well. makes not obvious sense here but get my point.
     
Loading...

Share This Page