Change MySQL Password

Changing MySQL Password

To change the MySQL password for the user user_iptvpro, follow these steps:

Login to MySQL:
```
sudo mysql -u root
```

Change Password:

ALTER USER 'user_iptvpro'@'%' IDENTIFIED BY 'NEWPASS';
GRANT ALL PRIVILEGES ON xtream_iptvpro.* TO 'user_iptvpro'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Create a New User:

Creating a User with IP Restriction: You can create a user for each load balancer (LB) with IP restriction. For localhost, delete the current user and create a new one:

DROP USER 'user_iptvpro'@'%';
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;

Create a User for Each LB:

Create a user for each IP. The password can be the same or different. Replace 123.123.123.123 with the LB IP:

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;

Update Congfiguration Files:

After changing the password, update the configuration files with the new password.
```
wget https://bitbucket.org/emre1393/xtreamui_mirror/downloads/config.py && python config.py ENCRYPT
```
Password Generation with Norton:
- Use the Norton password generator, but avoid using symbols!
- https://my.norton.com/extspa/idsafe?path=pwd-gen
Security Measures:
- Block admin panel connections from outside using Nginx or a firewall, and allow only certain IPs.
- Search online for more information on how to do this.

Changing MySQL Password​

Changing MySQL Password