How To Install SSL Certificate in cPanel for WordPress Website
What is SSL
SSL means Secure Sockets Layer. It is a protocol that protects communication on the internet. SSL is used for securing communication between a web browser & a web server. Website address will be from HTTP to HTTPS.
What is SSL Certificates
A website needs SSL certificate in order to keep user data secure, verifying ownership of the website, prevent the attackers from creating a fake version of the site and gain user trust.
Why SSL Certificates Use
Companies and organizations need to install SSL certificates to their websites to secure online transactions and keep their customer information private and secure. We recommend that you use SSL when you set up your email account in an email application as well as in online payment services to protect your data
Types of SSL Certificates
PositiveSSL: 1 domain, Domain Validation, It means before an SSL certificate can be issued, the certificate applicant needs to confirm their domain ownership rights. This is called domain control validation (DCV), Basic HTTPS, Comodo SSL, Low assurance, Great for Personal, Pricing: 3$
PositiveSSLWildcard : Unlimited subdomains, Domain Validation, Basic HTTPS, Comodo SSL, Low assurance, High and Law means, the level of the assurance mostly depends on the certificate validation type, the amount of the information the certificate applicant provides to the Certificate Authority (Comodo, now Sectigo). The deeper is the certificate validation process performed by Comodo (now Sectigo), the higher is the assurance, Great for Personal, Pricing: 38$
Essential SSL : Domain (DV), Single Domain, Great for Personal, Encryption (up to 256-bit), Pricing: 13$
EV SSL: 1 domain, Extended Validation, Company name in browser, Comodo SSL, Very high assurance, Great for Business, Encryption (up to 256-bit), Pricing: 39$
PremiumSSL Wildcard : Unlimited subdomains, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Personal, Great for Personal, Encryption (up to 256-bit), Pricing: 112$
Instant SSL : 1 domain, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Business, Encryption (up to 256-bit), Pricing: $15
PositiveSSL Multi Domain : 3-100 domain seats, Domain Validation, Basic HTTPS, Comodo SSL, Low assurance, Great for Personal, Encryption (up to 256-bit), Pricing: $16
EV Multi Domain SSL : 3-100 domain seats, Extended Validation, Company name in browser, This means, that in the address bar, clickable padlock, you can see company details in certificate properties (for OV and EV certificates)., Comodo SSL, Very high assurance, Great for Business, Pricing: $69
Unified Communication : 3-100 domain seats, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Business, Encryption (up to 256-bit), Pricing: $44
Self-Signed : Self-signed certificate to secure Local IP addresses. It is encrypted but there is no verification by a trusted party that it is handled by the correct source
TOP 20 SSL Certificates Providers/ Authority
Sectigo/ Comodo: Comodo is the former name of Sectigo and is one of the certificate authorities that issue SSL certificates
To configure server to use SSL, you must have an SSL certificate. To obtain the SSL certificate, complete the steps:
Set the OpenSSL configuration environment variable Generate a key file. Create a Certificate Signing Request Send the CSR to a certificate authority (CA) to obtain an SSL certificate. Use the key and certificate to configure Tableau Server to use SSL. Configure a certificate for multiple domain names
SSL Management
SSL installation process via hosting provider is given below –
At first contact / chat with SSL service provider
Then they will make an invoice
Then make payment
Then need to create an email address in the domain
Thank you
You have entered the correct Domain Control Validation code. Your certificate will now be issued and emailed to you shortly. Please close this window now.
FAQ
Q: Are you offering free SSL? So who is your SSL service provider? And which certificate are you providing in hosting package?
Question: How to Check SSL Active or Not?
Answer: Go to the link and input your website and check. www. sslshopper.com/ssl-checker.html
After inputting website below information will come to screen
These results were cached from July 13, 2020, 3:35 am PST to conserve server resources. If you are diagnosing a certificate installation problem, you can get uncached results by clicking here. autogarment.com resolves to 162.241.253.102
Server Type: Apache
The certificate should be trusted by all major web browsers (all the correct intermediate certificates are installed).
The certificate was issued by Let's Encrypt.
Write review of Let’s Encrypt
The certificate will expire in 58 days. Remind me
The hostname (autogarment.com) is correctly listed in the certificate.
Common name: autodiscover.autogarments.com
SANs: autodiscover.autogarment.com, autodiscover.autogarments.com, autogarment.com, autogarments.autogarment.com, autogarments.com, compliance.autogarment.com, cpanel.autogarment.com, cpanel.autogarments.com, cpcalendars.autogarment.com, cpcalendars.autogarments.com, cpcontacts.autogarment.com, cpcontacts.autogarments.com, mail.autogarment.com, mail.autogarments.com, webdisk.autogarment.com, webdisk.autogarments.com, webmail.autogarment.com, webmail.autogarments.com, www.autogarment.com, www.autogarments.autogarment.com, www.autogarments.com, www.compliance.autogarment.com Valid from June 11, 2020 to September 9, 2020 Serial Number: 04711e80e12d4d977884iooce29d0888d7b58d86e97f56 Signature Algorithm: sha25ttg56Wit888hRSAE8888ncryption Issuer: Let’s Encrypt Authority X3
Common name: Let's Encrypt Authority X3
Organization: Let’s Encrypt Location: US Valid from March 17, 2016 to March 17, 2021 Serial Number: 0a01tyu4142000001ooppiiuuy5385736a0b8oop5eca708 Signature Algorithm: sha2uio56WithRSAE7uioncopiryption Issuer: DST Root CSA X3
Question: How to check mix content of http and https in a website
Answer: User below URL to check URL: www.whynopadlock.com
Question: Where is the file of user.ini
Answer: I have renamed the .user.ini file that fixed the issue ! It is in cpanel – File manager – Doc Root: /home1/bab/designview.bab.com
Question: We have purchase host & SSL from xyz.com. If we transfer our hosting to you as VPS hosting, should we use existing SSL purchase from site5.com
Free Domain Privacy keeps your personal info and identity safe & prevents from spam.
Free Domain Privacy replaces your personal info with proxy info in public WHOIS directory.
Free Domain Privacy Prevents spam with private email account for domain inquiries.
Prevents hackers for stealing your own domain or making any other unauthorized changes
Requires your approval in mobile via 2-factor authentication for vital changes e.g. deleting or transferring a domain
Hold on to your domain for an extra 90 days if yyour billing method expires at renewal
Domain Protection puts your domain on lockdown that makes protection accidental and malicious transfers virtually
Domain Protection is online security guard which automatically scans malware and uses continuous security monitoring to tackle new threats. It also monitor search engine to protect your domain reputation and blacklists
All domain extensions (often ccTLDs) aren’t eligible for free Domains By Proxy®, and as a result cannot be used with Domain Privacy.
How to Transfer a Domain
Domain Transfer form own checklist
First unlock your domain. Your domain is unlocked and ready to transfer.
Make sure your administrative contact email is current. (It’s where we send your transfer authorization code.) We’ve also sent your authorization code to the administrative email address: [email protected]
Use the authorization code at your new registrar to complete your transfer.
Verify that the new registrar will set up your DNS zone files. If you don’t do this, your website and email could go down.
Start the domain transfer at your new registrar. (We email you to ensure you requested the transfer.)
Authorize the transfer with your new registrar. (Use the transfer authorization code we email you when you’re done here.)
We email you confirmation when your transfer completes, usually not more than 5-7 days.
Question: How to Optimize WordPress Database & Troubleshooting
Answer: (1) Your database is very bloated. The options table is at 25MB (I’d expect no more than 4MB) (2) The autoloaded dats is over 1MB (I’d expect about 600KB).
Question: How can I optimize a database of wordpress?
Answer: You can optimize under cPanel>>phpmyadmin>>select the database>>select all tables>>optmize.
2. Optimize WordPress Database with Plugins
Advanced Database Cleaner Plugin Features
Clean Database: WordPress database accumulates a lot of extra data such as spam comments, revisions, trashed comments, etc.
Optimizing database will reclaim unused space in tables, which will reduce storage space & improve efficiency when accessing tables. It does not run any code that break down site or delete posts, pages, comments, etc
Revision: WordPress record called “revision” of each saved draft or published item. It allows to see what changes were made in each post & page over time. It consumes a lot of space. SQP query to clean all revisions is: DELETE FROM posts WHERE post_type = ‘revision’
Auto Draft: WordPress saves your post/page when you are editing it before publish called an auto-draft. The sql query used by the plugin to clean all auto-drafts is: DELETE FROM posts WHERE post_status = ‘auto-draft’
Pending Comments: Pending comments are published by users & waiting for your. SQL to clean all pending comments is: DELETE FROM comments WHERE comment_approved = ‘0’
Spam Comments: It is a comment that marked as spam. SQL to clean all spam comments is: DELETE FROM comments WHERE comment_approved = ‘spam’
Trash comment: A trash comment that you have deleted from your WordPress & have been moved to the trash. SQL to clean all trash comments is: DELETE FROM comments WHERE comment_approved = ‘trash’
Trackbacks: Trackbacks allows you to notify other websites have linked to their article on your website. These trackbacks is used to send huge amounts of spam. That is why they should be cleaned if you do not use them. The sql query used by the plugin to clean trackbacks is: DELETE FROM comments WHERE comment_type = ‘trackback’
Pingbacks: Pingbacks allow you to notify other websites owners that you have linked to their article on your website. Trackback is basically the same things as a pingback. These pingbacks can be used to send huge amounts of spam. SQL to clean pingbacks is: DELETE FROM comments WHERE comment_type = ‘pingback’
Orphan post meta: The post meta data includes the author of the post, when it was posted. Sometimes post meta data information becomes orphan & does not belong to any post called “orphan postmeta” & should be cleaned since they are not useful. SQL to clean all orphan postmeta is: DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL
Orphan comment meta: Orphan comment meta concern comments & not posts. SQL to clean all orphan comment meta is: DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM comments)
Orphan user meta: The user meta data is the information provide to viewers about each user. This information usually includes additional data that is not stored in the users table. Sometimes user meta data information becomes orphaned are called “orphaned usermeta” . SQL to clean all orphan comment meta is: DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)
Orphan user meta: It includes additional data that is not stored in the terms table and sometimes meta data information becomes orphaned. SQL to clean all orphan comment meta is: DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms)
Orphan Relationships: Sometimes the wp_term_relationships table becomes bloated with many orphaned relationships. This happens particularly often if you’re using your site not as a blog but as some other type of content site where posts are deleted periodically. Over time, you could get thousand of term relationships for posts that no longer exist which consumes a lot of database space. SQL to clean all orphan relationships is: DELETE FROM term_relationships WHERE term_taxonomy_id=1 & object_id NOT IN (SELECT id FROM posts)
Expired Transients: A way of storing cached data in DB temporarily by giving it a name. Expired transients are expired & still exist in the database.
Advanced Database Cleaner Plugin Benifits
Remove old Revisions of posts & pages: WordPress stores a record called revision of each saved draft or published update. This system allows you to see what changes were made in each post and page over time
Remove old Auto drafts : WordPress automatically saves your post / page while you are editing it. This is called WordPress auto draft. If you don’t hit the publish/update button, then the post/page will be saved as auto-draft and any modification to your post/page will not be visible in your public site. Over time, you could have multiple auto-drafts that you will never publish and hence you can clean them.
Remove trash posts
Remove pending comments
Remove spam comments
Remove trash comments
Remove pingbacks
Remove trackbacks
Remove orphan post metadata
Remove orphan comment metadata
Remove orphan user metadata
Remove orphan term metadata
Remove orphan relationships
Remove expired transients
Display & view orphaned information before making a database clean-up so you can be sure about what you are going to clean-up
Schedule database clean up to run automatically
Display database tables information such as the number of rows, table size, etc.
Optimize database tables
Repair corrupted database tables or damaged ones
Schedule database optimization &/or reparation to run automatically & specify what tables should be optimized &/or repaired
Empty database tables rows
Clean & Remove database tables
Display options list
Display options information such as option name, option value, option size, option autoload
Clean & Remove options
Set options autoload
Clean & Remove scheduled tasks
Plugins Garbage Collector (Database Cleanup)
Some plugins create & use its own database tables. Those tables are left in your database after plugin deletion.
Database Management (Managed WordPress)
Question: What is the user name and password of phpmyadmin
Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”
Question: How to get login credential to upload files?
Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”
Question: My site is very slow and It is difficult to work so can u check?
Answer: Cache is not working currently, ttbx3_options | 26 MB | The optionts able earlier was at 26MB, which is very big. I cleaned it up so it is now 4MB. No, you would need to continually optimize / clean up. The possible plugins that may cache to go down -woodmart-core, woo-order-export-lite, wp-hide-security-enhancer, google-captcha. The possible plugins that may cache to go down.
Would it be okay to toggle these plugins for testing?
Database Management (Shared Hosting)
Question: Currently My Database size is large which is 800 Mb. As far I know my I am able to download upto 500 Mb data from server in my current hosting plan. Since it exceed upto 800 Mb, please help me to download it in File Manager. When download will complete I will download it from File Manager
Question: Today I have copy a database and folder of halal.hadisquran.com to make another sub domain named as boi.hadisquran.com.
At first I rename all url inside of autogar1_halaldp from halal.hadisquran.com to boi.hadisquran.com
After that I configured everything excluding htaccess file. Instead that My newly created subdomain boi.hadisquran.com is not working
Answer: Yes . Also, I’ll be very happy if I can help you with Safeguarding your account from Hackers, malwares etc. We actually have a service where our team of experts help customers all day safeguarding their accounts. The service is called Sitelock, where our specialists will recommend you the exact plan as per your requirements for the website security. So, Could you please let me know your Phone Number and Timezone so that I can ask our Experts to contact you?
Question: Who will be admin on Dedicated and VPS server?
Answer: The Dedicated server is self managed server, so once you purchase it you will be owner of it and you have all access to manage the server (b)
WordPress SQL
Change Username: UPDATE wp_users SET user_login = ‘mashiur’ WHERE user_login = ‘admiin’;
Email Marketing for WordPress with Jetpack CRM, Contact and Subscriber Form
Contact Form (WordPress)
You can use the form block. Click the + sign, search for form and add the form block. You can read more about it here: wordpress.com/support/wordpress-editor/blocks/form-block/.
Subscribe Form (WordPress)
Just to confirm, the contact form is specifically our own form block? This is typically used to send you messages through your site, but you could possibly add the email addresses of people who contact you, to your subscribers list: en.support.wordpress.com/import-subscribers-to-a-newsletter/
We have spam protection through Akismet which is a built-in plugin on your website. Akismet is a dedicated plugin only to protect from Spam. So it not just protects from spam form submissions but also spam comments. Other plugins like contact7, wpform etc they do not have a built-in mechanism to protect from spam. They give you DNS records to add for spam protection and its not 100% fool proof.
Mailpoet Email Campaign
It somewhat depends what you need! Should these email campaigns be separate from blog posts? While our “new post” notification emails can possibly work as a newsletter, there’s a sibling product called Mailpoet which may be useful for you to check out: mailpoet.com. Mailpoet are a separate product from WordPress.com, but in the same family! It’s also a service which stores the email addresses of your subscribers locally on your site; so they’re not being moved to a separate server.
Features
HOSTING Self Hosted Stand Alone CRM SIMPLE TO USE Welcome Wizard Welcome Page Modularised Features CUSTOMERS Default Fields (Name, Address, etc) Add Custom Fields Customer Tags Customer Search Standalone CRM Customers Add/Edit Statuses (Lead, Customer, etc) Delete Default Fields Attach Files Segment Contacts Sync with PayPal, Stripe, WorldPay & More QUOTES (PROPOSALS) Quotes for Customers Quote Templates Online Quote Acceptance Quote to Invoice INVOICES Itemised Invoices Download Invoice as PDF Email Invoice as HTML Partial Payment Invoice Templates Power Tools (Export) Pay online with PayPal Pay online with Stripe Recurring Invoices Additional Payment Gateways CLIENT PORTAL Allow clients to access their own area Accept Quotes via Client Portal Pay Invoices via Client Portal Share files with clients TRANSACTIONS Assign Transaction to Invoices Log Incoming Transactions Transaction Tags Log Outgoing Transactions DATA TOOLS Import CSV Export CSV TEAM CRM Overall Admin Custom Team Roles Custom Roles for Customers B2B SALES Enable B2B Mode Create Companies Assign Contacts to Companies Assign Transactions to Companies LEAD GENERATION AND MANAGEMENT Lead Generation Forms Conversion rate tracking Gravity Forms Integration Contact Form 7 Integration Lead Automations REPORTING Individual Customer Activity Log Summary Dashboard Sales Reports Growth Reports Average Revenue Per Customer New Customers Per Period EMAIL OPTIONS Email a contact directly Send Targeted Emails Send Group Emails (Mail Campaigns) Emails sent individually (not bulk ‘to’) Setup Custom SMTP Delivery Routes Customisable Email Templates Enable/Disable System Emails Automatic Open Tracking API & DEVELOPER SUPPORT Connect other services to the CRM API Connector Plugin GitHub/Code Examples INTEGRATIONS Zapier Integration (connect hundreds of apps) PayPal Integration Stripe Integration WooCommerce Integration MOBILE READY Responsive iPhone App Android App MULTI-LANGUAGE, TRANSLATIONS, & LOCALISED Use the CRM in your own language
