Date: Fri, 29 Mar 2024 11:54:42 +0200 (EET) Message-ID: <1533226899.6697.1711706082344@abills> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_6696_1412291402.1711706082342" ------=_Part_6696_1412291402.1711706082342 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
/etc/rc.conf
mysql_a= rgs=3D"--skip-grant-tables"=20
=D0=9F=D0=B5=D1=80=D0=B5=D0= =B7=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC mysql
/usr/lo= cal/etc/rc.d/mysql-server restart=20
=D0=92=D1=85=D0=BE=D0=B4=D0=B8=D0= =BC =D1=81 =D0=BF=D1=80=D0=B0=D0=B2=D0=B0=D0=BC=D0=B8 root
mysql -= u root=20
=D0=9E=D0=B1=D0=BD=D1=83=D0=BB=D0=B5=D0=BD= =D0=B8=D0=B5 =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D1=8F
mysql&g= t; update user set authentication_string=3DPASSWORD('') where User=3D'root'= ;=20
=D0= =9A=D0=BE=D0=BC=D0=BC=D0=B5=D0=BD=D1=82=D0=B8=D1=80=D1=83=D0=B5=D0=BC
/etc/rc.conf
mysql_a= rgs=3D""=20
=D0=9F=D0=B5=D1=80=D0=B5=D0=B7=D0= =B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC mysql
/usr/lo= cal/etc/rc.d/mysql-server restart=20
=D0=92=D1=85=D0=BE=D0=B4=D0=B8=D0=BC =D0=B5= =D1=89=D0=B5 =D1=80=D0=B0=D0=B7
mysql -= u root=20
=D0=9E=D0=B1=D0=BD=D0=BE=D0=B2=D0=BB=D1=8F= =D0=B5=D0=BC =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D1=8C
mysql&g= t; ALTER USER USER() IDENTIFIED BY '';=20
=D0=9F=D1=80=D0=BE=D0=B2=D0=B5=D1=80=D1=8F=D0=B5=D0=BC =D0=B7=D0=B0=D0= =BF=D1=83=D1=89=D0=B5=D0=BD =D0=BB=D0=B8 =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1= =80 mysql
netstat= -tap | grep mysql=20
=D0= =9E=D1=81=D1=82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5=D0=BC= =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1=80 mysql
sudo /e= tc/init.d/mysql stop=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC mysql =D0=B2 =D1=80=D0= =B5=D0=B6=D0=B8=D0=BC=D0=B5 =D0=B1=D0=B5=D0=B7 =D0=BF=D1=80=D0=BE=D0=B2=D0= =B5=D1=80=D0=BA=D0=B8 =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D0=B5=D0=B9
sudo my= sqld --skip-grant-tables --skip-networking &=20
=D0= =92 =D0=B4=D1=80=D1=83=D0=B3=D0=BE=D0=B5 =D0=BA=D0=BE=D0=BD=D1=81=D0=BE=D0= =BB=D0=B8 =D0=B7=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC msyql =D0= =BA=D0=BB=D0=B8=D0=B5=D0=BD=D1=82
mysql= pre>=20
=D0= =9E=D0=B1=D0=BD=D0=BE=D0=B2=D0=BB=D1=8F=D0=B5=D0=BC =D0=BF=D0=B0=D1=80=D0= =BE=D0=BB=D1=8C
mysql&g= t; update mysql.user set password =3D password('') where user =3D 'root'; mysql> flush privileges;=20
=D0=B4=D0=BB=D1=8F 5.7 =D0=B8 =D0=B2=D1=8B=D1=88=D0=B5= p>
UPDATE = mysql.user SET authentication_string =3D PASSWORD('MyNewPass'), password_expired =3D= 'N' WHERE User =3D 'root' AND Host =3D 'localhost'; FLUSH PRIVILEGES;=20
=D0= =9E=D1=81=D1=82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5=D0=BC= =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1=80 mysql
sudo my= sqladmin shutdown=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC =D0=B2 =D0=BD=D0=BE=D1= =80=D0=BC=D0=B0=D0=BB=D1=8C=D0=BD=D0=BE =D1=80=D0=B5=D0=B6=D0=B8=D0=BC=D0= =B5 =D1=80=D0=B0=D0=B1=D0=BE=D1=82=D1=8B
sudo st= art mysql=20
=D0= =BF=D0=BE=D0=B4=D0=BA=D0=BB=D1=8E=D1=87=D0=B0=D0=B5=D0=BC=D1=81=D1=8F
mysql -= u root -p=20
=D0=9F=D1=80=D0=BE=D0=B2=D0=B5=D1=80=D1=8F=D0=B5=D0=BC =D0=B7=D0=B0=D0= =BF=D1=83=D1=89=D0=B5=D0=BD =D0=BB=D0=B8 =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1= =80 mysql
netstat= -tap | grep mysql=20
=D0= =9E=D1=81=D1=82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5=D0=BC= =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1=80 mysql
/etc/in= it.d/mysql stop=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC mysql =D0=B2 =D1=80=D0= =B5=D0=B6=D0=B8=D0=BC=D0=B5 =D0=B1=D0=B5=D0=B7 =D0=BF=D1=80=D0=BE=D0=B2=D0= =B5=D1=80=D0=BA=D0=B8 =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D0=B5=D0=B9
sudo -u= mysql mysqld --skip-grant-tables --skip-networking &=20
=D0= =92 =D0=B4=D1=80=D1=83=D0=B3=D0=BE=D0=B5 =D0=BA=D0=BE=D0=BD=D1=81=D0=BE=D0= =BB=D0=B8 =D0=B7=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC msyql =D0= =BA=D0=BB=D0=B8=D0=B5=D0=BD=D1=82
mysql= pre>=20
=D0= =9E=D0=B1=D0=BD=D0=BE=D0=B2=D0=BB=D1=8F=D0=B5=D0=BC =D0=BF=D0=B0=D1=80=D0= =BE=D0=BB=D1=8C
mysql&g= t; update mysql.user set password =3D password('') where user =3D 'root'; mysql> flush privileges;=20
=D0= =9E=D1=81=D1=82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5=D0=BC= =D1=81=D0=B5=D1=80=D0=B2=D0=B5=D1=80 mysql
sudo my= sqladmin shutdown=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D0=BA=D0=B0=D0=B5=D0=BC =D0=B2 =D0=BD=D0=BE=D1= =80=D0=BC=D0=B0=D0=BB=D1=8C=D0=BD=D0=BE =D1=80=D0=B5=D0=B6=D0=B8=D0=BC=D0= =B5 =D1=80=D0=B0=D0=B1=D0=BE=D1=82=D1=8B
/etc/in= it.d/mysql start=20
=D0= =BF=D0=BE=D0=B4=D0=BA=D0=BB=D1=8E=D1=87=D0=B0=D0=B5=D0=BC=D1=81=D1=8F
mysql -= u root -p=20
6.0
=D0=9E=D1=81=D1=82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5= =D0=BC =D0=B4=D0=B5=D0=BC=D0=BE=D0=BD MySQL =D0=B8 =D0=B7=D0=B0=D0=BF=D1=83= =D1=81=D0=BA=D0=B0=D0=B5=D0=BC =D0=B5=D0=B3=D0=BE =D0=B1=D0=B5=D0=B7 =D1=87= =D1=82=D0=B5=D0=BD=D0=B8=D1=8F =D1=82=D0=B0=D0=B1=D0=BB=D0=B8=D1=86=D1=8B = =D1=8E=D0=B7=D0=B5=D1=80=D0=BE=D0=B2
/etc/i= nit.d/mysqld stop /usr/libexec/mysqld --skip-grant-tables --user=3Droot &=20
=D0= =A2=D0=B5=D0=BF=D0=B5=D1=80=D1=8C, =D0=BA=D0=B0=D0=BA =D0=BD=D0=B0=D0=BC = =D1=81=D1=82=D0=B0=D0=BB =D0=B4=D0=BE=D1=81=D1=82=D1=83=D0=BF=D0=B5=D0=BD M= ySQL =D1=81 =D0=BF=D0=BE=D0=BB=D0=BD=D1=8B=D0=BC =D0=B4=D0=BE=D1=81=D1=82= =D1=83=D0=BF=D0=BE=D0=BC, =D1=81=D0=B1=D1=80=D0=B0=D1=81=D1=8B=D0=B2=D0=B0= =D0=B5=D0=BC =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D1=8C =D0=BD=D0=B0 =D0=B5=D0=B4= =D0=B8=D0=BD=D0=B8=D1=86=D1=83:
mysql -= u root -e "UPDATE mysql.user SET Password=3DPASSWORD('1') WHERE User=3D'roo= t'; FLUSH PRIVILEGES;"=20
=D0= =9F=D0=BE=D1=81=D0=BB=D0=B5 =D1=8D=D1=82=D0=BE=D0=B3=D0=BE =D0=BE=D1=81=D1= =82=D0=B0=D0=BD=D0=B0=D0=B2=D0=BB=D0=B8=D0=B2=D0=B0=D0=B5=D0=BC =D0=BF=D1= =83=D1=89=D0=B5=D0=BD=D0=BD=D1=8B=D0=B9 =D0=BD=D0=B0=D0=BC=D0=B8 =D0=B8=D0= =BD=D1=81=D1=82=D0=B0=D0=BD=D1=81 MySQL =D0=B8 =D0=B7=D0=B0=D0=BF=D1=83=D1= =81=D0=BA=D0=B0=D0=B5=D0=BC =D0=BE=D0=B1=D1=8B=D1=87=D0=BD=D1=8B=D0=B9 =D1= =81=D0=B5=D1=80=D0=B2=D0=B5=D1=80:
killall= -9 -r mysqld /etc/init.d/mysqld start=20
7.0/8.0
systemc= tl stop mysqld=20
systemc= tl set-environment MYSQLD_OPTS=3D"--skip-grant-tables"=20
systemc= tl start mysqld=20
mysql -= u root=20
mysql&g= t; UPDATE mysql.user SET authentication_string =3D PASSWORD('') WHERE User =3D 'root' AND Host =3D 'localhost'; mysql> FLUSH PRIVILEGES; mysql> quit=20
systemc= tl stop mysqld=20
systemc= tl unset-environment MYSQLD_OPTS=20
systemc= tl start mysqld=20
mysql -= u root -p=20
=D0=97=D0=B0=D0=BF=D1=83=D1=81=D0=BA =D0= =B1=D0=B5=D0=B7 =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D0=B5=D0=B9 =D0=B4=D0=BB=D1= =8F Percona-Server
mysqld = --initialize-insecure=20
=D0=9E=D1=81=D1=82=D0=B0=D0=BD=D0=BE=D0=B2=D0=B8=D1=82=D1=8C =D0=B1=D0= =B0=D0=B7=D1=83
/etc/in= it.d/mysql stop=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D1=82=D0=B8=D1=82=D1=8C =D0=B1=D0=B5=D0=B7 =D0= =BF=D1=80=D0=B8=D0=B2=D0=B5=D0=BB=D0=B5=D0=BD=D0=B8=D0=B9
mysqld_= safe --skip-grant-tables &=20
=D0= =A2=D0=B5=D0=BF=D0=B5=D1=80=D1=8C, =D0=BA=D0=BE=D0=B3=D0=B4=D0=B0 =D1=81=D1= =82=D0=B0=D0=BB =D0=B4=D0=BE=D1=81=D1=82=D1=83=D0=BF=D0=B5=D0=BD MySQL =D1= =81 =D0=BF=D0=BE=D0=BB=D0=BD=D1=8B=D0=BC =D0=B4=D0=BE=D1=81=D1=82=D1=83=D0= =BF=D0=BE=D0=BC, =D1=81=D0=B1=D1=80=D0=B0=D1=81=D1=8B=D0=B2=D0=B0=D0=B5=D0= =BC =D0=BF=D0=B0=D1=80=D0=BE=D0=BB=D1=8C =D0=BD=D0=B0 =D0=B5=D0=B4=D0=B8=D0= =BD=D0=B8=D1=86=D1=83:
mysql -= u root -e "UPDATE mysql.user SET Password=3DPASSWORD('1') WHERE User=3D'roo= t'; FLUSH PRIVILEGES;"=20
=D0= =9E=D1=81=D1=82=D0=B0=D0=BD=D0=BE=D0=B2=D0=B8=D1=82=D1=8C mysql
/etc/in= it.d/mysql stop=20
=D0= =97=D0=B0=D0=BF=D1=83=D1=81=D1=82=D0=B8=D1=82=D1=8C =D0=B2 =D0=BD=D0=BE=D1= =80=D0=BC=D0=B0=D0=BB=D1=8C=D0=BD=D0=BE=D0=BC =D1=80=D0=B5=D0=B6=D0=B8=D0= =BC=D0=B5
/etc/in= it.d/mysql start=20