Tsis nco qab lub hauv paus password ntawm VestaCP MySQL?Teem thiab hloov kho tus password hauv paus

Ntawm cov tswj vaj huam sib luag, ntau ntauSEOCov neeg yuav VPStsim lub vev xaib, nyiam siv Vesta CP tswj vaj huam sib luag.

• vim VestaCP Tswj vaj huam sib luag, qhov yooj yim tag nrho cov ntaub ntawv teeb tsa tau khaws cia hauv cov ntaub ntawv conf.
• LinuxThaum lub sij hawm tus txheej txheem ntawm kev txhim kho VestaCP ntawm lub system, VestaCP yuav tsis nug rau tswv yimMySQLroot password.
• Tus password yuav raug tsim los ntawm VestaCP.

peb nkag rau hauvphpmyadmin, yuav nrhiav thiab hloov li casMySQL tus password default?

MySQL default password rau VestaCP muaj nyob rau hauv /usr/local/vesta/conf/mysql.conf hauv cov ntaub ntawv.

SSH saib MySQL default password

Koj tuaj yeem nkag mus rau cov lus txib hauv qab no hauv SSH kom pom lub hauv paus password ntawm MySQL ▼

cat /usr/local/vesta/conf/mysql.conf

Nrhiav MySQL password, thiab sau qhov chaw ntawm MySQL password file, koj tuaj yeem nkag mus rau phpMyAdmin database tswj.

Yuav ua li cas hloov lub hauv paus password ntawm MySQL?

Thov saib VestaCP hauv qab no CentOS Yuav hloov MySQL root password li cas.

Kauj Ruam 1:Nkag mus rau MySQL thiab nkag mus rau cov lus txib hauv qab no ▼

mysql -uroot -p

• Nkag mus rau MySQL root password koj saib hauv kauj ruam 1.
• Tom qab ua tiav kev nkag mus, ua qhov kev hloov kho.

Kauj Ruam 2:Hloov MySQL password 

set password for root@localhost = password('新密码');

Kauj Ruam 3:Nyob rau hauv lub xeev ntawm kev nkag mus rau hauv MySQL, refresh cov kev tso cai

mysql> flush privileges;

Yuav ua li cas hloov tus password hauv paus yam tsis tau nkag rau hauv MySQL

mysqladmin -uroot -p旧密码 password 新密码

Tom qab hloov kho tus password hauv paus nrog cov txheej txheem saum toj no, koj yuav tsum hloov kho tus password hauv MySQL default file ▼

vi /usr/local/vesta/conf/mysql.conf

• Hloov tus password dhau los rau koj tus password uas twb muaj lawm.

Yog hais tias tus password hauv MySQL default file tsis hloov, "VestaCP yuam kev: kev sib txuas rau localhost faicoj" error message...

Yog xav paub ntxiv, thov mus saib cov lus qhia no▼

🔗 daws VestaCP yuam kev: kev sib txuas rau localhost ua tsis tiav

Kev nyeem ntawv txuas ntxiv:

🔗VestaCP backend chaw nres nkoj 8083 https tsis raug? Nruab SSL daim ntawv pov thawj tutorial

🔗 Yuav siv VestaCP vaj huam sib luag li cas? Nruab qhov chaw xa ntawv / ntxiv ntau lub npe sau npe & tswj cov ntaub ntawv