Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-30 Thread Paul Jones
On 30/03/15 05:22, Tim Dunphy wrote: mysql> FLUSH PRIVILEGES; Yup! That was it. Thanks for the reminder! :) Tim >From the mySQL man pages: If you modify the grant tables indirectly using account-management statements such as GRANT, RE

Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Fernando Cassia
On Mon, Mar 30, 2015 at 3:16 AM, Fernando Cassia wrote: > You should keep in mind the security-related changes coming in MySQL 5..7, > if you ever choose to upgrade. Sorry, I erased this link by mistake while composing my reply. Here it goes. http://mysqlopt.blogspot.com/2015/02/mysql-575-m15-

Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Fernando Cassia
On Mon, Mar 30, 2015 at 12:27 AM, Tim Dunphy wrote: > I've been having some trouble creating a mysql user that can connect to > the database from localhost. It's always been a straight forward thing to > do in the past, so its time for a sanity check, if you guys don't mind. > Hi Tim, You shou

Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Hal Wigoda
[root@ops:~] #mysql --user=proftpd --password=testpattern -h localhost On Sun, Mar 29, 2015 at 10:27 PM, Tim Dunphy wrote: > Hey all, > > I've been having some trouble creating a mysql user that can connect to > the database from localhost. It's always been a straight forward thing to > do in

Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Tim Dunphy
> > mysql> FLUSH PRIVILEGES; Yup! That was it. Thanks for the reminder! :) Tim On Mon, Mar 30, 2015 at 12:15 AM, Steven Tardy wrote: > > > mysql> grant all privileges on ftp.* to 'proftpd'@'localhost' > identified by > > 'testpattern'; > > Query OK, 0 rows affected (0.35 sec) > > mysql> FLUSH

Re: [CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Steven Tardy
> mysql> grant all privileges on ftp.* to 'proftpd'@'localhost' identified by > 'testpattern'; > Query OK, 0 rows affected (0.35 sec) mysql> FLUSH PRIVILEGES; ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

[CentOS] mysql can't connect from localhost -strange behavior

2015-03-29 Thread Tim Dunphy
Hey all, I've been having some trouble creating a mysql user that can connect to the database from localhost. It's always been a straight forward thing to do in the past, so its time for a sanity check, if you guys don't mind. Ok, so here's the actual command with actual simplified password that