SQL code

sql-code.md

• New user CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test123test!';

• Remove user DROP USER 'phpmyadmin'@'localhost';

• Grant rights GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

• Revoke rights REVOKE ALL PRIVILEGES ON phpmyadmin.* FROM 'phpmyadmin'@'localhost';

• Import from backup SOURCE backup_file.sql;

• Change password of root user
  

1. sudo /etc/init.d/mysql stop
   
2. sudo mysqld_safe --skip-grant-tables --skip-networking &
   
3. mysql -u root mysql
   
4. use mysql;
   
5. update user set password=PASSWORD("NEWPASSWORD") where User='root';

• Password ENCRYPT('firstpassword', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16)))