char a, b, c, d;
unsigned int pack;
pack = (((((a << 8) | b) << 8 ) | c) << 8) | d;
mysql> use mysql;
Database changed
mysql> SELECT User,Host FROM User;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| admin | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)