I installed mysql/phpmyadmin/apache on a linux box for internal network use only. I don't have the strongest understanding of MySQL.
Hostname: server.domain.lan IP: 192.168.0.54
- After I installed MySQL I ran
mysqladmin -u root password STRONGPASSWORD
- I edited /etc/my.conf and set the bind-address to 192.168.0.54
I am trying to set up a system to run on my LAN that I can upload websites to that need to create databases.
Screenshot from phpMyAdmin of the Privileges menu:
So my questions are:
- Why are there 3 root accounts?
- What do I need to do to configure MySQL to allow remote connections from the root account so I can create databases, etc?
(Sorry I'm kind of new to MySQL so I'm not certain that I'm even asking the correct questions...)