UPDATE mysql.user SET Password=PASSWORD('odk_test') WHERE User='root'; FLUSH PRIVILEGES; CREATE DATABASE odk_test; CREATE USER 'odk_test'@'localhost' IDENTIFIED BY 'odk_test'; GRANT ALL PRIVILEGES ON odk_test.* TO 'odk_test'@'localhost' WITH GRANT OPTION;