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.