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

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

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▼

Faitau atili:

Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) fa'asoa "Ua galo le fa'aupuga a'a o VestaCP MySQL?Seti ma Suia le Root Password" o le a fesoasoani ia te oe.

Fa'afeiloa'i e fa'asoa le so'otaga o lenei tusitusiga:https://www.chenweiliang.com/cwl-706.html

Faʻafeiloaʻi i le Telegram channel o le blog a Chen Weiliang e maua ai faʻamatalaga lata mai!

🔔 Ia avea oe ma tagata muamua e maua le taua "ChatGPT Content Marketing AI Tool Usage Guide" i le laina pito i luga o le lisi! 🌟
📚 O lenei taʻiala o loʻo i ai le taua tele, 🌟O se avanoa e seasea maua, aua le misia! ⏰⌛💨
Faasoa ma fiafia pe a e fiafia i ai!
O lau fefa'asoaa'i ma le fiafia o la matou fa'aosofiaga faifaipea!

 

发表 评论

O le a le faʻasalalauina lau tuatusi imeli. Faʻaoga fanua e manaʻomia * Igoa

tusi i luga