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
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.
We'll try to make future tutorials even more error-proof. :)
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
there should be
after this everything worked fine on further mysql setup ;)
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;
|All times are GMT +2. The time now is 05:08.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.