{"id":556,"date":"2013-04-16T13:05:05","date_gmt":"2013-04-16T11:05:05","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=556"},"modified":"2013-04-16T13:06:27","modified_gmt":"2013-04-16T11:06:27","slug":"plesk-panelde-table-mysql-servers-doesnt-exist-hatasi","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2013\/04\/plesk-panelde-table-mysql-servers-doesnt-exist-hatasi\/","title":{"rendered":"Plesk Panelde Table ‘mysql.servers’ doesn’t exist hatas\u0131"},"content":{"rendered":"

Table ‘mysql.servers’ doesn’t exist hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc;<\/p>\n

Ssh ile eri\u015ferek a\u015fa\u011f\u0131daki komutlar\u0131 uygulay\u0131n\u0131z.<\/p>\n

[root@webhostingsitesi.com]#mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` -h localhost<\/strong><\/p>\n

mysql> use mysql;<\/strong><\/p>\n

mysql> CREATE TABLE `servers` ( `Server_name` char(64) NOT NULL, `Host` char(64) NOT NULL, `Db` char(64) NOT NULL, `Username` char(64) NOT NULL, `Password` char(64) NOT NULL, `Port` int(4) DEFAULT NULL, `Socket` char(64) DEFAULT NULL, `Wrapper` char(64) NOT NULL, `Owner` char(64) NOT NULL, PRIMARY KEY (`Server_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’MySQL Foreign Servers table’;<\/strong><\/p>\n

Ayhan ARDA<\/p>\n

KOD :

<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
CREATE<\/span> TABLE<\/span> `servers`<\/span> (<\/span> `Server_name`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Host`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Db`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Username`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Password`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Port`<\/span> int(<\/span>4)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span> `Socket`<\/span> char(<\/span>64)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span> `Wrapper`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> `Owner`<\/span> char(<\/span>64)<\/span> NOT<\/span> NULL<\/span>,<\/span> PRIMARY<\/span> KEY<\/span> (<\/span>`Server_name`<\/span>)<\/span> )<\/span> ENGINE=<\/span>MyISAM DEFAULT<\/span> CHARSET=<\/span>utf8 COMMENT=<\/span>'MySQL Foreign Servers table'<\/span>;<\/pre><\/div><\/div><\/p>\n
 <\/p>\n
 <\/p>\n
\"Share<\/a>