Ukhohlwe iphasiwedi ezenzakalelayo yempande ye-VestaCP MySQL?Setha futhi uguqule iphasiwedi yempande

Phakathi kwamaphaneli amaningi okulawula, amaningiSEOAbantu bathenga i-VPSyakha iwebhusayithi, bancamela ukusebenzisa iphaneli yokulawula ye-Vesta CP.

• ngoba VestaCP Iphaneli yokulawula, ngokuyisisekelo wonke amafayela okumisa agcinwa kumafayela we-conf.
• LinuxPhakathi nenqubo yokufaka i-VestaCP ohlelweni, i-VestaCP ngeke icele okokufakaMySQLiphasiwedi yezimpande.
• Iphasiwedi ikhiqizwa ngokuzenzakalelayo yi-VestaCP.

siyangenaphpMyAdmin, ungathola kanjani futhi ulungiseMySQL iphasiwedi ezenzakalelayo?

Iphasiwedi ezenzakalelayo ye-MySQL ye-VestaCP ikhona /usr/local/vesta/conf/mysql.conf kufayela.

SSH ukuze ubuke iphasiwedi ezenzakalelayo ye-MySQL

Ungafaka umyalo olandelayo ku-SSH ukuze ubuke iphasiwedi ezenzakalelayo yempande ye-MySQL ▼

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

Thola iphasiwedi ye-MySQL, futhi urekhode indawo yefayela lephasiwedi ye-MySQL, ungangena ku-phpMyAdmin database management.

Ungashintsha kanjani iphasiwedi yempande ye-MySQL?

Sicela ubone i-VestaCP elandelayo CentOS Ungashintsha kanjani iphasiwedi yezimpande ze-MySQL.

Isinyathelo sesi-1:Ngena ku-MySQL bese ufaka umyalo olandelayo ▼

mysql -uroot -p

• Faka iphasiwedi yempande ye-MySQL oyibukile esinyathelweni 1.
• Ngemva kokungena ngemvume ngempumelelo, yenza ukuguqulwa.

Isinyathelo sesi-2:Shintsha iphasiwedi ye-MySQL 

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

Isinyathelo sesi-3:Esimeni sokungena ku-MySQL, vuselela izimvume

mysql> flush privileges;

Ungashintsha kanjani iphasiwedi yezimpande ngaphandle kokungena ku-MySQL

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

Ngemva kokulungisa iphasiwedi yempande ngale ndlela engenhla, kufanele uguqule iphasiwedi kufayela elimisiwe le-MySQL ▼

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

• Shintsha iphasiwedi yangaphambilini ibe yiphasiwedi yakho ekhona.

Uma igama eliyimfihlo kufayela elizenzakalelayo le-MySQL lingashintshwa, "Iphutha le-VestaCP: uxhumano ku-localhost failed" umlayezo wephutha...

Ukuze uthole isixazululo, sicela ubheke lesi sifundo▼

Ukuxazulula Iphutha le-VestaCP: ukuxhumeka ku-localhost kuhlulekile

Omunye umfana we-SEO ufake i-VestaCP: wengeze imininingwane emi-2 nezingosi ezi-2.Konke kubukeka kuyibhizinisi njengokujwayelekile namuhla. I-VestaCP ibe nenkinga yephutha kodwa namuhla lapho izama ukwengeza i-database yesi-3 yathola iphutha: "Iphutha: connecti...

Ukufunda okunwetshiwe:

Isizinda se-VestaCP 8083 port https asivumelekile?Faka Okokufundisa Kwesitifiketi Se-SSL

Iphaneli yokulawula ye-VestaCP ilula futhi kulula ukuyisebenzisa: ukufaka iphaneli yokulawula ye-VestaCP kungafaka ngokuzenzakalelayo umsebenzi wokuphepha wesitifiketi se-Let's Encrypt SSL, ngakho idume kakhulu phakathi kwabasebenzi be-SEO bakwamanye amazwe.Kuyini Asibhale Ngemfihlo? I-Let Encrypt iyi-S...

Ungayisebenzisa kanjani iphaneli yeVestaCP?Faka Ihhovisi Leposi/Engeza Izizinda Eziningi Nokuphathwa Kwefayela

I-VestaCP iyiphaneli yokulawula yokubamba iwebhu ye-Linux elula kakhulu, kodwa enamandla futhi ephumelelayo.Ngokuzenzakalelayo, izofaka iseva yewebhu ye-nginx, i-PHP, i-Mysql, iseva ye-DNS kanye nenye isofthiwe okufanele isebenzise iseva yewebhu egcwele, okuyi-SEO yonke...