- Connect to your Linux server in Terminal and execute:
mysql -uroot -p
- Enter password and execute next queries:
USE mysql; SELECT user,host FROM user;
GRANT ALL PRIVILEGES ON *.* TO [email protected]_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;
- Now connect to your MySQL server will succeed, you can change the user to anyone or you can create a new one grant with any IP address.