by
455 17
0
6
2,693
4
Top 1% !
Popular
Famous
Tagged
Specified
OpenSource
Popularity: 5774th place

Published on:

Languagemysql

Mysql user privileges

mysql grant user privileges
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/1096221/Mysql-user-privileges?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
CREATE USER 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON `DATABASE`.* TO 'USERNAME'@'IP'; FLUSH PRIVILEGES; # USERNAME: Username # IP: The Address for remote access OR localhost for local access. Can be used the % symbol as wildcard # PASSWORD: Password without encription # DATABASE: The database that we need the user
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus