Change smtp settings in mysql

[ad_1]

I’m not able to receive email while getting the verification email for the admin user. I’m not able to access dashboard. Can i update the settings in mysql manually? Able to access mysql. Please let me know how to update as below. Also let me know how to put the the password by encoding it.

update wp_options set option_value=’a:15:{s:4:”mail”;a:6:{s:10:”from_email”;s:34:”[email protected]”;s:9:”from_name”;s:13:”Universe Docs”;s:6:”mailer”;s:4:”smtp”;s:11:”return_path”;b:1;s:16:”from_email_force”;b:1;s:15:”from_name_force”;b:1;}s:4:”smtp”;a:7:{s:7:”autotls”;b:1;s:4:”auth”;b:1;s:4:”host”;s:18:”smtp.office365.com”;s:10:”encryption”;s:3:”tls”;s:4:”port”;i:587;s:4:”user”;s:34:”[email protected]”;s:4:”pass”;s:72:”password”;}s:7:”general”;a:1:{s:29:”summary_report_email_disabled”;b:0;}s:9:”sendlayer”;a:1:{s:7:”api_key”;s:0:””;}s:7:”smtpcom”;a:2:{s:7:”api_key”;s:0:””;s:7:”channel”;s:0:””;}s:10:”sendinblue”;a:2:{s:7:”api_key”;s:0:””;s:6:”domain”;s:0:””;}s:5:”gmail”;a:4:{s:9:”client_id”;s:0:””;s:13:”client_secret”;s:0:””;s:12:”access_token”;a:0:{}s:13:”refresh_token”;s:0:””;}s:7:”mailgun”;a:3:{s:7:”api_key”;s:0:””;s:6:”domain”;s:0:””;s:6:”region”;s:2:”US”;}s:8:”postmark”;a:2:{s:16:”server_api_token”;s:0:””;s:14:”message_stream”;s:0:””;}s:8:”sendgrid”;a:2:{s:7:”api_key”;s:0:””;s:6:”domain”;s:0:””;}s:9:”sparkpost”;a:2:{s:7:”api_key”;s:0:””;s:6:”region”;s:2:”US”;}s:9:”amazonses”;a:3:{s:9:”client_id”;s:0:””;s:13:”client_secret”;s:0:””;s:6:”region”;s:9:”us-east-1″;}s:7:”outlook”;a:5:{s:9:”client_id”;s:0:””;s:13:”client_secret”;s:0:””;s:12:”access_token”;a:0:{}s:13:”refresh_token”;s:0:””;s:12:”user_details”;a:1:{s:5:”email”;s:0:””;}}s:4:”zoho”;a:6:{s:9:”client_id”;s:0:””;s:13:”client_secret”;s:0:””;s:6:”domain”;s:3:”com”;s:12:”access_token”;a:0:{}s:13:”refresh_token”;s:0:””;s:12:”user_details”;a:1:{s:5:”email”;s:0:””;}}s:4:”logs”;a:1:{s:7:”enabled”;b:0;}}’ where option_name = ‘wp_mail_smtp’;

  • This topic was modified 7 hours, 35 minutes ago by kumarmuthaiah.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer