Sorting order behaviour between Postgres and Mysql

I have faced some strange sort order behaviour between Postgres & mysql.

For example, i have created simple table with varchar column and inserted two records as below in both Postgres and Mysql.

create table mytable(name varchar(100));
insert into mytable values ('aaaa'), ('aa_a');

Now, i have executed simple select query with order by column.

Postgres sort order:

test=# select * from mytable order by (name) asc;
 name 
------
 aa_a
 aaaa
(2 rows)

Mysql sort order:

mysql> select * from mytable order by name asc;
+------+
| name |
+------+
| aaaa |
| aa_a |
+------+
2 rows in set (0.00 sec)

Postgres and mysql both returning same records with different order.

My question is which one correct?

How to get results in same order in both database?

Edited:

I tried with query with ORDER BY COLLATE, it solved my problem.

Tried like this

mysql> select * from t order by name COLLATE utf8_bin;
+------+
| name |
+------+
| aa_a |
| aaaa |
+------+
3 rows in set (0.00 sec)

Thanks.