Category Archives: Databases

This category contains articles related to Oracle DB, SQL Server and MySQL Server

Allow users to connect remotly to MySQL

Sometimes, you want to allow users to connect remotly to your MySQL server, all you have to do is to run the following command grant all privileges on *.* to ‘root’@’81.91.101.111’ identified by ‘password’ with GRANT OPTION; This will grant all privileges to user root and will allow him to connect from 81.91.101.111 Cheers,