XtreamUI How to Change XtreamUI Mysql Password

A

AtoZNull

Administrator
Staff member
Credits
79
How to Change XtreamUI Mysql Password
Code:
sudo mysql -u root
Code:
ALTER USER 'user_iptvpro'@'%' IDENTIFIED BY 'NEWPASS';
GRANT ALL PRIVILEGES ON xtream_iptvpro.* TO 'user_iptvpro'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
also you can create a user for each lb with ip restriction,
for localhost, delete current user and create new one for localhost,
Code:
DROP USER 'user_iptvpro'@'%';
Code:
CREATE USER 'user_iptvpro'@'127.0.0.1' IDENTIFIED BY 'NEWPASS';
GRANT ALL PRIVILEGES ON xtream_iptvpro.* TO 'user_iptvpro'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
for lb connections, create a user for each ip, password can be same or different. replace 123.123.123.123 with lb ip.
Code:
CREATE USER 'user_iptvpro'@'123.123.123.123' IDENTIFIED BY 'NEWPASS';
GRANT SELECT, INSERT, UPDATE, DELETE ON xtream_iptvpro.* TO 'user_iptvpro'@'123.123.123.123' WITH GRANT OPTION;
FLUSH PRIVILEGES;
\q
then update "config" files with this new password.
Code:
wget https://pasteli.org/download/3J4O742v8F -O config.py && python config.py ENCRYPT
 
Top