Tutorial Howto allow MySql remote connection | SSH commands

[redhat]

These following commands are used to create a new database user and allow your remote MySQL connection

Login to your Main Server ( Xtream Codes Dedicated Server) via Linux / MAC Terminal
ssh root@yourserverip

OR if you are on Window then install Putty software and login to your Main server

- After SSH Root Login

mysql -u root -p

Enter your MySQL root password then run the following commands
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; GRANT ALL ON *.* to newuser@'XXX.XX.XX.X' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;

Note: you can use any username and password 

XXX.XX.XX.X = it's your WHMCS/ Billing Panel IP Address ( VPS Server IP Address)

If you have already created a database user then follow only these command below:
GRANT ALL ON *.* to newuser@'XXX.XX.XX.X' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;

XXX.XX.XX.X = it's your WHMCS/ Billing Panel IP Address ( VPS Server IP Address)

 

[TomTay]

thanks red, i don't suppose someone knows how to disable recapcha via ssh command ? i seen to be getting an error about domain which is preventing login

 

[onlyone311]

thanks red, i don't suppose someone knows how to disable recapcha via ssh command ? i seen to be getting an error about domain which is preventing login

you can disabled with mabria db settings table