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.

MySQL4.1.19 downgrade to MySQL4.0.27 for MB Languages user

Discussion in 'General Discussion' started by Shinichi Kato, Jul 8, 2006.

  1. Shinichi Kato

    Shinichi Kato Well-Known Member

    Joined:
    Mar 7, 2005
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Saitama-ken,japan
    Hi, MultiByteLanguages usrs.
    I'm using Japanese usr.

    I have had some problems (Garble) in doing MySQL upgrade 4.1.19.
    Because I thought about the downgrade of MySQL, it introduces it here.
    If a better method matches elsewhere, please teach me.

    However, an evil is over this work.
    These are self-responsibilities entirely.
    A database user disappears.


    edit:
    Code:
    vi /var/cpanel/cpanel.config
    mysql-version4.1 >> mysql-version4
    usemysqloldpass=1 >> usemysqloldpass=0
    edit:
    Code:
    vi /etc/my.cnf
    old-passwords=1 >> #old-passwords=1
    rename save:
    Code:
    mv /var/lib/mysql/mysql /var/lib/mysql/mysql.bak
    make dir:
    Code:
    mkdir /var/lib/mysql/mysql
    change owner:
    Code:
    chown mysql:mysql /var/lib/mysql/mysql
    command:
    Code:
    /scripts/mysqlup --force to --force reinstall
     
    #1 Shinichi Kato, Jul 8, 2006
    Last edited: Jul 8, 2006
  2. smb488292

    smb488292 Registered

    Joined:
    Dec 4, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Japan
    Better to upgrade to MySQL version 5.0.21-standard via WHM. That should fix your mojibake (garbled character) problem.
     
Loading...

Share This Page