Ua galo le upu fa'a'a'a fa'aletonu ole VestaCP MySQL?Seti ma sui le upu faataga a'a

Faatasi ai ma le tele o panele pulea, teleSeoTagata faʻatau VPSfausia se upega tafa'ilagi, mana'o e fa'aoga le Vesta CP control panel.

• aua VestaCP Pulea vaega, e masani lava o faila fetuutuunai uma e teuina i faila conf.
• LinuxI le faagasologa o le faʻapipiʻiina o le VestaCP i luga o le polokalama, o le a le fesili VestaCP mo se faʻaogaMySQLupu faataga a'a.
• O le upu faataga e otometi lava ona gaosia e VestaCP.

matou te ulufale i totonuphpMyAdmin, fa'afefea ona su'e ma suiMySQL le upu faataga e le mafai?

O loʻo iai le MySQL password password mo VestaCP i totonu /usr/local/vesta/conf/mysql.conf i le faila.

SSH e vaʻai i le MySQL password password

E mafai ona e ulufale i le poloaiga o loʻo i lalo i le SSH e vaʻai ai i le faʻaogaina o le password root MySQL ▼

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

Su'e le MySQL password, ma fa'amaumau le nofoaga o le MySQL password file, e mafai ona e ulufale i le phpMyAdmin database management.

E faʻafefea ona suia le aʻa o le MySQL password?

Fa'amolemole va'ai le VestaCP nei CentOS E faʻafefea ona sui le MySQL root password.

Laasaga 1:Ulufale i MySQL ma ulufale i le poloaiga lenei ▼

mysql -uroot -p

• Ulufale i le MySQL root password na e vaʻaia i le laasaga 1.
• A mae'a manuia le saini, fai le suiga.

Laasaga 2:Suia le password MySQL 

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

Laasaga 3:I le tulaga o le saini i totonu i MySQL, toe faʻafouina faʻatagaga

mysql> flush privileges;

E faʻafefea ona sui le upu faʻaulu e aunoa ma le saini i totonu MySQL

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

A maeʻa ona suia le faʻaupuga aʻa i le auala o loʻo i luga, e tatau ona e suia le faʻaupuga i le MySQL default file ▼

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

• Suia le upu faataga muamua i lau upu faataga o iai.

Afai e le suia le uputatala i le faila faaletonu MySQL, "VestaCP Error: sootaga i localhost faita'ita'ia" fe'au sese...

Mo le fofo, fa'amolemole tagai ile a'oa'oga lenei▼

🔗Foia VestaCP Error: feso'ota'iga ile localhost ua le manuia

Faitau atili:

🔗VestaCP pito i tua uafu 8083 https e le aoga? Fa'apipi'i a'oa'oga fa'ailoga SSL

🔗E faʻapefea ona faʻaogaina le VestaCP panel? Fa'apipi'i le falemeli/fa'aopoopo le tele o igoa ole laiga & pulega faila