Skip to main content

Connect MYSQL server using local system Remotely

1. Allow Remote Access in MySQL Configuration on ubuntu or your server



sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 127.0.0.1


bind-address = 0.0.0.0

sudo systemctl restart mysql


2. Grant Remote Access Privileges to Your IP

Log into MySQL on the server: and run 

sudo mysql -u root -p

sudo ufw allow 3306

sudo ufw status


 Double-check User Access
Log in to MySQL on your Ubuntu server:

mysql -u root -p

Run the following queries to ensure the user and permissions are correct:
Check Existing Users

SELECT user, host FROM mysql.user WHERE user = 'root';
 here 106.219.87.127 is your public ip ( or you Local network's public IP ) 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'106.219.87.127' IDENTIFIED BY 'Kil@123456' WITH GRANT OPTION;

FLUSH PRIVILEGES;

exit from mysql 

sudo systemctl restart mysql




now on your local system run command on the location of cmd where mysql folder is present 
here (82.112.230.00  is server IP )

mysql -u root -p -h 82.112.230.00   


it should ask for password ->  enter  it should connect now


Comments

Post a Comment

Popular posts from this blog

How to deploy NodeJS app on server with Apache2 and acess it with Server IP addresss - Node JS deploy project Live.

     hello friens , This is Vasu Birla , in previous post we have seen the deployement of NodeJS app on AWS instance server instance but AWS server is expensive than other servers . SO today we will use simple Ubuntu server for making Live out Project using Apache2 . At the end you will be abe to access your NodeJS app using server IP address from anywhere  .. 1.  Login to your server using SSH terminal . (in AWS part i already explained how to do this )     -> Open your putty in hostname put your server IP -      login with ssh username ->root and password     (if you dont have root username and pass ask your      provider or reset it from cpanel or hosting panel ) 2. after login - on terminal you can Put your project anywhere.     There are two ways to put your project folder on server location     (i) - > using Github - (very popular and easy to track your everyday code changes to your project folder)             you can push your entire project folder to git-hub and and
Post a Comment
Read more

Part 19- Router (Networking Devices)- Computer Networking- CCNA

Hello friends...i am Vasu Birla and today will discuss about the most important Networking Device ..Router.  so let's start... ROUTER Router is a device which connect two or more networks together, which is why router is also known is Inter-networking device also. Inter-networking means two or more networks are connected together with the help of router. one more thing router is just like a computer  but it is designed for routing only, our computer can be router also but that are software router while hardware router which are specialize for routing is more efficient and fast than software router.  There is a Operating System installed on router which get moves data from one network to another network with the help of routing table.  Router does work on Network layer or Layer 3 of the OSI model.  Cisco Router There many companies which manufacture Router but main companies are - Cisco , Juniper , HP, 3com and Nortel  Functions of Router
1 comment
Read more

Part 16- HUB (Networking Devices)- Computer Networking- CCNA

hello friends , Today we will discuss about the second Networking Devices Ethernet HUB. HUB Hub is a centralize device via all devices (computers, printers etc.) are connected with the star topology.  Hub connects other multiple devices together and helps to make connectivity mutually so that they can share and transfer data to each and every devices which is connected to that hub.  Hub does work at the first layer means at Physical layer of the OSI Model. Hub has many ports, and each port works like a repeater so Hub is also known as Multiport Repeater. A Hub Types of Hubs. there are three kind of Hubs. Active , passive and Manageable hubs. 1. Active Hubs - These hubs regenerates and amplify the signals to keep them strong. one more thing there is electricity needed in the active Hubs. 2. Passive Hubs- Passive Hubs simply forward the received signals. this type of hub does not make pure signal or regenerate so  these passive hubs doesn't n
Post a Comment
Read more