Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1.  
  2. 1.SCHIMBARE Parola USER MYSQL:
  3.  
  4. Te conectezi la putty si executi urmatoarele comenzi:
  5.  
  6. /usr/local/etc/rc.d/mysql-server stop
  7.  
  8. mysqld_safe --skip-grant-tables &
  9.  
  10. mysql -u root
  11.  
  12. use mysql
  13.  
  14. update user set password=PASSWORD('parolata') where user='numeuser';
  15.  
  16. flush privileges;
  17.  
  18. quit
  19.  
  20. service mysql-server restart
  21.  
  22.  
  23. 2.Eliminare ip user mysql:
  24.  
  25. /usr/local/etc/rc.d/mysql-server stop
  26.  
  27. mysqld_safe --skip-grant-tables &
  28.  
  29. mysql -u root
  30.  
  31. use mysql
  32.  
  33. update user set host = '%' where user='numeuser';
  34.  
  35. flush privileges;
  36.  
  37. quit
  38.  
  39. service mysql-server restart
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement