On 10/06/2014 03:27 PM, Reindl Harald wrote:
Am 06.10.2014 um 21:24 schrieb Robert Moskowitz:
On 10/06/2014 03:08 PM, Reindl Harald wrote:
Am 06.10.2014 um 21:01 schrieb Robert Moskowitz:
I am doing an install of a mysql system, and decided that I needed to change some things like host name. So I have to go back to square one with the mysql setup, but can't find any instructions for this. I TRIED:
mysql_install_db
And it did SOMETHING, but
mysqladmin -u root password 'mypass'
failed with:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I tried 'yum reinstall mysql' and that did not help
why should "yum reinstall" change anything?
Some apps reinit there data on reinstalls. Some don't. Don't know until you try.
no they don't
/var/lib/appname/ is never part of the package otherwise update swould touch/damage your data
What I thought. I guess just shooting in the dark.
the daemon specific data are below /var&/lib/mysql as for any other software they live below /var/ib/appname
no command ever will reset them besides rm -rf /var/lib/mysql/ but what has that all to do with change the hostname?
Don't know what changing the hostname did or does not do. I am digging into various info to figure out what to delete or rebuild to get back to pristine mysql. I can understand why this should not be easy - for someone to remove all of your mysql data, but it should be possible...
if you have no data:
- stop the service
- rm -rf /var/lib/mysqld/*
ls /var/lib/mysqld/* ls: cannot access /var/lib/mysqld/*: No such file or directory
did you mean /var/lib/mysql/* ?
But that seems risky as there is /var/lib/mysql/mysql that has lots of interesting looking files. But there is an empty directy /var/lib/mysql/foo and /var/lib/mysql/mydb with the file db.opt
- start the service
- you have a virgin setup
and as always read some docs http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html
I MIGHT have gotten to this in a couple of days or reading. Thanks for the pointer.
On Mon, 2014-10-06 at 15:43 -0400, Robert Moskowitz wrote:
failed with:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using
password:
NO)'
Please read the above carefully: using password: NO Specifying the password requires the -p or --password option. Just specify -p on the command line and let mysqladmin ask for the password...
On 10/06/2014 03:51 PM, Louis Lagendijk wrote:
On Mon, 2014-10-06 at 15:43 -0400, Robert Moskowitz wrote:
failed with:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using
password:
NO)'
Please read the above carefully: using password: NO Specifying the password requires the -p or --password option. Just specify -p on the command line and let mysqladmin ask for the password...
When I try 'mysqladmin -u root -p' I get the help dump.
Going to try the secure install, or delete those three files I found.
Did you do the /usr/bin/mysql_secure_install
Sounds like that is the issue, run mysql_secure_install
It will setup MySQL securely with a simple set of questions and answers.. Yes is the right answer for most of the questions.
Here is a link to LAMP Stack for Centos, the MySQL section is just below the Apache install section..
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache...
Also good for CentOS 7
john
On 10/06/2014 03:54 PM, John Plemons wrote:
Did you do the /usr/bin/mysql_secure_install
Not part of my installation. I am running RedSleeve 6, which is the ARM buid of Centos6 and a minimum installation. So sometimes I find I have to go back and add something else...
Sounds like that is the issue, run mysql_secure_install
It will setup MySQL securely with a simple set of questions and answers.. Yes is the right answer for most of the questions.
Here is a link to LAMP Stack for Centos, the MySQL section is just below the Apache install section..
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache...
Also good for CentOS 7
And eventually there will be Centos-arm 7 that I can use.
john
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 10/6/2014 1:07 PM, Robert Moskowitz wrote:
On 10/06/2014 03:54 PM, John Plemons wrote:
Did you do the /usr/bin/mysql_secure_install
Not part of my installation. I am running RedSleeve 6, which is the ARM buid of Centos6 and a minimum installation. So sometimes I find I have to go back and add something else...
its mysql_secure_installation and its part of the base package...
# rpm -qf `which mysql_secure_installation` mysql-server-5.1.73-3.el6_5.x86_64
On 10/06/2014 04:12 PM, John R Pierce wrote:
On 10/6/2014 1:07 PM, Robert Moskowitz wrote:
On 10/06/2014 03:54 PM, John Plemons wrote:
Did you do the /usr/bin/mysql_secure_install
Not part of my installation. I am running RedSleeve 6, which is the ARM buid of Centos6 and a minimum installation. So sometimes I find I have to go back and add something else...
its mysql_secure_installation and its part of the base package...
# rpm -qf `which mysql_secure_installation` mysql-server-5.1.73-3.el6_5.x86_64
Oct 02 15:32:20 Installed: mysql-server-5.1.71-1.el6.armv5tel
I guess I either mistyped it or copied it wrong. I got the prompt this time. So off to the races.
Using a 'Howto' gets things working to some extent faster, but there are things often not 'right' and when they go bump, well you see where I am right now.
On 10/6/2014 1:21 PM, Robert Moskowitz wrote:
On 10/06/2014 04:12 PM, John R Pierce wrote:
On 10/6/2014 1:07 PM, Robert Moskowitz wrote:
On 10/06/2014 03:54 PM, John Plemons wrote:
Did you do the /usr/bin/mysql_secure_install
Not part of my installation. I am running RedSleeve 6, which is the ARM buid of Centos6 and a minimum installation. So sometimes I find I have to go back and add something else...
its mysql_secure_installation and its part of the base package...
# rpm -qf `which mysql_secure_installation` mysql-server-5.1.73-3.el6_5.x86_64Oct 02 15:32:20 Installed: mysql-server-5.1.71-1.el6.armv5tel
I guess I either mistyped it or copied it wrong. I got the prompt this time. So off to the races.
yeah, note its mysql_secure_installation, not _install as the other John P suggested. I typed mysql_secu<tab> :)
See, that's what happens when you get a phone call in the middle of trying to help someone. At least we got the ball going in the right direction.
You might load webmin onto the machine, it is a web interface and can make much of the MySQL control easier. It has a host of modules that may come in handy as you configure your machine.
http://www.webmin.com your Centos load should support it. Are you adding Apache, PHP etc..? If so the link I gave you will help with the installations.
john
On 10/06/2014 04:35 PM, John Plemons wrote:
See, that's what happens when you get a phone call in the middle of trying to help someone. At least we got the ball going in the right direction.
You might load webmin onto the machine, it is a web interface and can make much of the MySQL control easier. It has a host of modules that may come in handy as you configure your machine.
I am trying to move away from webmin dependency.
Redsleeve was built for armv5 which did not have selinux support, or some such according to the developers. I am running on armv7 which my Fedora 19 - 21 has selinux support, but with RSEL6 I am running a bit rough (thus I really want Centos-arm-7). So I am trying to go back to stuff I did long ago (like running named in chroot) and avoid obvious attack routes like webmin.
arms are fun. Like 2 watts compared to intelboxen at 70w...
http://www.webmin.com your Centos load should support it. Are you adding Apache, PHP etc..? If so the link I gave you will help with the installations.
john
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
John Plemons -
John R Pierce -
Louis Lagendijk -
Robert Moskowitz