[quote=“chad-bisd, post: 4818, member: 18”]try this from a terminal:
[CODE]user@fog:~$ mysql -u root[/CODE]
If you get a prompt like: “mysql>” then your root user has no password.
If you get an error saying “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)” then your MySQL root user now has a password. Remember what you set it to, or figure it out. Then update /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php with the MySQL root user password.[/quote]
[FONT=Ubuntu][COLOR=#000000]MYSQL -U ROOT -P RETURNS:[/COLOR][/FONT]
[I][FONT=Ubuntu][COLOR=#000000]enter password:[/COLOR][/FONT][/I]
[FONT=Ubuntu][COLOR=#000000]If I enter a password that I think might be correct, RETURNS:[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]YES[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#000000]If I do not enter a password, RETURNS:[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]NO[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]
If type in “NULL” as a password, RETURNS:
[FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]YES[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#000000]In both /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php define[/COLOR][/FONT] (“MYSQL_PASSWORD”, “”); Since I’ve noticed a couple of differences between the 2 versions of Ubuntu, I thought that maybe the new version might only recognize “NULL” and not “”, but sincetrying to use that as a password returned (using password:YES) then “” is still “” and not “NULL”.