Re: 8.0 MYSQL50 denying access to user root no password
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
Re: 8.0 MYSQL50 denying access to user root no password
Tim Judd wrote: 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? 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
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