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?

 

[AleksandarMKD]

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?

This is for the main server only
when you want to reinstall main server it and have all your balancers connect immediately to the newly installed main server
You need to do the above procedure