تنظیم phpmyadmin در وب سایت پنل

[ccm]

سلام

phpmyadmin رو نصب کردم ولی موقع تنظیم روی وب سایت پنل مشکل داره و این خطا رو می ده



Page URL:
http://X.X.X.X:9001/Default.aspx?pid=Servers&mid=137&ctl=edit_service&ServiceID=6&ServerID=1


Logged User:
serveradmin


Work on Behalf:
serveradmin


Hosting Space:
0


Stack Trace:
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.WebClientProtocol.Ge tWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtoco l.GetWebResponse(WebRequest request)
at Microsoft.Web.Services3.WebServicesClientProtocol. GetResponse(WebRequest request, IAsyncResult result)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at WebsitePanel.Providers.ServiceProvider.Install()
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at WebsitePanel.EnterpriseServer.esServers.InstallSer vice(Int32 serviceId)
at WebsitePanel.Portal.ServersEditService.btnUpdate_C lick(Object sender, EventArgs e)


+ وقتی وارد phpmyadmin می شم پایینش نوشته :

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click


لطفا در صورت امکان راهنمایی کنید.
باتشکر

[Zagrio.com]

سلام

شما باید فایل کانفیگ براش درست کنید و براش دیتابیس ایجاد کنید و تنظیمات رو از طریق اون انجام بدید.

اطلاعات بیشتر: Installation — phpMyAdmin 4.3.0-dev documentation (http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage)

با سپاس

[ccm]

ممنون از رهنمای شما
من فایل create_tables.sql ایمپورت کردم ، کد
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';
رو هم بدون هیچ تغییری اجرا کردم

و فایل config.inc.php
رو هم به این صورت تغییر دادم
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';

ولی وقتی وارد می شم
خطا می ده The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated

[Zagrio.com]

سلام
به این لینک در سرور خودتون برید و مابقی تنظیمات رو هم انجام بدید


/phpMyAdmin/setup/

[ccm]

سلام
ممنون از راهنماییتون ، مشکل اول با phpmyadmin حل شد

- - - Updated - - -

باسلام
ممنون از راهنمایی های همیشگی اعضای انجمن

راه حل رو پیدا کردم و اینجا بیان می کنم تا اگر برای شما هم این اتفاق افتاد بتونید سریع تر مشکل برطرف کنید

برای مشکلی که عکس رو گذاشتم (Error While installing service on the remote server) باید از
mysql-connector-net-6.7.5.msi

استفاده کنید که لینک دانلودش اینه dev.mysql.com/downloads/file.php?id=451708

منبع : https://manage.accuwebhosting.com/knowledgebase/976/How-to-Resolve-an-error-occurs-while-configuring-MySQL-service-in-WebsitePanel.html