Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- apt update
- apt install mariadb-server
- mysql_secure_installation
- mariadb
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234566';
- GRANT ALL PRIVILEGES ON *.* TO 'dbrootpw'@'%' IDENTIFIED BY '1234566';
- FLUSH PRIVILEGES;
- find / -name *.cnf -print
- /etc/mysql/mariadb.conf.d/50-server.cnf
- 50-server.cnf
- # localhost which is more compatible and is not less secure.
- bind-address = 0.0.0.0
- systemctl restart mariadb
- systemctl restart mysql
- ss -antpl | grep 3306
- ss -tulpn | grep -E 'mysql|mariadb'
- mysql -h 10.20.7.116 -uroot -p1234566
- systemctl stop mysql
- mysqld_safe --skip-grant-tables &
- mysql -u root
- mysql
- use mysql;
- update user set password=password("1234566") where user = 'root';
- flush privileges;
- exit;
Advertisement
Add Comment
Please, Sign In to add comment