Bii o ṣe Tun Tun Ọrọ igbaniwọle MySQL tabi MariaDB ṣe ni Linux

Ti o ba n ṣeto MySQL tabi olupin data MariaDB fun igba akọkọ, awọn ayidayida ni pe iwọ yoo ṣiṣẹ mysql_secure_installation laipẹ lẹhinna lati ṣe awọn eto aabo ipilẹ.

Ọkan ninu awọn eto wọnyi ni ọrọigbaniwọle fun akọọlẹ gbongbo data - eyiti o gbọdọ tọju ikọkọ ki o lo nikan nigbati o ba nilo dandan. Ti o ba gbagbe ọrọ igbaniwọle tabi o nilo lati tunto (fun apẹẹrẹ, nigbati oluṣakoso data ba yipada awọn ipa - tabi ti wa ni pipa!).

Nkan yii yoo wa ni ọwọ. A yoo ṣalaye bawo ni a ṣe le tunto tabi gba imularada MySQL tabi MariaDB ọrọ igbaniwọle root ni Lainos.

Botilẹjẹpe a yoo lo olupin MariaDB ninu nkan yii, awọn itọnisọna yẹ ki o ṣiṣẹ fun MySQL daradara.

Bọsipọ MySQL tabi Ọrọigbaniwọle MariaDB

Lati bẹrẹ, da iṣẹ iṣẹ data duro ki o ṣayẹwo ipo iṣẹ, o yẹ ki a wo oniyipada ayika ti a ṣeto tẹlẹ:

------------- SystemD ------------- 
# systemctl stop mariadb

------------- SysVinit -------------
# /etc/init.d/mysqld stop

Nigbamii, bẹrẹ iṣẹ pẹlu --kipe-awọn tabili-itẹwe :

------------- SystemD ------------- 
# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mariadb
# systemctl status mariadb

------------- SysVinit -------------
# mysqld_safe --skip-grant-tables &

Eyi yoo gba ọ laaye lati sopọ si olupin data bi root laisi ọrọ igbaniwọle kan (o le nilo lati yipada si ebute miiran lati ṣe bẹ):

# mysql -u root

Lati igbanna, tẹle awọn igbesẹ ti a ṣe ilana ni isalẹ.

MariaDB [(none)]> USE mysql;
MariaDB [(none)]> UPDATE user SET password=PASSWORD('YourNewPasswordHere') WHERE User='root' AND Host = 'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;

Lakotan, da iṣẹ naa duro, ṣiṣatunṣe iyipada ayika ati bẹrẹ iṣẹ lẹẹkansii:

------------- SystemD ------------- 
# systemctl stop mariadb
# systemctl unset-environment MYSQLD_OPTS
# systemctl start mariadb

------------- SysVinit -------------
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Eyi yoo fa awọn ayipada iṣaaju lati ni ipa, gbigba ọ laaye lati sopọ si olupin data nipa lilo ọrọigbaniwọle tuntun.

Ninu nkan yii a ti sọrọ bi o ṣe le tunto ọrọ igbaniwọle root ti MariaDB/MySQL. Gẹgẹbi igbagbogbo, ni ọfẹ lati lo fọọmu asọye ni isalẹ lati sọ akọsilẹ wa silẹ ti o ba ni ibeere eyikeyi tabi esi. A n reti lati gbọ lati ọdọ rẹ!