e.preventDefault(); // Prevent form submission input.blur(); // remove focus input.value = ""; // optional: clear the input

Access MySQL DB Remotely

You have a machine where your MySQL is running and you want 2 developers to access a Database remotely.

You can follow the steps below to set up the access permissions for those 2 developer machines.

Steps for access remote DB

  • First Server/Remote machine should give permission to the client.
  • Then developer machines would be able to access remote db using DB’s server ip and port number where the MySQL is running

Steps to give permissions to the developer machine using a command prompt

Go to mysql on DB machine> In case mysql is not in the path, you would have to go to mysql/bin directory

mysql>use mysql
mysql>GRANT ALL ON *.* to root@193.164.1.11 IDENTIFIED BY ‘abc’; // Here the root is the MySQL username of the DB, abc is the password for this root account and 193.164.1.11 is the developer machine IP address

Steps to give permission to developer machine using PHPMyAdmin

1.Go to phpmyadmin
Ex: http://localhost/phpmyadmin/
2.Select privileges
3.Click on Add a new User link
4. Then proceed

Related Posts

Latest Posts

  • All Posts
  • Generative AI
  • manufacturing
  • News
  • Portfolio
    •   Back
    • Android
    • iOS
    • Java
    • PHP
    • MEAN
    • Ruby
    • DotNet
    • IoT
    • Cloud
    • Testing
    • Roku
    • CMS
    • Python

India

Plot No. 11/2, Phase 3, Hinjewadi Rajiv Gandhi Infotech Park, Pune, India – 411057.
info@tudip.com
+91-96-8990-0537

United States

1999 S. Bascom Ave Suite 700, Campbell CA. 95008, USA.
info@tudip.com
+1-408-216-8162

Canada

64 Caracas Road North York, Toronto Ontario M2K 1B1, Canada.
info@tudip.com

Mexico

Calle Amado Nervo #785 Interior B Colonia Ladron De Guevara 44600 Guadalajara, Jalisco, Mexico.
info@tudip.com

Colombia

Cra. 9 # 113-53 Of. 1405 Bogotá D.C., Colombia.
info@tudip.com

UAE

Tudip Information Technologies L.L.C Office No 109, ABU HAIL BUILDING 13, Abu Hail, Dubai, UAE.
info@tudip.com

Nigeria

22 Kumasi Crescent, Wuse 2, Abuja, Nigeria.
info@tudip.com