Unable to run FULL OUTER JOIN
Full outer join is not supported. If you look at:

https://dev.mysql.com/doc/refman/5.7/en/join.html

there is only LEFT and RIGHT outer join. You can however mimic FULL OUTER with a UNION between LEFT and RIGHT:

SELECT user_record.id AS user_id, 
       user_record.password, user_addresses.street 
FROM `user_record` 
LEFT JOIN `user_addresses` 
    ON user_record.id = user_addresses.user_id 

UNION

SELECT user_addresses.user_id, 
       user_record.password, user_addresses.street 
FROM `user_record` 
RIGHT JOIN `user_addresses` 
    ON user_record.id = user_addresses.user_id 

ORDER BY user_id ;


You have to include user_record.id / user_addresses.user_id in your select clause to be able to order by it.