Help L2j Webmanager

[Seamless]

Hi Guys, I am currently setting up account manager for my server. My project is running l2jsunrise source. ACM im trying to install is l2jweb manager which is free. 

 

I am into my dedicated and try to setting up mysql to listen to remote users. I am currenytly with root@localhost user. I am trying to give priviliges to this user. I dont use navicat but i use workbench. 

 

So with cmd i entered 

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';

For Some reason cant accept specific ip ( my webhosting ip) so in this case % to listen to all ips

 

After that i tried to start install.php but it saying that the databse is not connected. Port 3306 is open both inbound outbound.

 

Furthermore, tried to manage users with navicat. I added new user (acm) and gave him priviliges to change account trable and account_data table. 

 

Flush priviliges. Reastatted sql and still the php install cant find connection

 

 

I am stuck for 8-9 hours now trying to find a solution. Is anyone who can help  me ?

 

 

This is the guide which i found the files for web management

 

 

[iTopZ]

CREATE USER 'user'@'%' IDENTIFIED BY 'passwd';
ALTER USER 'user'@'%' IDENTIFIED WITH mysql_native_password BY 'passwd';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;

the account manager you used is not only outdated but dangerous.

Edited October 6, 2020 by iTopZ

[Seamless]

I smth else out there private or open to use ?