{"id":7625,"date":"2020-10-06T11:40:28","date_gmt":"2020-10-06T09:40:28","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&#038;p=7625"},"modified":"2021-02-11T16:12:06","modified_gmt":"2021-02-11T15:12:06","slug":"ftp-et-base-de-donnees-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/ftp-et-base-de-donnees-mysql\/","title":{"rendered":"FTP and MySQL database"},"content":{"rendered":"<p>When you create your WordPress, you will automatically receive an email summarizing all the login information for your WordPress, FTP and MySQL.<\/p>\n<h2>View FTP settings<\/h2>\n<p>On the console, you can view the FTP settings of your WordPress site.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7837\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1.png\" alt=\"\" width=\"1189\" height=\"309\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1.png 1189w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-300x78.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-1024x266.png 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-768x200.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-50x13.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-60x16.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-1-100x26.png 100w\" sizes=\"(max-width: 1189px) 100vw, 1189px\" \/><\/a><\/pre>\n<p>Only the password will not be displayed for security reasons. You can change it at any time.<\/p>\n<h2>Change FTP password<\/h2>\n<p>If you have lost this email or want to change the FTP password, just manage the site in question and click on the button <strong>Edit<\/strong>.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7838\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2.png\" alt=\"\" width=\"1189\" height=\"309\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2.png 1189w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-300x78.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-1024x266.png 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-768x200.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-50x13.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-60x16.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-2-100x26.png 100w\" sizes=\"(max-width: 1189px) 100vw, 1189px\" \/><\/a><\/pre>\n<p>Enter the new password. Feel free to use the <strong>Generate<\/strong> to allow the system to choose a strong random password for you. Click on <strong>Change now<\/strong>.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7839\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3.png\" alt=\"\" width=\"791\" height=\"268\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3.png 791w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3-300x102.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3-768x260.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3-50x17.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3-60x20.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-3-100x34.png 100w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/pre>\n<ul>\n<li>The new password will not be sent to you by e-mail.<\/li>\n<li>The new password is available immediately for use in a <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/gestion-ftp-de-mon-wordpress\/#utiliser-filezilla-comme-client-ftp\" target=\"_blank\" rel=\"noopener noreferrer\">FTP client<\/a>.<\/li>\n<\/ul>\n<h2>View MySQL settings<\/h2>\n<p>On the console, you can see the name of the MySQL database of your WordPress site.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7841\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4.png\" alt=\"\" width=\"1189\" height=\"309\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4.png 1189w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-300x78.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-1024x266.png 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-768x200.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-50x13.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-60x16.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-4-100x26.png 100w\" sizes=\"(max-width: 1189px) 100vw, 1189px\" \/><\/a><\/pre>\n<p>Only the password will not be displayed for security reasons.<\/p>\n    \t\t<div class=\"hts-messages hts-messages--alert  hts-messages--withtitle hts-messages--withicon\"   >\r\n    \t\t\t<span class=\"hts-messages__title\">You do not have the possibility to change the database password.<\/span>    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<h2>View MySQL password<\/h2>\n<p>In case of loss, you can retrieve the connection information through your FTP. You just have to open the file\u00a0<strong>wp-config.php<\/strong>\u00a0<a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/gestion-ftp-de-mon-wordpress\/\" target=\"_blank\" rel=\"noopener noreferrer\">through your FTP<\/a>\u00a0.<\/p>\n<p>Locate the commented line <strong>MySQL database password<\/strong>In the example below, the database password is \"lc7zHGFk657xPset8Lses\".<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7842\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5.png\" alt=\"\" width=\"950\" height=\"788\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5.png 950w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5-300x249.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5-768x637.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5-50x41.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5-60x50.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-5-100x83.png 100w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/a><\/pre>\n<h2>Access to the PHPMyAdmin interface<\/h2>\n<p>From the console, you can manage your databases via the PhpMyAdmin interface. Just click on the button <strong>PHPMyAdmin<\/strong>.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7846\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6.png\" alt=\"\" width=\"1189\" height=\"309\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6.png 1189w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-300x78.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-1024x266.png 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-768x200.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-50x13.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-60x16.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-6-100x26.png 100w\" sizes=\"(max-width: 1189px) 100vw, 1189px\" \/><\/a><\/pre>\n<p>Then put in your username and password. You will need to go back to the email that was given to you when you created your WordPress.<\/p>\n<p>If you have lost your password, you can <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/ftp-et-base-de-donnees-mysql\/#visualiser-le-mot-de-passe-mysql\" target=\"_blank\" rel=\"noopener noreferrer\">access via FTP<\/a> and get it back.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8312\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7.png\" alt=\"\" width=\"982\" height=\"420\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7.png 982w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7-300x128.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7-768x328.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7-50x21.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7-60x26.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-7-100x43.png 100w\" sizes=\"(max-width: 982px) 100vw, 982px\" \/><\/a><\/pre>\n<p>The PHPMyAdmin interface will allow you to manage your database and perform different operations. Always export your database to keep a backup copy before working on it.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8314\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8.png\" alt=\"\" width=\"1653\" height=\"804\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8.png 1653w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-300x146.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-1024x498.png 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-768x374.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-50x24.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-1536x747.png 1536w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-60x29.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-8-100x49.png 100w\" sizes=\"(max-width: 1653px) 100vw, 1653px\" \/><\/a><\/pre>\n<h2>Change MySQL password<\/h2>\n<p>It is possible to change the password of your MySQL database, but only from the PHPMyAdmin interface. This means that you must have the current password to access and replace it with the new one.<\/p>\n<p>It is enough to <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/ftp-et-base-de-donnees-mysql\/#acceder-a-linterface-phpmyadmin\">go to PHPMyAdmin<\/a> then click on the link\u00a0<strong>Change the password<\/strong>.<\/p>\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8355\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9.png\" alt=\"\" width=\"993\" height=\"461\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9.png 993w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9-300x139.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9-768x357.png 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9-50x23.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9-60x28.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-9-100x46.png 100w\" sizes=\"(max-width: 993px) 100vw, 993px\" \/><\/a><\/pre>\n<p>You can let the system generate a strong and secure password for you. Then click on the\u00a0<strong>Run<\/strong>.<\/p>\n    \t\t<div class=\"hts-messages hts-messages--danger  hts-messages--withtitle\"   >\r\n    \t\t\t<span class=\"hts-messages__title\">ATTENTION<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tIt is imperative to change the password of the database in the file <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/ftp-et-base-de-donnees-mysql\/#visualiser-le-mot-de-passe-mysql\">wp-config<\/a> otherwise, your site will display a database connection error.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<pre><a href=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8356\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10.png\" alt=\"\" width=\"747\" height=\"331\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10.png 747w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10-300x133.png 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10-50x22.png 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10-60x27.png 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2020\/10\/ftp-et-base-de-donnees-mysql-10-100x44.png 100w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/a><\/pre>","protected":false},"excerpt":{"rendered":"<p>When you create your WordPress, you will automatically receive an email summarizing all of your WordPress, FTP and MySQL login information. Viewing FTP Settings On the console, you can view the FTP settings for your WordPress site. However, the password will not be displayed for...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-7625","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/7625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=7625"}],"version-history":[{"count":0,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/7625\/revisions"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=7625"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=7625"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=7625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}