Command in FreeBSD to allow client host to use root in MySQL 5 server?
Posted on 2007-04-06
Im new to using MySQL in freeBSD, im fairly experienced getting MySQL to work in a windows environment, but I am trying to learn FreeBSD. I got as far as installing and running MySQL 5 server on FreeBSD 6.2 successfully. The problem is i dont know how to work my way through managing MySQL in FreeBSD. Normaly I use a client machine with windows and use MySQL GUI tools like MySQL Administrator. But i can becuase i get denied becuase my client machine (192.168.2.6) isnt allowed to.
So with that said, how do i add host 192.168.2.6 to get full access using root, using FreeBSD's localhost?
Thanks to all who help.