Forums

Subscribe via email Subscribe via email
Subscribe via rss
Guest
or Ask a Question
Add a reply View Replies (5) →
speedmaster
speedmaster
Offline

MySQL admin fails

Resolved
0 votes
Hi,
I freshly installed ClearOS Enterprise Version 5.1.
While trying to install some more of the stuff I used to use in ClarkConnect, I failed in the MySQL admin.

Services are running but while trying to go to https://myip:81/mysql it fails
phpMyAdmin - Error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

In terminal mode I get more or less the same error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any help on a fresh system available?

/bernd
In Database
Monday, December 28 2009, 11:13 PM
Subscribe via email
Share this post:
Responses (5)

  • Accepted Answer

    Tim Burgess
    Tim Burgess
    Offline
    Monday, December 28 2009, 11:54 PM - #Permalink
    Resolved
    0 votes
    Have you logged into the webconfig to create the mysql password first? and also started the mysql service?
    The reply is currently minimized Show

  • Accepted Answer

    speedmaster
    speedmaster
    Offline
    Tuesday, December 29 2009, 10:10 AM - #Permalink
    Resolved
    0 votes
    Services are running.
    When trying to change password, I am asked as well for the old one.... but either way, I get the following error on the web-console:
    error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
    The reply is currently minimized Show

  • Accepted Answer

    Tim Burgess
    Tim Burgess
    Offline
    Tuesday, December 29 2009, 01:04 PM - #Permalink
    Resolved
    0 votes
    Hmm ..what does the following give?
    netstat -ltpn | grep mysql

    Have any of your other applications added / modified mysql in any way?
    The reply is currently minimized Show

  • Accepted Answer

    speedmaster
    speedmaster
    Offline
    Tuesday, December 29 2009, 03:09 PM - #Permalink
    Resolved
    0 votes
    hi,
    netstat gives
    [root@home ~]# netstat -ltpn | grep mysql
    
tcp        0      0 127.0.0.1:9092              0.0.0.0:*                   LISTEN      4089/mysqld
    
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      3905/mysqld
    
tcp        0      0 127.0.0.1:3308              0.0.0.0:*                   LISTEN      3767/system-mysqld


    mysql is that fresh that I assume that it should be still untouched.

    BTW: what might be the initial password (in case I would like to change the password via the ClearOS webconsole)?
    The reply is currently minimized Show

  • Accepted Answer

    speedmaster
    speedmaster
    Offline
    Tuesday, December 29 2009, 03:13 PM - #Permalink
    Resolved
    0 votes
    HALT

    it works now! I HAVE NO IDEA WHAT I CHANGED! just a couple of reboots (I did some before!) and I could reset the password!

    I have no clue how it healed itself?

    /bernd
    The reply is currently minimized Show
Your Reply