hello again,
Hopefully someone can shed some light on a few questions I have.
First of all, when logged in to my server as root via shell, I can access MySQL without a password. I have definitely created a root password for the MySQL server. So, is this a feature?
Also, when accessing my databases remotely, I can't use my IP or the connecting host, I have to use % - which kinda sucks. My IP is fixed, so I don't know why the IP doesn't work.
Finally, I can't connect as root to the MySQL server remotely. I know this is for security purposes, but if I can't grant root access by IP, what can I do to connect remotely - besides adding a wildcard % ?
Any thoughts on this? Cheers - Marc
Hopefully someone can shed some light on a few questions I have.
First of all, when logged in to my server as root via shell, I can access MySQL without a password. I have definitely created a root password for the MySQL server. So, is this a feature?
Also, when accessing my databases remotely, I can't use my IP or the connecting host, I have to use % - which kinda sucks. My IP is fixed, so I don't know why the IP doesn't work.
Finally, I can't connect as root to the MySQL server remotely. I know this is for security purposes, but if I can't grant root access by IP, what can I do to connect remotely - besides adding a wildcard % ?
Any thoughts on this? Cheers - Marc