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:uxhumano ku-localhost akuphumelelanga

Ukufunda okunwetshiwe:

🔗VestaCP backend port 8083 https ayivumelekile? Faka okokufundisa kwesitifiketi se-SSL

🔗Ungayisebenzisa kanjani iphaneli yeVestaCP? Faka iposi/engeza amagama amaningi wesizinda nokuphathwa kwefayela