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 problem

Discussion in 'General Discussion' started by Easy-Host.nl, Sep 14, 2004.

  1. Easy-Host.nl

    Easy-Host.nl Member

    Joined:
    Sep 14, 2004
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    How can i install the mysql server under cpanel?
    Mysql giva a error mysql () failed.

    thnxs

    Dennis
     
  2. drmike

    drmike Active Member

    Joined:
    Jul 8, 2004
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Charlotte, NC
    Should already be installed. Check to see if it's listed under Service Status link within WHM. Also try doing a restart further down the menu.

    Suggestion - Only one post is probably needed for an issue. :)

    -drmike
     
  3. AbeFroman

    AbeFroman BANNED

    Joined:
    Feb 16, 2002
    Messages:
    654
    Likes Received:
    1
    Trophy Points:
    0
    Type
    /etc/rc.d/init.d mysql restart
    mysqladmin processlist
    ls /tmp | grep sock


    then
    tail -50 /var/log/messages
    tail -50 /var/lib/mysql/*.err

    paste results here
     
  4. Easy-Host.nl

    Easy-Host.nl Member

    Joined:
    Sep 14, 2004
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1

    root@server [~]# /etc/rc.d/init.d mysql restart
    -bash: /etc/rc.d/init.d: is a directory

    root@server [~]# mysqladmin processlist
    -bash: mysqladmin: command not found

    root@server [~]# ls /tmp | grep sock
    mysql.sock@

    Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
    If you do not want to use transactional InnoDB tables, add a line
    skip-innodb
    to the [mysqld] section of init parameters in your my.cnf
    or my.ini. If you want to use InnoDB tables, add to the [mysqld]
    section, for example,
    innodb_data_file_path = ibdata1:10M:autoextend
    But to get good performance you should adjust for your hardware
    the InnoDB startup options listed in section 2 at
    http://www.innodb.com/ibman.html
    /usr/libexec/mysqld: ready for connections


    can you help me?

    Thnxs


    Sep 15 06:25:32 server proftpd[31918]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 06:33:52 server proftpd[32312]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 06:33:52 server proftpd[32312]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 06:47:13 server proftpd[32535]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 06:47:13 server proftpd[32535]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 06:55:33 server proftpd[32695]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 06:55:33 server proftpd[32695]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:03:54 server proftpd[692]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 07:03:54 server proftpd[692]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:12:15 server proftpd[771]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 07:12:15 server proftpd[771]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:15:35 server proftpd[1136]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 07:15:35 server proftpd[1136]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:23:56 server proftpd[1414]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 07:23:56 server proftpd[1414]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:32:17 server proftpd[1577]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 07:32:17 server proftpd[1577]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:40:37 server proftpd[2052]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 07:40:37 server proftpd[2052]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 07:53:58 server proftpd[2111]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 07:53:58 server proftpd[2111]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:02:18 server proftpd[2466]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 08:02:18 server proftpd[2466]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:10:39 server proftpd[2777]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 08:10:39 server proftpd[2777]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:19:00 server proftpd[2901]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 08:19:00 server proftpd[2901]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:27:20 server proftpd[3353]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 08:27:20 server proftpd[3353]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:35:41 server proftpd[3455]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 08:35:41 server proftpd[3455]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:39:02 server proftpd[3778]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 08:39:02 server proftpd[3778]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:47:22 server proftpd[4083]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 08:47:22 server proftpd[4083]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:55:43 server proftpd[4472]: server.web2host.nl (localhost[127.0.0.1]) - FTP session opened.
    Sep 15 08:55:43 server proftpd[4472]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 08:59:30 server sshd(pam_unix)[4661]: check pass; user unknown
    Sep 15 08:59:30 server sshd(pam_unix)[4661]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=220.73.215.151
    Sep 15 08:59:35 server sshd(pam_unix)[4672]: check pass; user unknown
    Sep 15 08:59:35 server sshd(pam_unix)[4672]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=220.73.215.151
    Sep 15 09:09:03 server proftpd[4735]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 09:09:03 server proftpd[4735]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 09:17:24 server proftpd[4895]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 09:17:24 server proftpd[4895]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 09:25:45 server proftpd[5358]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 09:25:45 server proftpd[5358]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 09:34:05 server proftpd[5416]: server.web2host.nl (localhost[127.0.0.1]) - FTP no transfer timeout, disconnected
    Sep 15 09:34:05 server proftpd[5416]: server.web2host.nl (localhost[127.0.0.1]) - FTP session closed.
    Sep 15 09:35:32 server sshd(pam_unix)[5689]: session opened for user root by (uid=0)
     
  5. Easy-Host.nl

    Easy-Host.nl Member

    Joined:
    Sep 14, 2004
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1


    Dear, ..

    - When i go to PHPMyAdmin give this Wrong username/password. Access denied

    - Mysql_001.jpg
    - Mysql_002.jpg

    Can somebody help my? I pay him.

    Dennis
     
  6. zentity

    zentity Well-Known Member

    Joined:
    Jun 16, 2004
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Try to enter the start/stop command for mysql correctly (You had a space between init.d and mysql

    Make sure all servers are closed

    killall -9 mysqld

    /etc/init.d/mysql stop
    /etc/init.d/mysql start

    Does MySQL start now for you?

    If not then maybe

    /scripts/updatenow && /scripts/sysup && /scripts/rpmup

    will help installing anything that is missing.

    Look at the error logs too for MySQL (usually /var/lib/mysql/hostname.err or /var/log/hostname.err) to see why it won't start if thats the case.
     
    #6 zentity, Sep 15, 2004
    Last edited: Sep 15, 2004
Loading...

Share This Page