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

2015-03-30 Thread Fernando Cassia
On Mon, Mar 30, 2015 at 3:16 AM, Fernando Cassia fcas...@gmail.com 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.

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

2015-03-30 Thread Fernando Cassia
On Mon, Mar 30, 2015 at 12:27 AM, Tim Dunphy bluethu...@gmail.com 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.

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 GRANThttps://dev.mysql.com/doc/refman/5.5/en/grant.html,

[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

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 bluethu...@gmail.com 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

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 sjt5a...@gmail.com wrote: mysql grant all privileges on ftp.* to 'proftpd'@'localhost' identified by 'testpattern'; Query OK, 0 rows affected (0.35 sec) mysql

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