Create New User IN MySql

sql Share on :

CREATE USER 'genita'@'%' IDENTIFIED BY 'genita';
GRANT ALL PRIVILEGES ON *.* TO 'genita'@'%' WITH GRANT OPTION;
flush privileges;

With this code sniped we allow the user with password to have access from all IP addresses.

Contribute to this Snippet

Was this helpful?

Write your Comment

Similar code snippets

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer