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.

some question (newbie)

Discussion in 'General Discussion' started by bugs, Dec 3, 2005.

  1. bugs

    bugs Member

    Joined:
    Dec 3, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    hello there.
    i'm quite verry new with cpanel & web host manager, so i vahe two basic questions.
    how can i setup my mysql server. i can't create any database because it tells me in phpMyAdmin that i have the wrong username or password. and when i click on Change a User or Database Password, it gives me ERROR 2002: Can't connect to mysql server though socket '/tmp/mysql.sock' (111).

    The secound question, is, after i make the hosting pack's, how can i add users? i tried to add them from Account Function -> Create a new account, it tells me that is done, but i can't connect.

    I have only one ip for the moment, the rest of them must come in a few days.

    thank you.
     
  2. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Hello,

    Mysql is not running on the server. Did you try to restart the mysql service from WHM?. if not try it now. If it don't help, try the following scripts from shell.

    /scripts/mysqlup

    What error did you get?.
     
  3. bugs

    bugs Member

    Joined:
    Dec 3, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Ok, i've done what you said. But when i restarted the mysql service the following error occured :

    Code:
    Attempting to restart mysql  	
    Waiting for mysql to restart.... . . . . . . . . . . finished.
    
    mysql status
    
    root     27104  0.0  0.0  2040 1048 ?        S    14:28   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/opticknet.com.pid
    mysql    27373  9.4  0.0 22204 8164 ?        R    14:29   0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/opticknet.com.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock
    
    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").
    When I typed /scripts/mysqlup in shell it told me this :

    Code:
    /scripts/mysqlup
    MySQL Setup Script Version 6.1
    Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Unable to retrieve file
    Done
    This is the MySQL  installer release number  for platform
    MySQL- is up to date
    Install Complete
    then i tryed to restart the mysql from WHM and the same error occured. What is wrong ?
     
  4. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Hello,

    Try the command and then restart mysql

    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
     
  5. bugs

    bugs Member

    Joined:
    Dec 3, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    not working

    Code:
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    ln: `/tmp/mysql.sock': File exists
    
     
  6. bugs

    bugs Member

    Joined:
    Dec 3, 2005
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    It's done

    ok, 10x, but i haved managed to get it worked.
    i found a topic here with the same problem.
     
  7. Izzee

    Izzee Well-Known Member

    Joined:
    Feb 6, 2004
    Messages:
    469
    Likes Received:
    0
    Trophy Points:
    16
    For future users who might have the same issue would you mind either linking to the topic where you found the solution or posting your fix here please.
    Thanks. :)
     
Loading...

Share This Page