@clarkej thanks for your reply actually i am new here, i don’t have enough knowledge of ERPNext as how much you have, i am just following @noetico 's these steps, i am stuck in step no 4. i am unable to understand it properly.
extremely sorry for the late reply. try the following steps
1 - log into mysql, you can use bench mysql
2 - set privileges as follows: grant all privileges on databaseName TO ‘user’ @’%’ identified by ‘password’ with grant option; hit enter
3 - enter flush privileges; hit enter
4 - edit my.cnf to allow external connections as follows, navigate to etc/mysql and open the my.cnf file, look for bind-address 127.0
0.1 add a # in front of it, before it like so, #bind-address…
5 - add another line, #skip-networking
6 - save file, restart server
please dont make a mistake in the conf file.
all the best