An manta kalmar sirri ta asali na VestaCP MySQL?Saita kuma gyara tushen kalmar sirri

Daga cikin bangarori masu sarrafawa da yawa, da yawaSEOMutane suna sayen VPSgina gidan yanar gizo, sun fi son amfani da kwamitin kula da Vesta CP.

• saboda VestaCP Ƙungiyar sarrafawa, ainihin duk fayilolin sanyi ana adana su a cikin fayilolin conf.
• LinuxYayin aiwatar da shigar da VestaCP akan tsarin, VestaCP ba zai nemi shigarwa baMySQLtushen kalmar sirri.
• VestaCP ne ke samar da kalmar wucewa ta atomatik.

muna shigaphpMyAdmin, yadda ake nemo da gyarawaMySQL kalmar sirri ta asali?

Kalmar sirri ta MySQL don VestaCP tana cikin /usr/local/vesta/conf/mysql.conf a cikin fayil.

SSH don duba kalmar sirri ta MySQL

Kuna iya shigar da umarni mai zuwa a cikin SSH don duba tsohuwar kalmar sirri ta MySQL ▼

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

Nemo kalmar sirri ta MySQL, kuma yi rikodin wurin fayil ɗin kalmar sirri na MySQL, zaku iya shiga cikin sarrafa bayanan phpMyAdmin.

Yadda za a canza tushen kalmar sirri na MySQL?

Da fatan za a duba VestaCP mai zuwa CentOS Yadda ake canza kalmar sirri ta MySQL.

shafi na 1:Shiga cikin MySQL kuma shigar da umarni mai zuwa ▼

mysql -uroot -p

• Shigar da tushen kalmar sirri ta MySQL da kuka gani a mataki na 1.
• Bayan shiga cikin nasara, yi gyara.

shafi na 2:Canza kalmar sirri ta MySQL 

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

shafi na 3:A cikin yanayin shiga cikin MySQL, sabunta izini

mysql> flush privileges;

Yadda ake canza kalmar sirri ba tare da shiga MySQL ba

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

Bayan gyaggyara tushen kalmar sirri tare da hanyar da ke sama, dole ne ku canza kalmar sirri a cikin tsohuwar fayil na MySQL ▼

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

• Canja kalmar sirri ta baya zuwa kalmar sirrin da kake da ita.

Idan kalmar sirrin da ke cikin tsohuwar fayil ɗin MySQL ba ta canza ba, "Kuskuren VestaCP: haɗi zuwa localhost failed" saƙon kuskure ...

Don bayani, da fatan za a duba wannan koyawa▼

Magance Kuskuren VestaCP: haɗi zuwa localhost ya kasa

Wasu SEO guy sun shigar da VestaCP: ya kara da bayanan bayanai 2 da shafuka 2.Komai yana kama da kasuwanci kamar yadda aka saba a yau. VestaCP ya sami matsala ta kuskure amma a yau lokacin da yayi ƙoƙarin ƙara bayanai na 3 ya sami kuskure: "Kuskure: connecti...

Karin karatu:

VestaCP baya 8083 tashar jiragen ruwa https bata aiki?Shigar da Koyarwar Takaddun shaida na SSL

Ƙungiyar kula da VestaCP abu ne mai sauƙi kuma mai sauƙi don amfani: shigar da kwamitin kula da VestaCP zai iya shigar da aikin tsaro ta atomatik na Mu Encrypt SSL takardar shaidar, don haka ya shahara sosai tsakanin masu aikin SEO na kasashen waje.Menene Mu Rufewa? Bari mu Encrypt S...

Yadda ake amfani da panel VestaCP?Shigar da Ofishin Wasiƙa/Ƙara Wuraren Wuta da yawa & Gudanar da Fayil

VestaCP mai sauqi qwarai ne, duk da haka mai ƙarfi da ingantaccen tsarin kula da gidan yanar gizon Linux.Ta hanyar tsoho, zai shigar da sabar gidan yanar gizo na nginx, PHP, Mysql, uwar garken DNS da sauran software waɗanda dole ne su gudanar da cikakken sabar gidan yanar gizo, waɗanda duk SEO ne ...