#1  
Old 3rd October 2006, 08:42
oakleeman oakleeman is offline
Junior Member
 
Join Date: Oct 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 2 Posts
Default Mysql password

I've been trying to follow the Centos setup guide and am having the mysql password problem.

Almost all of the ISPConfig tutorials have the following commands which numerous people have problems with:

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

I spent several hours on the forums tonight reading through the threads of people having problems with such and couldn't get any of the fixes to work. Could someone please elaborate on why so many people have problems with it.

I wasn't able to get it working use the above command either. I think I finally got it working using :

mysqladmin password newpassword
mysqladmin -h server1.example.com password newpassword

Last edited by oakleeman; 3rd October 2006 at 08:57.
Reply With Quote
Sponsored Links
  #2  
Old 4th October 2006, 17:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by oakleeman
I've been trying to follow the Centos setup guide and am having the mysql password problem.

Almost all of the ISPConfig tutorials have the following commands which numerous people have problems with:

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
The first command should work without problems. If you have problems with the second one, it's because there is another hostname than server1.example.com in the mysql.users table. You can forget about this now and correct it later with phpMyAdmin. Restart MySQL afterwards.
__________________
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
  #3  
Old 5th October 2006, 06:02
oakleeman oakleeman is offline
Junior Member
 
Join Date: Oct 2006
Posts: 12
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Thanks for the reply, but it makes me question if it truly is a copy-paste tutorial then since I did everything the same as the guide except for the IP. I even named it server1.example.com and used yourrootsqlpassword as the password.

Based upon the number of threads regarding this topic, it might be a good idea to explain in the tutorials that this should be expected and how to fix it. Or not even have them issue the second password change until phpmyadmin is installed.

In any case, the guides are a tremendous asset to newbies like me. I frequently see them linked to in other forums.

Last edited by oakleeman; 5th October 2006 at 07:11.
Reply With Quote
  #4  
Old 6th October 2006, 14:16
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

We'll try to make future tutorials even more error-proof.
__________________
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 22nd October 2006, 10:07
rainer rainer is offline
Junior Member
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i also had the problem on 'The Perfect Setup - Ubuntu 6.06'

its not enough to edit /etc/hosts like:
127.0.0.1 localhost.yourlocaldomain localhost
192.168.0.100 server1.example.com server1
......

you also have to edit /etc/hostname
instead of
server1
there should be
server1.example.com

after this everything worked fine on further mysql setup
Reply With Quote
  #6  
Old 22nd October 2006, 16:33
KenKnight KenKnight is offline
Senior Member
 
Join Date: Nov 2005
Posts: 137
Thanks: 0
Thanked 3 Times in 2 Posts
Default

I've used these howto's numbers times over the last few months, mainly in an attempt to become familiar with the process and also test various linux setups for performance and reliablity.

In doing so, I've encountered the mysql problem on just about all the occasions. My resolution is to open another shell window with putty and login to mysql with the following;

mysql -u root -p [enter]

At the "mysql>" prompt I issue the following statments;
Code:
mysql> use mysql;

mysql> update user set host='localhost.localdomain' where user = 'root' and host = 'localhost';
This has always allowed me to finish the ispconfig installation without problems. I will try checking the hosts and hostname on the next one to see if that corrects the problem for me also.

Cheers!
ken
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
Wrong MySQL password?? Blu3 Installation/Configuration 7 10th December 2006 18:41
Can't set up root password on MySQL server for Ubuntu 6.06 simianstyle Installation/Configuration 15 19th June 2006 16:44
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
Changing mysql password gfts Installation/Configuration 1 16th March 2006 17:39
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 10:43.


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