Miyaad illowday erayga sirta ah ee asalka ah ee VestaCP MySQL?Deji oo wax ka beddel erayga sirta ah ee xididka

Ka mid ah guddiyada xakamaynta badan, badanSEODadku waxay iibsadaan VPSdhisa website, door bidaan inaad isticmaasho guddiga xakamaynta Vesta CP.

• maxaa yeelay VestaCP Guddiga xakamaynta, asal ahaan dhammaan faylasha qaabeynta waxaa lagu kaydiyaa faylasha conf.
• LinuxInta lagu jiro rakibaadda nidaamka VestaCP, VestaCP ma waydiin doonto wax gelintaMySQLxidid erayga sirta ah.
• Furaha si toos ah ayaa loo soo saaray VestaCP.

waanu galeynaaphpMyAdmin, sida loo helo oo wax looga beddeloMySQL erayga sirta ah ee caadiga ah?

Kalsoonida MySQL ee VestaCP ayaa ku dhex jirta /usr/local/vesta/conf/mysql.conf faylka ku jira.

SSH si aad u aragto erayga sirta ah ee MySQL

Waxaad geli kartaa amarka soo socda gudaha SSH si aad u aragto erayga sirta ah ee asalka ah ee MySQL ▼

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

Soo hel erayga sirta ah ee MySQL, oo ​​qor meesha uu ku yaal faylka sirta ah ee MySQL, waxaad gali kartaa maamulka xogta phpMyAdmin.

Sidee loo beddelaa erayga sirta ah ee MySQL?

Fadlan eeg VestaCP soo socda CentOS Sida loo beddelo erayga sirta ah ee MySQL.

Tallaabada 1:Gal MySQL oo geli amarka soo socda ▼

mysql -uroot -p

• Geli erayga sirta ah ee MySQL ee aad ku aragtay tallaabada 1.
• Galitaanka guul ka dib, isbedel samee.

Tallaabada 2:Beddel erayga sirta ah ee MySQL 

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

Tallaabada 3:Xaaladda gelitaanka MySQL, dib u cusboonaysii oggolaanshaha

mysql> flush privileges;

Sida loo beddelo erayga sirta ah ee rootiga adigoon gelin MySQL

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

Ka dib markaad wax ka beddesho erayga sirta ah ee habka kor ku xusan, waa inaad wax ka beddeshaa erayga sirta ah ee faylka MySQL ▼

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

• U beddel erayga sirta ah ee hore eraygaaga sirta ah ee jira.

Haddii erayga sirta ah ee faylka MySQL aan la beddelin, "VestaCP Error: Connect to localhost faifariin qalad ah

Xalka, fadlan tixraac casharkan▼

Xalli qaladka VestaCP: ku xidhidhiyaha localhost wuu guuldarraystay

Qaar ka mid ah nin SEO ah ayaa rakibay VestaCP: wuxuu ku daray 2 database iyo 2 sites.Wax walba waxay u muuqdaan ganacsi sidii caadiga ahayd maanta. VestaCP ayaa cilad cilad ku timid balse maanta markii uu isku dayay inuu ku daro keydka xogta 3aad wuxuu helay qaladka: "Error: connecti...

Akhrinta dheeraadka ah:

Asalkii hore ee VestaCP 8083 deked https ma saxantahay?Ku rakib Tababarka Shahaadada SSL

Guddiga kontoroolka VestaCP waa mid sahlan oo sahlan in la isticmaalo: rakibidda guddiga kontoroolka VestaCP waxay si toos ah u rakibi kartaa shaqada amniga ee Aan Encrypt SSL shahaado, sidaas darteed aad ayay caan ugu yihiin xirfadlayaasha SEO ee ajnabiga ah.Waa maxay Aynu Sirinno? Aynu sir dhigno waa S...

Sida loo isticmaalo guddiga VestaCP?Ku rakib Xafiiska Boosta/Ku dar Domains-badan & Maamulka Faylka

VestaCP waa mid aad u fudud, laakiin awood badan oo hufan Linux web kontoroolka martigelinta.Sida caadiga ah, waxay ku rakibi doontaa nginx server, PHP, Mysql, server DNS iyo software kale oo ay tahay in uu maamulo server buuxa, kuwaas oo dhamaantood SEO ah.