The latest articles on DEV Community by makitosan (@makitosan). https://dev.to/makitosan https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F64302%2F41901408-0226-40dc-8f2b-e2218ac9b0dc.png https://dev.to/makitosan en makitosan Mon, 26 Mar 2018 12:21:57 +0000 https://dev.to/makitosan/vagrant-mysql-port-forwarding-configuration-3io8 https://dev.to/makitosan/vagrant-mysql-port-forwarding-configuration-3io8 <ul> <li>Ubuntu 16.04</li> <li>MySQL 5.7</li> <li>Vagrant 2.0.2</li> </ul> <h2> VAGRANT </h2> <h3> EDIT Vagrantfile </h3> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>Vagrant.configure("2") do |config| config.vm.network "forwarded_port", guest: 3306, host: 3306 end </code></pre> </div> <h2> MySQL (guest) </h2> <h3> EDIT /etc/mysql/mysql.conf.d/mysqld.cnf </h3> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>bind-address = 0.0.0.0 </code></pre> </div> <h3> GRANT PRIVILEGES </h3> <p>On the guest machine, login to local mysql server and execute the following sqls.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight sql"><code><span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="o">*</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'root'</span><span class="o">@</span><span class="s1">'10.0.2.2'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'your_password'</span> <span class="k">WITH</span> <span class="k">GRANT</span> <span class="k">OPTION</span><span class="p">;</span> <span class="n">FLUSH</span> <span class="k">PRIVILEGES</span><span class="p">;</span> </code></pre> </div> <h2> TEST </h2> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>mysql -uroot -p </code></pre> </div> vagrant mysql