MySQL Problems

Discussion in 'Installation/Configuration' started by badgerbox76, Jul 16, 2006.

  1. badgerbox76

    badgerbox76 Member

    I am having problems loging into the server.

    Code:
    [email protected]:/etc/mysql$ mysqladmin -u root password bondsql007
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    [email protected]:/etc/mysql$ mysqladmin -u root -p bondsql007
    Enter password:
    mysqladmin: Unknown command: 'bondsql007'
    [email protected]:/etc/mysql$
    
    Code:
    [email protected]:/etc/mysql$ netstat -tap
    (Not all processes could be identified, non-owned process info
     will not be shown, you would have to be root to see it all.)
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 *:mysql                 *:*                     LISTEN     -
    tcp        0      0 monitorwaves.no-:domain *:*                     LISTEN     -
    tcp        0      0 localhost.locald:domain *:*                     LISTEN     -
    tcp        0      0 localhost.localdoma:ipp *:*                     LISTEN     -
    tcp        0      0 localhost.localdo:50519 *:*                     LISTEN     -
    tcp        0      0 localhost.localdo:39065 *:*                     LISTEN     -
    tcp        0      0 localhost.localdoma:953 *:*                     LISTEN     -
    tcp        0      0 monitorwaves.no-i:55814 www.hardhathosting.:www ESTABLISHED5150/firefox-bin
    tcp        0      0 monitorwaves.no-i:42764 web10.hosting365.ie:www ESTABLISHED5150/firefox-bin
    tcp        0      0 monitorwaves.no-i:49720 dyna-ffday.nslb.sj.:www ESTABLISHED5150/firefox-bin
    tcp        0      0 monitorwaves.no-i:46747 server1.howtoforge.:www ESTABLISHED5150/firefox-bin
    tcp        0      0 monitorwaves.no-i:58013 ostg.com:www            ESTABLISHED5150/firefox-bin
    tcp        0      0 localhost.localdo:50519 localhost.localdo:59801 ESTABLISHED-
    tcp        0      0 localhost.localdo:59801 localhost.localdo:50519 ESTABLISHED-
    tcp        0      0 monitorwaves.no-i:57475 www.hardhathosting.:www ESTABLISHED5150/firefox-bin
    tcp6       0      0 *:ssh                   *:*                     LISTEN     -
    tcp6       0      0 ip6-localhost:953       *:*                     LISTEN     -
    tcp6       0      0 monitorwaves.no-ip.:ssh ::ffff:192.168.0.1:1061 ESTABLISHED-
    [email protected]:/etc/mysql$
    
     
  2. Ben

    Ben ISPConfig Developer ISPConfig Developer

    As you can see in your first quote, your syntax starting mysql is not correct.
    Start is with
    mysql -u root -p
    and hit enter, type you pwd then if it asks you for.

    Never post your passwords here, sb. just need to find an url on your server, with e.g. phpMyAdmin and may have fun with your DB....
     
  3. badgerbox76

    badgerbox76 Member

    how do i change mysql root password?
     
  4. falko

    falko Super Moderator ISPConfig Developer

Share This Page