Scott Ashton, 44, died in hospital last Wednesday following an incident in the city's Shiprow on 18 May.
Frances Thomson, 24, made no plea or declaration and was remanded in custody at Aberdeen Sheriff Court.
Mr Thomson is expected to appear in court again next week.
A man has appeared in court charged with murder following the death of a man in Aberdeen.