Jump to content
  • 0

Message: SQLSTATE[HY000] [2002] Permission denied


rmon

Question


  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  79
  • Reputation:   2
  • Joined:  04/27/16
  • Last Seen:  

Hi Everyone,

I just wanted to check, what are the ports needed to open in order for me to install fluxcp ? 
- my current ports that is open : 3306 inbound & outbound Both Debian 10 & CentOS7

i have two(2) AWS instance 
Debian10 - Server that holds rathena files 
CentOS7 - Holds Fluxcp Files 

I add the user inside Debian10
CREATE USER 'fluxcpUser'@'CentOS7_IP' IDENTIFIED BY 'MyPassword';
GRANT ALL PRIVILEGES ON MyDatabase_on_Debian10_main . * TO 'fluxcpUser'@'CentOS7_IP';
GRANT ALL PRIVILEGES ON MyDatabase_on_Debian10_logs . * TO 'fluxcpUser'@'CentOS7_IP';
FLUSH PRIVILEGES;

but im still having this issue 

Error: PDOException

Message: SQLSTATE[HY000] [2002] Permission denied

File: /var/www/html/fluxcp/lib/Flux/Connection.php:81

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  79
  • Reputation:   2
  • Joined:  04/27/16
  • Last Seen:  

@Brynner

Thanks ! 

i actually use % instead of the centos7 IP and it works 

CREATE USER 'myName'@'%' IDENTIFIED BY 'MyPAssword';
GRANT ALL PRIVILEGES ON MyDB . * TO 'myName'@'%';
GRANT ALL PRIVILEGES ON MyDb_logs . * TO 'myName'@'%';
FLUSH PRIVILEGES;

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  

make sure you allowed the ip address of your centos7 to your debian10

Link to comment
Share on other sites

×
×
  • Create New...