0

I am sorry if this sounds funny as I am a complete noob when it comes to database configuration. I have been trying to access my Pi's MySQL database from my laptop/or another PI. I have successfully linked PHP and Libreoffice Base (via ODBC) to the database using localhost. By using my mySQL Pi, tables can be created and by typing 127.0.1.1/phpmyadmin, I can access my tables using a web browser with ease. Right now, I connected a LAN cable to my laptop/my 2nd pi and my mySQL pi and I am wondering if I can access it locally this way?(Using microsoft access/web browser) but when I entered 127.0.1.1/phpmyadmin on my laptop/ other pi's browser it doesn't load.

Is it because my laptop or pi's Lan ip is not approved on my main mySQL pi? I have also tried to edit /etc/mysql/my.cnf and commented out #bind-address on my pi. Thank you so much for reading this long query. Any help would be greatly appreciated.

3
  • 127.0.0.1 is a local address (local to the machine) so if you are using this on your laptop it will look for the DB on your laptop not the Pi. You will need to use the IP of the Pi hosting the DB. Commented Jan 20, 2017 at 2:31
  • @SteveRobillard Thank you for the reply. Which IP should I use? the local eth0 gateway by using ifconfig?
    – HamHam
    Commented Jan 20, 2017 at 3:20
  • 2
    You need the IP of the PI. Commented Jan 20, 2017 at 3:27

1 Answer 1

1

Find the ip address of your mysql pi by entering ifconfig at the command line on the pi console. Then use that address from your laptop/browser. As the other responder mentioned the 127.0.0.1 address is the local address of the computer you are working on.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.