Re: [CentOS] restarting mysql databases

2014-10-07 Thread Kai Schaetzl
What you want to do it seems is change the hostname for access of some users. Although, if it is local access, they should have access to localhost and it doesn't matter which hostname the machine has. Also, initially, you have to set the root password. Almost everyone uses PHPMyAdmin to adminis

Re: [CentOS] restarting mysql databases

2014-10-07 Thread Anthony K
On 2014-10-07 06:01, Robert Moskowitz wrote: 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 SOMETHI

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread John Plemons
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 co

Re: [CentOS] restarting mysql databases

2014-10-06 Thread John R Pierce
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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 install

Re: [CentOS] restarting mysql databases

2014-10-06 Thread John R Pierce
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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 na

Re: [CentOS] restarting mysql databases

2014-10-06 Thread John Plemons
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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Louis Lagendijk
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 Spe

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
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 na

Re: [CentOS] restarting mysql databases

2014-10-06 Thread 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 t

Re: [CentOS] restarting mysql databases

2014-10-06 Thread Robert Moskowitz
On 10/06/2014 03:06 PM, John R Pierce wrote: On 10/6/2014 12:01 PM, Robert Moskowitz wrote: 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

Re: [CentOS] restarting mysql databases

2014-10-06 Thread John R Pierce
On 10/6/2014 12:01 PM, Robert Moskowitz wrote: 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: changing hostname, ip addresses

[CentOS] restarting mysql databases

2014-10-06 Thread 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