MySQL 5.0.45 - root access on any external, no pass ?
Posted on 2007-11-18
I have read every thread i could find and tried every command i can, i am sure i am doing something wrong or lack of sleep has fried my brain.
brand new 5.0.45 MySQl install, i need to allow access on root from all hosts with no password
i cant get it to work, i can only connect from local host on root...
i tried adding *.* as a host using mysql admin but it seems to do nothing and doesnt allow me to connect from another system
i have tried grant commands, giving grant to root,flush privileges afterwards, but nothing is working for me, this is a test bed system, not accessible from the Inet, i am redoing someone else's work who has no security so for now i need just root access with no password from *.* anywhere.....
Please save what little sannity i have left, i know the question has been asked, but i have tried literally ever response people have given to everyone else :(