xampp mysql remote access


To allow remote connections to mysql server on windows follow the steps below:

1) Login to mysql server through command line and execute the following query:

 GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password';

2) open the my.ini located inside the folder "C:\xampp\mysql\bin"
    uncomment the line and replace 127.0.0.1 to
   
      bind-address 0.0.0.0

Comments

  1. YOU can use with mysql on win – free tool Valentina Studio, does everything you need, and does it very well http://www.valentina-db.com/en/valentina-studio-overview

    ReplyDelete


  2. Thanks for sharing, if you want more benefits then remain connect with us.

    Valentina Studio Pro Crack

    ReplyDelete

Post a Comment

Popular posts from this blog

Scan FC LUN's in RHEL/CentOS

CEPH bluestore using ceph-ansible

Start wildfly service with standalone-full.xml