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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th June 2006, 11:05
simianstyle simianstyle is offline
Junior Member
 
Join Date: Jun 2006
Location: The East Coast
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default Can't set up root password on MySQL server for Ubuntu 6.06

I've been following the Ubuntu 6.06 "perfect setup" tutorial word for word - and yet the MySQL part doesn't seem to work for me. Whenever i try and set the password at this point:
Code:
mysqladmin -h transit.example.com -u root password yourrootsqlpassword
I always get the error:

Code:
mysqladmin: connect to server at 'transit.example.com' failed
error: 'Host 'transit.example.com' is not allowed to connect to this MySQL server'
As you can tell, instead of calling my server "server1", i've decided to call it "transit". The static IP of the server within my network is 192.168.1.102, and i've set the root sql password already in this step:

Code:
mysqladmin -u root password yourrootsqlpassword
It's obviously somethign other than "yourrootsqlpassword", but when i try and connect to my server - it won't allow me. I'm doing this all on the local machine (not using PuTTY or anything), and instead of the Ubuntu server edition - i'm using the desktop edition (although it should still work the same for both).

I'd appreciate any help resolving this issue. Thanks.
Reply With Quote
Sponsored Links
  #2  
Old 5th June 2006, 11:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Dont worry about that error. Proceed with the other steps and when you are finished, install the phpmyadmin pacakge in ISPConfig and check that there are no empty root passwords in the mysql user table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th June 2006, 14:07
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Also make sure that MySQL is listening on all interfaces and that your hostname is really transit.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
  #4  
Old 5th June 2006, 15:48
simianstyle simianstyle is offline
Junior Member
 
Join Date: Jun 2006
Location: The East Coast
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default

Well i finished the installation, and got everything up and running with ISPConfig. However when i navigate to the user table in the MySQL database via PHPMyAdmin, there is an empty root password. This is what i see:



I think i might've messed up somewhere because there are two root users, but only one of them have a password. I'm very new to all of this - so an advice on what i should do at this point would be greatly appreciated.
Reply With Quote
The Following User Says Thank You to simianstyle For This Useful Post:
feeninuoumn (19th December 2013)
  #5  
Old 5th June 2006, 15:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Thats OK. One root user account is for login from localhost, the other is for login from host "transit".

Just edit the root user record with the empty password, enter you password in the password field and select "PASSWORD" in the function field to encrypt your password.

To edit the password on the shell, you might try this:

Quote:
mysqladmin -h transit -u root password yourrootsqlpassword
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 5th June 2006, 16:17
simianstyle simianstyle is offline
Junior Member
 
Join Date: Jun 2006
Location: The East Coast
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default

That works perfectly Till, thanks for your help!
Reply With Quote
  #7  
Old 15th June 2006, 06:58
domino domino is offline
Senior Member
 
Join Date: Aug 2005
Posts: 364
Thanks: 0
Thanked 8 Times in 7 Posts
Default

Hi,

This is really strange. No matter if I user server1, server1.mydomaon.com, or localhost, i get the same error whe trying to set the password.
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I can not go any further in ISPConfig installation without the correct password, which have not been set. If I enter a blank pssword in ISPConfig setup it still gives me this error.
Code:
Please enter your MySQL password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
The provided MySQL password is wrong!
Reply With Quote
  #8  
Old 15th June 2006, 14:25
glennb glennb is offline
Junior Member
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I also get the same error as the OP, and I can't work out a way around it.
Having completed the install, I can reach the server on (e.g.)

https://<ipaddress>:81

and I get the login screen, but I am not able to login with a blank password, or with the password I tried to set.

Can anyone give this mysql newbie a clue how to proceed?

Thanks,

Glenn.
Reply With Quote
  #9  
Old 15th June 2006, 15:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

@domino: What commands exactly did you run that gave you these errors?

@glennb: The defaulr login after the initial ISPConfig installation is username admin, password admin, as described here: http://www.ispconfig.org/manual_installation.htm
__________________
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
The Following User Says Thank You to falko For This Useful Post:
feeninuoumn (19th December 2013)
  #10  
Old 15th June 2006, 23:47
glennb glennb is offline
Junior Member
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko@glennb: The defaulr login after the initial ISPConfig installation is username [I
admin[/I], password admin, as described here: http://www.ispconfig.org/manual_installation.htm
Ouch. Now I feel dumb.

I can login fine now, thanks. A few DNS wrinkles to iron out, but looking good!

I'm off to read the manual before asking any more stupid questions.

Thanks,

glenn.
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
monit howto Jamesk5 HOWTO-Related Questions 11 5th August 2008 15:10
Apache - Virtual hosts - ISPConfig Hans Server Operation 8 23rd April 2006 16:29
Problems installing NForce4 sound drivers Wraithfire Installation/Configuration 21 16th April 2006 17:30
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
Everything owned by root !!! wwparrish Installation/Configuration 6 7th February 2006 21:25


All times are GMT +2. The time now is 14:04.


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