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:
    admin@monitorwaves:/etc/mysql$ mysqladmin -u root password bondsql007
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    admin@monitorwaves:/etc/mysql$ mysqladmin -u root -p bondsql007
    Enter password:
    mysqladmin: Unknown command: 'bondsql007'
    admin@monitorwaves:/etc/mysql$
    
    Code:
    admin@monitorwaves:/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-
    admin@monitorwaves:/etc/mysql$
    
     
  2. Ben

    Ben Active Member Moderator

    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 Howtoforge Staff

Share This Page