Change PASSWORD FOR : user_iptvpro in MYSQL (recommended for panels with many balancers)

[AleksandarMKD]

Hello for All

Sometimes we need to reinstall the main server and we want to connect the balancers we already have after that installation, well here
is the solution:
work on Ubuntu 18.04
in Terminal PuTTY root user:

wget https://raw.githubusercontent.com/shinctl/XtreamUI/master/pytools/config.py && python config.py ENCRYPT

Server ID: 1
Host: 127.0.0.1
Port: 7999
Username: user_iptvpro
Password: PASSWORD
Database: xtream_iptvpro

forward

Server ID: 1
Host: 7999
Username: user_iptvpro
Password: password from the previous installation
Database: xtream_iptvpro

then

mysql -u root

ALTER USER 'user_iptvpro'@'%' IDENTIFIED BY 'password from the previous installation';

GRANT ALL on xtream_iptvpro.* to 'user_iptvpro'@'%' identified by 'password from the previous installation';

FLUSH PRIVILEGES;

exit

service mysql restart

/home/xtreamcodes/iptv_xtream_codes/start_services.sh

 

[@TealcAvalon]

There is no need to restart mysql service, since you did flush privileges it's already "on" by default, nevertheless I would recommend to change default mysql XC port, change also default XC database and give each LB a different login/password, and just DON'T use the default username "user_iptvpro". But hey that's just me, I don't like to use default settings has that will make the service vulnerable to several know attacks points

 

[urgodfather]

Even though you did write very nicely, this info is already posted multiple times!

 

[fuzileiro]

There is no need to restart mysql service, since you did flush privileges it's already "on" by default, nevertheless I would recommend to change default mysql XC port, change also default XC database and give each LB a different login/password, and just DON'T use the default username "user_iptvpro". But hey that's just me, I don't like to use default settings has that will make the service vulnerable to several know attacks points

Hi guys, my question. I want to change the user_iptvpro password, i have make it with this command i use;

mysql -u root -p

use mysql;

ALTER USER 'user_iptvpro'@'%' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

exit


after change this, my database and panel doesn't anymore work!

What is wrong?

if i use the same command lines with the previous Fresh install password, panel works again!

Why i can't change the iptvpro password?

if someone can me help im will be happy.

thanks

 

[AleksandarMKD]

Hi guys, my question. I want to change the user_iptvpro password, i have make it with this command i use;

mysql -u root -p

use mysql;

ALTER USER 'user_iptvpro'@'%' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

exit


after change this, my database and panel doesn't anymore work!

What is wrong?

if i use the same command lines with the previous Fresh install password, panel works again!

Why i can't change the iptvpro password?

if someone can me help im will be happy.

thanks

why use mysql; ?
pls see my instruction
do the same as I have written and it will surely be fine

 

[fuzileiro]

why use mysql; ?
pls see my instruction
do the same as I have written and it will surely be fine

Hi mate, thank you for reply my question.

have you read my question? i want change user_iptvpro password. i do that, but then my panel doesn't anymore work!

if i put the previous installation password, then works well!

what i do wrong?