HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Ubunutu 6.06 mysql setup problems (http://www.howtoforge.com/forums/showthread.php?t=4780)

badgerbox76 8th June 2006 21:47

Ubunutu 6.06 mysql setup problems
 
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 9th June 2006 12:13

Have you set any root mysql password before?

badgerbox76 9th June 2006 18:35

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

falko 10th June 2006 00:33

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

badgerbox76 14th June 2006 01:45

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 14th June 2006 02:12

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com

badgerbox76 14th June 2006 19:35

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 15th June 2006 17:35

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


All times are GMT +2. The time now is 00:58.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.