Criando usuário MySQL

CREATE USER 'nick'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON minhaDb.* TO 'nick'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Para ver os usuários

SELECT Host,User,Password FROM mysql.user;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s