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"
