Tusitusiga Tusitusiga
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▼
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!
📚 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!