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▼

🔗 Xallin Khaladka VestaCP: ku xidhidhiyaha localhost wuu fashilmay

Akhrinta dheeraadka ah:

🔗VestaCP backend port 8083 https ma saxantahay? Ku rakib tababbarka shahaadada SSL

Sida loo isticmaalo guddiga VestaCP? Ku rakib xafiiska boostada/ku dar magacyo domain oo badan & maamulka faylka