Results 1 to 10 of 22

Thread: MySQL not working

Threaded View

  1. #1
    Join Date
    Apr 2013
    Beans
    12

    MySQL not working

    Hello, I am now on this forum and I need help with my MySQL Server which is on my VPS with Ubuntu 12.10 Server.

    Everything was fine 'till today, when I tried to login to PhpMyAdmin (as root) and I got theese two errors:


    Code:
    #2002 Cannot log in to the MySQL server
    Connection for controluser as defined in your configuration failed

    So I googled for the solution, found something and commented theese lines in phpmyadmin config:

    Code:
    $cfg['Servers']['$i']['controluser'] and $cfg['Servers']['$']['controlpass']
    Now the error I was getting changed to

    Code:
    #2003 Cannot log in to the MySQL server
    
    
    So I tried to access mysql from my VNC Client, I logged in as root and typed

    Code:
    $ mysql


    and I got this error:

    Code:
    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


    I checked and I couldn't find that file!
    I tried creating it with touch, but didn't work..

    Then I tried to start/restart mysql service but when I type service mysql stop/start/restart I get:

    Code:
    Job failed to start!
    I also tried reinstalling mysql, php and apache2 and nothing worked!!
    Please help me, my MC servers can't work without MySQL!

    P.S.
    Today I changed ServerName in apache config because I was getting an error when I typed service apache restart:

    Code:
    Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName
    I'm not sure does that have anything to do with my MySQL problem.

    And there is one little thing I did in sudoers (by typing visudo):
    I wanted to execute commands from php as root so I added this line at the end of the file:

    Code:
    www-data ALL=NOPASSWD: ALL
    Unfortunately, it didn't work so I removed that line..

    Please help A.S.A.P.!

    Thank you very much,
    Leon Grdic
    Last edited by TheLG; April 4th, 2013 at 07:37 PM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •