Re: 8.0 & MYSQL50 denying access to user root no password
Tim Judd wrote: On 11/29/09, Fbsd1 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? Read the post again. says access denied not connection refused. 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. mysql_install_db is documented in the mysql manual. After re-reading the section about using mysql_install_db many times I finally saw my problem. mysql_install_db has to be run direct from the root command line. I was doing "script capture.console.msg.rpt and them running another script which had the mysql_install_db command buried in it. The mysql manual says mysql_install_db will hose up the user account table locking out all access. I rm -rf /var/db/mysql to delete the hosed up mysql user db and then ran mysql_install_db from the root command line and the default root/nopassword worked again. Thanks for your pointer as to where to look. ___ 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"
Re: 8.0 & MYSQL50 denying access to user root no password
On 11/29/09, Fbsd1 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"
8.0 & MYSQL50 denying access to user root no password
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. 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"