Mwayiwala mawu achinsinsi a VestaCP MySQL?Khazikitsani ndikusintha mawu achinsinsi

Pakati pa magulu ambiri owongolera, ambiriSEOAnthu amagula VPSMangani malo okwerera, amakonda kugwiritsa ntchito gulu lowongolera la Vesta CP.

• chifukwa VestaCP Control Panel, makamaka mafayilo onse amasinthidwe amasungidwa mu mafayilo a conf.
• LinuxPanthawi yoyika VestaCP pa dongosolo, VestaCP sidzafunsa zolowetsaMySQLroot password.
• Mawu achinsinsi amapangidwa ndi VestaCP.

tikulowaphpMyAdmin, momwe mungapezere ndikusinthaMySQL password yokhazikika?

Mawu achinsinsi a MySQL a VestaCP alipo /usr/local/vesta/conf/mysql.conf mu file.

SSH kuti muwone mawu achinsinsi a MySQL

Mutha kuyika lamulo ili mu SSH kuti muwone mawu achinsinsi a MySQL ▼

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

Pezani mawu achinsinsi a MySQL, ndipo lembani malo a fayilo yachinsinsi ya MySQL, mukhoza kulowa mu phpMyAdmin database management.

Momwe mungasinthire mawu achinsinsi a MySQL?

Chonde onani VestaCP yotsatira CentOS Momwe mungasinthire password ya mizu ya MySQL.

Khwerero 1:Lowani ku MySQL ndikuyika lamulo ili ▼

mysql -uroot -p

• Lowetsani mawu achinsinsi a MySQL omwe mudawawona mu gawo 1.
• Mukalowa bwino, pangani zosintha.

Khwerero 2:Sinthani password ya MySQL 

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

Khwerero 3:M'malo olowera ku MySQL, tsitsimutsani zilolezo

mysql> flush privileges;

Momwe mungasinthire mawu achinsinsi popanda kulowa mu MySQL

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

Pambuyo posintha mawu achinsinsi ndi njira yomwe ili pamwambapa, muyenera kusintha mawu achinsinsi mu fayilo ya MySQL ▼

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

• Sinthani mawu achinsinsi am'mbuyomu kukhala achinsinsi omwe alipo.

Ngati mawu achinsinsi mufayilo yokhazikika ya MySQL sinasinthidwe, "VestaCP Error: connection to localhost failed" uthenga wolakwika ...

Kuti mupeze yankho, chonde onani phunziro ili▼

Kuthetsa Vuto la VestaCP: kulumikizana ndi localhost kwalephera

Mnyamata wina wa SEO adayika VestaCP: adawonjezera ma database awiri ndi masamba awiri.Chilichonse chikuwoneka ngati bizinesi masiku ano. VestaCP inali ndi vuto lolakwika koma lero atayesa kuwonjezera nkhokwe yachitatu adapeza cholakwika: "Zolakwika: connecti...

Kuwerenga kowonjezera:

VestaCP kumbuyo 8083 doko https ndi yolakwika?Ikani SSL Certificate Tutorial

Gulu lowongolera la VestaCP ndi losavuta komanso losavuta kugwiritsa ntchito: kukhazikitsa gulu lowongolera la VestaCP kumatha kukhazikitsa zokha chitetezo cha satifiketi ya Let's Encrypt SSL, chifukwa chake ndiyotchuka kwambiri pakati pa akatswiri a SEO akunja.Kodi Let's Encrypt ndi chiyani? Let's Encrypt ndi S...

Momwe mungagwiritsire ntchito gulu la VestaCP?Ikani Post Office/Onjezani Ma Domain Angapo & Kuwongolera Fayilo

VestaCP ndi yosavuta, koma yamphamvu komanso yothandiza pa Linux web hosting control panel.Mwachikhazikitso, idzakhazikitsa seva ya nginx, PHP, Mysql, seva ya DNS ndi mapulogalamu ena omwe ayenera kuyendetsa seva yonse ya intaneti, yomwe ndi SEO ...