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.

changed hostname, now major mysql problems

Discussion in 'General Discussion' started by t17169, Feb 1, 2006.

  1. t17169

    t17169 Member

    Joined:
    Jan 30, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    For 5 days, been trying to configure my VPS so I can get sites up...not happening. Went thru a dns loop, finally resolved. Host name changed. Next was the seemingly rite of passage issue of PHPmyadmin, wrong username, permission denied. Using solutions suggested here turned out not to be my problem.

    MySql path in former hostname/nameserver and I do not know how to change.

    Originally account name and therefore hostname was elcascoantiguo.com...using server nameservers after adding two dot hostname, became system elcascoantiguo.com and panama.vzservers.com <---OLD!

    However, now, system is mediodiablo.com / hostname panama.mediodiablo.com / nameserver ns1 and 2.mediodiablo.com

    MySql install is good, but paths are now wrong. See below. how do I resolve?

    root@panama [~]# ls -l /var/lib/mysql
    total 20563
    drwxr-x--x 9 mysql mysql 1024 Jan 31 23:29 ./
    drwxr-xr-x 11 root root 1024 Jan 27 23:40 ../
    drwx------ 2 mysql mysql 1024 Jan 30 03:26

    Cpanel::Mysql\=HASH(0x81ad0f8)/
    drwx------ 2 mysql mysql 1024 Jan 31 16:37

    Cpanel::Mysql\=HASH(0x8316e10)/
    drwx------ 2 mysql mysql 1024 Jan 29 13:35

    Cpanel::Mysql\=HASH(0x8316e78)/
    drwx------ 2 mysql mysql 1024 Jan 31 23:29

    Cpanel::Mysql\=HASH(0x8316e80)/
    -rw-rw---- 1 mysql mysql 2039 Jan 31 02:13 elcascoantiguo.com.err
    -rw-rw---- 1 mysql mysql 6 Jan 29 12:23 elcascoantiguo.com.pid
    -rw-rw---- 1 mysql mysql 25088 Jan 29 12:23 ib_arch_log_0000000000
    -rw-rw---- 1 mysql mysql 5242880 Jan 31 02:13 ib_logfile0
    -rw-rw---- 1 mysql mysql 5242880 Jan 29 12:23 ib_logfile1
    -rw-rw---- 1 mysql mysql 10485760 Jan 29 12:23 ibdata1
    drwx------ 2 mysql mysql 1024 Jan 27 23:40 mysql/
    srwxrwxrwx 1 mysql mysql 0 Jan 31 02:13 mysql.sock=
    -rw-rw---- 1 mysql mysql 273 Jan 31 02:13

    panama.vzservers.com.err
    -rw-rw---- 1 mysql mysql 6 Jan 31 02:13

    panama.vzservers.com.pid
    drwx------ 2 mysql mysql 1024 Jan 27 23:40 phpmyadmin/
    drwx------ 2 mysql mysql 1024 Jan 27 23:40 test/
    root@panama [~]#
     
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    for your hostname check your

    /etc/hosts file and correct as necessary

    for your root phpmyadmin access

    reset MySQL Root Password in whm and insure threre are no ""'s around the passworrd in
    /root/.my.cnf
     
  3. t17169

    t17169 Member

    Joined:
    Jan 30, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    tried /etc/hosts

    permission denied
     
  4. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    you need to use an editor vi, pico, nano
     
  5. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    You are on a VPS so you cannot change the hostname from your end. The Hostname for your VPS can be changed from the main VPS server on which your vps is created. You will have to ask your Hosting company to change the hostname for you.

    Here is the command to change the hostname :-
    vzctl set VEID --hostname your.hostname.name --save
    where,
    VEID is your vps ID.
     
  6. taotoon

    taotoon Well-Known Member

    Joined:
    Nov 14, 2004
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Thanks ShekHar to tell me that.. very good info.
     
Loading...

Share This Page