On 11/29/09, Fbsd1 <fb...@a1poweruser.com> wrote: > For many releases of Freebsd going back to 4.3 I have all ways used the > default mysql user root localhost with no password which has been the > default. > With 8.0/mysql-server-5.0.86 I am denied access now. > The mysql manual still says the normal install defaults to allowing > access to user root with no password are in effect. > > After a fresh clean install of mysql > Tried mysqladmin -u root drop test to delete the test db. > Received this msg > connect to srver at localhost failed > access denied for user 'r...@localost (using password: no) > This in not suppose to happen.
Two issues, mysqladmin tries to connect to the mysql server -- i see in your message above it can't connect if it can't connect, how can it authorize? second, the undocumented mysql_install_db must be run to install the default database. But if you run this as root, you should change ownership of everything in /var/db/mysql to allow the mysql server access to the files. Those are two problems I'm seeing with your post. Correct me if I'm wrong, but try these first. > > Is anyone else having this problem? > Has the package for mysql50-server been changed to force securing user > root with a password? > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org" > _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
