CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2011
(77)
-
▼
January
(15)
- Sorting IP addresses
- Wikimedia : preventing new account creation
- wikimedia prevent access
- Exercises to stop snoring
- Mac switching between windows like windows alt-tab
- SVN Status Simple Cheat Sheet
- svn adding/deleting new/missing files from command...
- Permission denied on MAC
- svn on hostmonster
- Making terminal vim the default text editor on Mac
- Firefox : Mac : keyboard shortcut for going to add...
- Firefox : Mac : keyboard shortcut for going to add...
- Mac book pro : Page up/down
- Mac book pro : Page up/down
- Mysql Create new user
-
▼
January
(15)
No comments:
Post a Comment