GRANT ALL PRIVILEGES ON *.* TO user_name@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO user_name@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;