Linux
MySQL Allow Remote Connections To allow remote connection from remote to MySQL database lets create new user “[email protected]” with password -PaSSworD from command prompt: mysql> CREATE USER 'remote'@'10.110.2.25' IDENTIFIED BY 'PaSSworD'; Grant all privilegies to
Linux
MySQL Connect Remote Database For remotely access to mysql database use command: mysql -u User -p -h RemoteMySQLdatabaseIP Were: User – remote MySQL server user, RemoteMySQLdatabaseIP – remote MySQL database IP example: # mysql -u User_Name -p -h 11.22.33.44 Enter password: Welcome to the MySQL monitor. Commands end with