Date: Mon, 30 Nov 2009 12:19:37 -0700 From: Tim Judd <tajudd@gmail.com> To: Fbsd1 <fbsd1@a1poweruser.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: 8.0 & MYSQL50 denying access to user root no password Message-ID: <ade45ae90911301119r35bd73a4m68d6adbb1ddd667e@mail.gmail.com> In-Reply-To: <4B134C50.5050104@a1poweruser.com> References: <4B134C50.5050104@a1poweruser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 11/29/09, Fbsd1 <fbsd1@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 'root@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-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?ade45ae90911301119r35bd73a4m68d6adbb1ddd667e>