BİZİ ARAYIN: 0507 6964120 Canlı Destek Bildirim Yap
Cannot configure Client MySQL in Plesk

Cannot configure Client MySQL in Plesk

[et_pb_section fullwidth=”on” specialty=”off”][et_pb_fullwidth_menu admin_label=”Tam Sayfa Menü” menu_id=”120″ background_color=”#dd9933″ background_layout=”dark” text_orientation=”center” submenu_direction=”downwards” /][/et_pb_section][et_pb_section][et_pb_row][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]

Cannot configure Client MySQL in Plesk

1. Edit MySQL configuration file my.ini located within %plesk_dir%databasesmysqldata.

2. Add parameter skip-grant-tables into the [MySQLD] section.

3. Restart SQL Server.

4. Log into MySQL.

“%plesk_dir%mysqlbinmysql.exe” mysql

5. Execute the following query:

mysql> u pdate user set password=password(‘current_password’) where user=’admin’;

6. Remove skip-grant-tables from within the [MySQLD] section within %plesk_dir%databasesmysqldatamy.ini

7. Restart MySQL Server.

Where `current_password` is the password of admin in client MySQL which is stored in Plesk. It is used by Plesk to control client MySQL server. The current password used by Plesk can be retrieved from the Plesk database using the query below:

%plesk_dir%mysqlbinmysql -uadmin -p`pleskadmin_password` -P8306 psa
mysql> s elect val from misc where param=’mysql_admin_passwd’;

Note: Starting from Plesk 8.x this password is stored in different database: DatabaseServers.

So, e,g, in case of using Mysql as database provider you can use the following command to retrive login and password to client mysql server:

s elect * from DatabaseServers where type=’mysql’

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row][et_pb_column type=”1_2″][et_pb_text admin_label=”Metin” background_layout=”light” text_orientation=”left”]

Sorunuzmu Var?

Bu konu ile ilgili takıldığınız bir konu olursa sağ taraftaki iletişim formundan bize ulaşabilirsiniz.

logo_pp

Teknoasweb Bilişim Teknolojileri
Alper OKCU
Toros Mah. 816 sk. Duygunlar Apt. No 9/2 Konyaaltı / Antalya
Tel: +90 242 231 00 0

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″][et_pb_contact_form admin_label=”İletişim Formu” captcha=”on” email=”alper@teknoasweb.com” title=”İletişim” /][/et_pb_column][/et_pb_row][/et_pb_section]

Bir Yorum Bırakın