Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 6th, 2012  |  syntax: None  |  size: 0.39 KB  |  hits: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to grant remote access to MySQL for a whole subnet?
  2. $ mysql -u root -p
  3. Enter password:    
  4. mysql> use mysql    
  5. mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';    
  6. mysql> FLUSH PRIVILEGES;
  7.        
  8. GRANT ALL ON *.* to root@'192.168.1.%' IDENTIFIED BY 'your-root-password';
  9.        
  10. mysql> GRANT ALL ON *.* to root@'192.168.1.%' IDENTIFIED BY 'your-root-password';
create a new version of this paste RAW Paste Data