0

I'm trying to get mySQL 5.7 working on NetBSD (unix). When I try "mysql -u root" I get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

When I try "mysqld --initialize-insecure" I get

[ERROR] --initialize specified but the data directory has files in it.

What do I do?

Mark Argent
  • 11
  • 3
  • if you don't have valueable data you could remove the data directory contents and try that again. Otherwise the unix/unix like instructions [from the manual](https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html) will work. – danblack Mar 06 '20 at 02:55
  • Can you "su - mysql" and then try mysql? – abs Mar 06 '20 at 10:30
  • In the end I deleted mysql and started again. I've got somewhere by going su (to become root) and then su mysql, and then "mysqld --initialize". That claims to have set a password for root, but it then ignores it: mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) – Mark Argent Mar 06 '20 at 18:10
  • I'm still running aground on "mysql -u root -p" --- when I enter the password that mysqld --initialize generates, I still get: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). This happens as me, as root and as mysql users. – Mark Argent Mar 06 '20 at 23:07

0 Answers0