Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 8th June 2006, 21:47
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Unhappy 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>

Last edited by badgerbox76; 9th June 2006 at 03:14.
Reply With Quote
Sponsored Links
  #2  
Old 9th June 2006, 12:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Have you set any root mysql password before?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 9th June 2006, 18:35
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Default

yes i have set the root password for the mysql server and was entering.
Reply With Quote
  #4  
Old 10th June 2006, 00:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

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!).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 14th June 2006, 01:45
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Red face

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
Reply With Quote
  #6  
Old 14th June 2006, 02:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 14th June 2006, 19:35
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Default

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-
Reply With Quote
  #8  
Old 15th June 2006, 17:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

It does have a hostname. Go to the mysql.users table in your MySQL database, and you'll see your hostname there.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 18:58
MySQL Problems after Upgrade DiOmega Installation/Configuration 8 17th November 2006 22:35
Can't set up root password on MySQL server for Ubuntu 6.06 simianstyle Installation/Configuration 15 19th June 2006 17:44
problems mysql rayit General 15 1st April 2006 05:57
postfix - php -mysql setup problems!! matto1376 Server Operation 17 30th November 2005 16:43


All times are GMT +2. The time now is 06:57.


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