Re: cannot connect from mysql client nor PHP, only sudo
From: Jivanmukta <jivanmukta_at_poczta.onet.pl>
Date: Mon, 20 Feb 2017 11:44:16 +0100
Message-ID: <o8eha0$98i$1_at_news.icm.edu.pl>
Date: Mon, 20 Feb 2017 11:44:16 +0100
Message-ID: <o8eha0$98i$1_at_news.icm.edu.pl>
On 14.02.2017 10:32, Axel Schwenke wrote:
> As for the "problem" of the thread-starter: there is no problem here. If you
> want to be able to do DBA work from your own system account, add a MySQL
> user with the SUPER privilege for that. Preferably use the auth_socket
> method for that user, too. Your PHP script should *not* connect as a MySQL
> user with SUPER privileges. Create another user for the script. Here it
> makes sense to set a password.
Thanks, I will do it and I will tell you if PHP connects. Received on Mon Feb 20 2017 - 11:44:16 CET