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 ee la heli karo, xirfadlayaal badan oo SEO ah ayaa doorbida inay isticmaalaan guddiga xakamaynta Vesta CP marka ay iibsanayaan VPS si loo dhiso mareegaha .

• 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.

Sideen u heli karnaa oo u beddeli karnaa erayga sirta ah ee caadiga ah ee MySQL marka aan galeyno phpMyAdmin ?

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 habka soo socda ee lagu beddelayo erayga sirta ah ee MySQL ee VestaCP CentOS .

Tallaabada 1: Soo 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: Inta aad gasho MySQL, cusbooneysii mudnaanta.

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 ku jira faylka MySQL ee caadiga ah aan la beddelin, farriinta qaladka "VestaCP Error: connection to localhost failed" ayaa soo muuqan doonta...

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