Ubunutu 6.06 mysql setup problems

[badgerbox76]

I am geting error message, could some one tell me how to fix it. Thanks much


admin@admin-desktop:~$ mysqladmin -u root password mysqlpassword
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
admin@admin-desktop:~$ mysqladmin -h monitorwaves.no-ip.org -u root password mysqlpassword
admin@admin-desktop:~$ mysqladmin -h monitorwaves.no-ip.org -u root password mysqlpassword
mysqladmin: connect to server at 'monitorwaves.no-ip.org' failed
error: 'Access denied for user 'root'@'admin-desktop' (using password: NO)'
admin@admin-desktop:~$

hosts
<CODE>
192.168.0.105 admin-desktop monitorwaves.no-ip.org
127.0.0.1 localhost admin-desktop

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
</CODE>

[till]

Have you set any root mysql password before?

[badgerbox76]

yes i have set the root password for the mysql server and was entering.

[falko]

If you have set a password before, then you must use

mysqladmin -u root -pcurrentpassword password newpassword(there's no space between -p and currentpassword!).

[badgerbox76]

I am still having problems connecting to my sql server.

admin@monitorwaves:~/Desktop$ mysqladmin -u root -psqladmin007 password bondsql007
admin@monitorwaves:~/Desktop$ mysqladmin -h monitorwaves.no-ip.org -u root password bondsql007
mysqladmin: connect to server at 'monitorwaves.no-ip.org' failed
error: 'Host 'monitorwaves.no-ip.org' is not allowed to connect to this MySQL server'
admin@monitorwaves:~/Desktop$ hostname
monitorwaves.no-ip.org
admin@monitorwaves:~/Desktop$ hostname -f
monitorwaves.no-ip.org
admin@monitorwaves:~/Desktop$

what els can i do to fix this? Thanks

[falko]

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

[badgerbox76]

Way does mysql not have a host name? and how can i give it one.

admin@monitorwaves:~$ netstat -tap
(No info could be read for "-p": geteuid()=1000 but you should be root.)
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:36233 *:* LISTEN -
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.localdoma:953 *:* LISTEN -
tcp 0 0 localhost.localdo:43423 *:* LISTEN -
tcp 0 0 localhost.localdo:60349 localhost.localdo:36233 ESTABLISHED-
tcp 0 0 localhost.localdo:36233 localhost.localdo:60349 ESTABLISHED-
tcp6 0 0 *:ssh *:* LISTEN -
tcp6 0 0 ip6-localhost:953 *:* LISTEN -
tcp6 0 1036 monitorwaves.no-ip.:ssh ::ffff:192.168.0.1:3327 ESTABLISHED-

[falko]

It does have a hostname. Go to the mysql.users table in your MySQL database, and you'll see your hostname there.