INSERT INTO users (username, password) VALUES ('root', AES_ENCRYPT('somepassword', 'key12346123'));

SELECT AES_DECRYPT(password, 'key12346123') FROM users WHERE username = 'root';