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.

 

Also make sure that MySQL is listening on all interfaces and that your hostname is really transit.example.com.

 

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.

 

That works perfectly Till, thanks for your help!

 

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!

 

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.

 

@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

 

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.

 

Damn mate. I didn't get a response email about the new reply on this thread. I got those messages from the beginning of the Ubuntu installation. The weard thing is, I gave up on it and left ISPConfig install (the db part) as is and went to bed. The following morning, I typed the password and it accepted it! Damned boogie man Everything is okay now.

A little suggestion, since you have gotten a lot of questions about the initial username and password for ISPC, would it hurt to include the name and password immediately after the ISPConfig installation is finished?

 

I'm also getting the same error [root@server0 ~]# mysqladmin -u root password *******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

when i use webmin interface to login i get this error:
The full MySQL error message was : connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Following the howto I didn't get any error until finished and tried to log in to mysql. So i decided to uninstall it with this command: yum remove mysql

Then reinstall it again and now it comes with the error above. I'm not using ISPConfig. I've followed stacks of "howto reset password" and still no sunshine.

Please can someone help me get this out of the way, as all my other services i'm going to setup requires mysql login.

Thanks in advace.

 

Yes, we could include it in the message about the successful installation.

 

This means you have already set a password for MySQL. To change it, have a look here: http://www.howtoforge.com/forums/showpost.php?p=29245&postcount=4

 

Thanks Falko,
I could now log on to mysql with my new password using webmin, but for some reason it wouldn't work on the command line.

I could see only one encrypted password for user root on host local host with permission All. Another root with host server0.tld has blank space for encrypted password and permission is ALL.
Then there is 2 anonymous users, for host localhost and server0.tld with blanks for encrypted password and permission NONE.

I don't know if this gives the clear picture of the table, but can anyone help me make things right? I tried to copy and paste the table but it keeps messing up as scrumbled eggs.

Thanks alot.

 

This means you must also run

Code:

mysqladmin -h server0.tld -u root password yourrootsqlpassword