MySQL Problems

[badgerbox76]

I am having problems loging into the server.

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$


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$

[Ben]

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....

[badgerbox76]

how do i change mysql root password?

[falko]

Have a look here: http://www.howtoforge.com/forums/showpost.php?p=8624&postcount=5