I am geting error message, could some one tell me how to fix it. Thanks much [email protected]:~$ mysqladmin -u root password mysqlpassword mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' [email protected]:~$ mysqladmin -h monitorwaves.no-ip.org -u root password mysqlpassword [email protected]:~$ 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)' [email protected]:~$ 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>
If you have set a password before, then you must use Code: mysqladmin -u root -pcurrentpassword password newpassword (there's no space between -p and currentpassword!).
I am still having problems connecting to my sql server. [email protected]:~/Desktop$ mysqladmin -u root -psqladmin007 password bondsql007 [email protected]:~/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' [email protected]:~/Desktop$ hostname monitorwaves.no-ip.org [email protected]:~/Desktop$ hostname -f monitorwaves.no-ip.org [email protected]:~/Desktop$ what els can i do to fix this? Thanks
Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com
Way does mysql not have a host name? and how can i give it one. [email protected]:~$ 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-
It does have a hostname. Go to the mysql.users table in your MySQL database, and you'll see your hostname there.