-1
1
How NSIS MySql Silent install and configure to enable remote machine access.
**ExecWait "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=root ServerType=DEVELOPMENT DatabaseType=MIX Port=3306 RootCurrentPassword=root" SkipNetworking=no AddBinToPath=yes**
It works fine for localhost, but problem with Remote IP access
Prabhat Singh
Posted 2015-01-01T10:41:28.927
Reputation: 33
0
since you are trying to connect the mysql from another machine,
First you need add the remote ip in the local mysql database where you are trying to connect from remote machine .Please execute the condition in the local machine
1) 'GRANT ALL PRIVILEGES ON . TO '[user name]'@'[remote machine name]' IDENTIFIED BY '[password]' WITH GRANT OPTION;'
Example:
GRANT ALL PRIVILEGES ON . TO 'root'@'remote' IDENTIFIED BY 'password' WITH GRANT OPTION;
Where root is the username and remote is servername and password is password.
2) FLUSH PRIVILEGES;
Once done,please try to reconnect the MySQL and you would be able to connect it.
vembutech
Posted 2015-01-01T10:41:28.927
Reputation: 5 693
I want this operation done by command line for all machine access as remote. – Prabhat Singh – 2015-01-02T11:19:56.793
Thanx @vembutech for answer. my work is done with this solution. – Prabhat Singh – 2015-01-03T07:36:46.127
What error do you get when it fails? – MaQleod – 2015-01-01T20:01:53.980
work fine for local machine,but when i am going to access from remote machine it shows the "'PC Name' is not allowed to connect to this mysql server" – Prabhat Singh – 2015-01-02T09:35:03.670
See this post: http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server
– MaQleod – 2015-01-02T10:04:50.457Is there any way to access remote machine database without FLUSH PRIVILAGE, I mean solve by the instance configure command line. – Prabhat Singh – 2015-01-02T10:17:16.373
Thanx @MaQleod for working solution. – Prabhat Singh – 2015-01-03T07:41:10.507