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 - Help with Installing - Please!

Discussion in 'Database Discussions' started by ladierainy, May 1, 2004.

  1. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    I need some serious help I think!

    I've navigated my way through most of everything I needed to, and had help here and there along the way which I was very thankful for - so I am reaching out to those that may have the answers yet again in a plea for giving this blonde a serious clue, lol.

    I guess I need to (re)install MySQL *wah!*

    This is all that comes up when I click on phpMyAdmin:
    X-Powered-By: PHP/4.2.3 Content-Type: text/html; charset=iso-8859-1

    That happens all all users and root.

    In my WHM, when I click on: Change a User or Database Password, it tells me Mysql is not installed.

    I *thought* I had installed it, I'm pretty sure I had accessed it when I first set it up - root wise and user wise - so I am at a complete loss as to what is wrong, or even how to determine what is wrong.

    I'm on a Linux server, using RedHat 3, WHM 9.2.0, Cpanel 9.2.0, WHM x v2.1.2.

    PhP is I believe 4.3.

    Can anyone pleeeeeeeease help me? I've been searching forums for two days now and haven't come across anyone that seems to be having this same issue.

    Thank you for your time!
     
  2. fwwebs

    fwwebs Well-Known Member

    Joined:
    Feb 16, 2004
    Messages:
    329
    Likes Received:
    0
    Trophy Points:
    16
    I'm not sure but if MySQL is installed try starting it with './mysqld start' in the /usr/sbin directory. If it's already running, it will tell you.

    Another possibility is to go to 'Update Apache' in WHM and rebuild it with the PHP 'Mysql module' option.
     
  3. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for your reply!

    The mysql module is checked in the Update Apache - I've run it a few times, and rebooted the server to no avail - I'll try the command to see if it is running, thanks!
     
  4. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Interesting - I have NO idea what to make of what it told me:

    root@server [/usr/sbin]# ./mysqld start
    040501 1:23:23 Can't start server: Bind on TCP/IP port: Address already in use
    040501 1:23:23 Do you already have another mysqld server running on port: 3306 ?
    040501 1:23:23 Aborting

    040501 1:23:23 ./mysqld: Shutdown Complete

    I also notice there is a "Use System Mysql" option in Update Apache that is NOT checked. Should it be?

    Thanks for any help anyone can give me!
     
  5. wipl_piyush

    wipl_piyush Well-Known Member

    Joined:
    Oct 31, 2003
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    NY
    Try killing all the running processes of mysqld. and then start it

    root@server#killall -TERM mysqld
    root@server#killall -TERM mysqld

    root@server#service mysql start
     
  6. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Hmmmm that didnt seem to work or I just did it incorrectly, I got this:

    root@server#killall -TERM mysqld
    -bash: root@server#killall: command not found


    When I tried it this way:

    #killall -TERM mysqld

    I got nothing at all.

    When I tried it a second time (cuz it looked like I was supposed to do it twice) I got this:
    mysqld: no process killed

    Then when I did:
    service mysql start

    I got nothing at all.

    Or was that what was supposed to happen? lol

    Thanks so much for trying to help me - it's very appreciated! :)
     
  7. wipl_piyush

    wipl_piyush Well-Known Member

    Joined:
    Oct 31, 2003
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    NY
    Try running the start twice or thrice and check you got this message or not

    #service mysql start (first time )
    #service mysql start (second time)
    A mysqld process already exists

    If you got above message then, run

    #mysql

    Now check you got the mysql prompt or not..if yes then mysql is running fine....
     
  8. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    In root, right?
     
  9. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Hmm when done in root - there is no response or message at all, it just sits there.

    Like me,,, while I watch for it to do somethng. LOL!
     
  10. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    *sigh* Still can't seem to fix this - ugh!

    Anyone else have any ideas?
     
  11. ladierainy

    ladierainy Well-Known Member

    Joined:
    Dec 1, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    I've been searching for days - still nothing!

    What in the world can I possibly do to fix this?

    Please help!
     
  12. mattyuk

    mattyuk Registered

    Joined:
    Nov 20, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Sorry for the bump on such an old post. I've having the same problem, can't find an answer anywhere. Any ideas?
     
Loading...

Share This Page