HOW TO CREATE MYSQL DATABASE

MYSQL is an open source relational database management system - RDBMS created in 1979 and is compatible with almost all platforms including Linux, Unix and Windows. Almost all applications run on web hosting use MYSQL to run the program of web system.

HOW TO CREATE MYSQL DATABASE MALAYSIA WEB HOSTING

MYSQL DATABASE LOGO

HOW TO CREATE MYSQL DATABASE ON CPANEL

1.Log into cPanel web hosting.

2.Click on MySQL® Databases.

3.Create a database name consisting of combination of numbers and alphabet, example; usercp_sECretNaME638.

4.Click on Create Database button.

5.Create a database user and the password, use a combination of numbers and alphabets to improve the safety stage. Please use the Password Generator to create a safe of password.

6.Click on Create User button.

7.Add users to the database, select the database name and the username. Select the add button to continue the setting. Check the privileges required then click on the change button.

how to add database on cpanel

Add an user to the database

HOW TO SETUP EMAIL CLIENT

Email Client software is a remotely e-mail management system and has the same features on the webmail application manager. Users can compose, transmit, store and receive messages via the Simple Mail Transfer Protocol (SMTP) based electronic communication system and X.400 system.

Some brands of email client software for computer;.

Some brands of email client software for smathphone;.

HOW TO SETUP EMAIL CLIENT

Email client

HOW TO SETUP MODZILLA THUNDERBIRD EMAIL CLIENT

1.Download and install he software.

2.Open the software then click on Email setup navigation.

3.Fill in the email details and select the continue button.

4.Choose whether to use IMAP protocol or use POP3 protocol, the IMAP protocol deletes mail from the inbox when an email is deleted on email client. The POP3 protocol will keep the email as long as it is not deleted use an application in webmail.

5.Select the manual configuration button to check back and make sure the protocol link works. Below is an example of SMTP settings.

Incoming : POP3/IMAP , server hostname : pakarhosting.net , Port : 995 ( if use pop3 ) 993 ( if use IMAP ), SSL : SSL/TLS .

Outgoing : SMTP , server hostname : pakarhosting.net , Port : 465, SSL : SSL/TLS .

Fill in the email address on the username form.

Full details of email address can be found on webmail, please refer to HOW TO MANAGE AN EMAIL (3rd). Select configure e-mail client.

6.Click on finish button.

7.Try to send an email by select the write button.

Email client software will check to the inbox at designated times like every 10 minutes.

HOW TO CREATE AN EMAIL ACCOUNT

E-mail or Electronic Mail is a method of authoring, transmitting, storing and receiving messages via electronic communication system based on the Simple Mail Transfer Protocol (SMTP) and X.400 system. Emails are created before the existence of the internet and is an important component of internet creation.

Pakar Hosting offers unlimited web hosting, users are allowed to create an unlimited of email accounts. Three great apps have been selected to run e-mail management systems namely Roundcube, Horde and SquirrelMail, this application can be accessed on special webmail links.

HOW TO CREATE AN EMAIL ACCOUNT PAKAR HOSTING MALAYSIA

Webmail applications

HOW TO CREATE AN EMAIL ACCOUNT

1.Log into cPanel web hosting.

2.Click on Email Accounts.

3.Specify email quota.

4.Click on Create account button.

HOW TO MANAGE EMAIL ACCOUNT

There are two options to manage email the first are access to an application or email management system that has been installed on the server on special link called webmail, example https://webmail.pakarhosting.net. The second option is to use email clients installed on computers and other communication tools such as smartphones.

How to manage email using Roundcube;

1.After email creation on the number 4 above the user can directly access the webmail by selecting the More button to display the hidden link, select Access to Webmail.

2.Or access webmail on special links like https://webmail.pakarhosting.net, login by using email address and password.

3.Click on email address in the top-bar to create an auto response ( autoresponder ) and forwarders.

4.Select Roundcube to open the webmail application.

5.Click on Compose icone to create, save, and send message.

6.Fill in the recipient's form and e-mail title, click on send button to send e-mail.

7.Double clicks an email on the inbox list to open the email.

The guides to use other webmail applications are much the same as how to use roundcube. The difference is the interface and the link name used.

HOW TO INSTALL SSL HTTPS

On HOW TO INSTALL FREE SSL we have explained that ssl/tls is standard security technology to create https link and encrypt all data passing through it, also mentioned the type of tls/ssl certificate Extended Validation ( EV ), Organization Validation ( OV ) and Domain Validation ( DV ). Multi domain ( SAN/UCC ) ssl is used to create https multiple domain on a server, Wildcard ssl is used to create https on main domain and subdomain.

There 3 steps to build https link ie generate Code Signing Recuest or CSR, buy ssl then submit csr to the tls/ssl issuer. The last step is install ssl on cPanel web hosting.

HOW TO GENERATE CSR CODE SIGNING RECUEST

1.Log into cPanel web hosting.

2.Click on SSL/TLS navigate.

3.Click Certificate Signing Recuest.

4.Fill in form then click on generate button.

5.Copy all csr codes, for example;.

—–BEGIN CERTIFICATE REQUEST—–
MIIDBTCCAe0CAQAwgb8xJzAlBgkqhkiG9w0BCQEWGHN1cHBvcnRAcGFrYXJob3N0
aW5nLm5ldDEcMBoGA1UEAwwTa2IucGFrYXJob3N0aW5nLm5ldDEWMBQGA1UEBwwN
S290YSBLaW5hYmFsdTEOMAwGA1UECAwFU0FCQUgxHzAdBgNVBAoMFlBBS0FSIEhP
U1RJTkcgTUFMQVlTSUExCzAJBgNVBAYTAk1ZMSAwHgYDVQQLDBdJbnRlcm5ldCBh
bmQgVGVjaG5vbG9neTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAM2d
FJuAigEpOIRPuwwFFvEykbmBjI5vdbYatIcWlXugA1SNkGsDMYoqHzm483hPMBMp
4gKaaMnpuHdsQMiVpCP3ygvPhtPIz+73X65WuW5A3cB1jkWyrb83hjT2Yw04KY8T
ZnYqJsOJMlKZ4Vh2z2LLrOZaXDWPLYWgoxqBBAY6clgkOY8mippEdwZv/0Ooiuni
7Sxvfy1GLVPXdUzJMYDo6DqbbdGlQa7VHdaT+LjPDaiKd9oO0Md9tRXT2o57x/w0
asXFDgAhqd/ChWqCusd0X+mEphJw1d0l03ihsjJizb5L0OK4/TapsvzQ8t0pbD3T
dzRu3+tUJIp7WslmDuMCAwEAAaAAMA0GCSqGSIb3DQEBCwUAA4IBAQAaKb5a8NMh
rN/fIxmmQyzEL9xziuLiEsewpTvEPVwZkZBEIT0enDduAFoBWyXQo9Yher/5OgWT
cbPYnEEB05c1Z/6UDp+JaIsAuzXbBu/ShiUdQC6OJoVzujrTx0gntyGb80xy5Y5A
Xs5ptBy5uGYkfqyaG7iHZVj5NlUoiKBH/GkM5M85fKbwlRkB97Or40TUCfFKaggn
UHpQ4fmhY3iZlaY52o2ZGfwxX08UZbdaBaRzzc1aX762FF8U7LkU68/kMWS0KRrv
bnZ3nb3Fp8tOmz8Cqu7iflYVVNbcTkP128RsUP8rMRoIgzXwJOnyFqbXzvNiWCP3
T48R8jibfmMK
—–END CERTIFICATE REQUEST—–

BUY SSL CERTIFICATE

Required to send csr in ssl purchase, please open ticket to buy ssl on Pakar Hosting. Domain ownership need to be verified by use dns, a file on special link or email. Tls/ssl will be issued after confirmation and conditions are met.

HOW TO INSTALL SSL HTTPS ON CPANEL AND WEBHOSTING
How to generate Signing Recuest .csr

HOW TO INSTALL SSL HTTPS ON CPANEL

1.Log into cPanel web hosting.

2.Click on SSL/TLS navigate.

3.Click on Certificates CRT.

4.Upload pakarhosting_net.crt ( certificate file ) or copy all the codes inside it then paste in form submission then save.

5.Back to SSL/TLS navigate page.

6.Click on Install ssl.

7.Click on Browse certificates button, then select the ssl/tls that has been uploaded.

8.Copy and paste all the codes in CA Bundle certificate if required.

9.Click on Install certificate button.

HOW TO INSTALL FREE SSL

The SSL ( Secure socket layer ) recently called as TLS ( Transport layer security ) is standard security technology to encrypted links beetween a website server and web browser. This link insure that all data passed between the server and the web hosting remains private.

Type of ssl certificates :

Extended Validation ( EV ) ssl, the applicant is required to submit an evidence that the organization or company is registered with the authorized agency. The periode to issue this ssl is up to 7 days to confirm the evidence has sent. EV ssl feature will show the company's name to be displayed on web browser.

malaysia web hosting ssl certificates

EV ssl on twitter - Pakar Hosting Malaysia

Organization Validation ( OV ) ssl has same application process on ev ssl, required to submit an evidence to be verified on authorized agency. The difference is ov ssl does not display company's name on web browser, user can find the company's name on ssl information only.

Domain Validation ( DV ) ssl is ssl type without officially organization verification, the verification process is based on ownership by using the link, dns or email.

The ssl issuer also offer ssl certificates which can be used on multiple websites, such as Multi Domain ( SAN / UCC ) and Wilcard ssl, to create https on main domain and subdomains.

HOW TO INSTALL LET'S ENCRYPT ON CPANEL

1.Log into cPanel web hosting.

2.Click on Let's Encrypt icone.

3.Click on +Issue navigate.

4.Select the link to install ssl.

5.Click on +Issue button, a ssl generated automatically if there is no problem on verifying the domain owner. Please open ticket if ssl certificates is not generated to get advice, possibility the domain is using a proxy like cloudflare dns.

HOW TO USE FTP CLIENT

FTP client is software designed to copy files from a computer ( localhost ) to web hosting and otherwise, ftp client can also be used to manage files stored on the web hosting by remotely. Every features in file manager system can be do without access to web hosting.

Related: HOW TO USE FILE MANAGER.

Some brands of ftp client is cURL, Cyberduck, FAR Manager, FileZilla, FireFTP, Fugu, gFTP, LTFP, Macfusion, Net2ftp, tnftp and other brands that are available for free and paid version.

HOW TO USE FTP CLIENT FILEZILLA

FileZilla ftp client - pakar hosting malaysia

HOW TO USE FILEZILLA FTP CLIENT

1.Download, install and open the software.

2.Type a ftp address on host, example ftp.pakarhosting.net.

3.Type username and password of cPanel or web hosting to get access the root of web hosting, use username and password of ftp account to access ftp direktory on web hosting.

Related: HOW TO ADD FTP ACCOUNT.

4.Click on Quickconnect button.

5.Click folder on web hosting sections to open directory.

6.Right click on files that stored on web hosting to show navigate like edit, download, delet and other.

7.File uploads method is open directory on the web hosting that file will be stored. Public_html and www is directory for main website.Right click on folder or file on PC sections to upload.

HOW TO ADD FTP ACCOUNT

The file transfer protocol ( ftp ) is used to copy files from a host to another and manage it via TCP/IP. Pakar hosting allows users to create a new ftp account that will be a sub ftp account and gain access to www and public_html directory on web hosting.

HOW TO ADD FTP ACCOUNT

Add an FTP account

HOW TO ADD FILE TRANSFER PROTOCOL ( FTP ) ACCOUNT

1.Log into cPanel web hosting.

2.Click FTP Accounts navigate.

3.Create secret username and password, an example secret@pakarhosting.net.

4.Create a folder name.

5.Specify quota of ftp account.

6.Click on Create ftp account button.

HOW TO USE FILE MANAGER

The file manager system on cPanel is specially designed and allow user to access directly hosting-space to create files, uploads, edit, delete and download files that have been stored on the server.

The file manager on Pakar Hosting is very user friendly with a modern interface, easy to use and comes with a junk folder to recover deleted files.

HOW TO USE FILE MANAGER

fail manager on pakar hosting

HOW TO USE FILE MANAGER

1.Log into cPanel web hosting.

2.Click on file manager icone.

3.Click on folder navigate, the root of url is stored on www and publick_html .

4.Select +file to create new files, select +folder to create new sub-folders.

5.Click on upload icone to upload files and folder from computer.

6.Double click on folder/sub-folder to open it.

7.Click on a file to diplay edit and other navigate.

8.Select settings button to display the hidden files like .htaccess .

HOW TO ORDER A HOSTING

Web hosting services is one of the type of online services that allow users to create websites than can be accessed by interent. Currently hosting has been built with s vsriety of applications to easiest the task such as auto installer scripts, auto installer free-ssl, email management, drag and drop web builder and backup system.

malaysia-best-host kota kinabalu

malaysia-best-host pakar hosting

Pakar Hosting services are based on Linux operating system powered by cPanel the most of popular hosting management.

Has been using SNI technology that allows ssl installation without dedicated IP.

STEPS TO ORDER HOSTING

1.Visite our web hosting promotions page to view the details of packages, then click on order button.

2.Select a form either register a new domain, transfer domain or use an existing domain.

3.Continue, review and select the hosting subscription cycle. You can subscribe additional function like ssl premium.

4.Continue then add the domain add-on which has been offered.

5.Click on continue button.

6.Review the order details then click on Checkout button.

7.Regsiter new account or log in.

8.A invoice will be issued after the purchase is confirmed.

9.Submit a ticket to make payment confirmation.

HOW TO REGISTER A DOMAIN NAME

Domain is a unique code that is designed to represent the address of server to make it easy for users to remember website link. Domain name system or DNS is a system that stores information about hostname in the network. A domain name is divided into Top-Level Domain or TLD Secondary-Sevel Domain and lower-level domain.

The Top-Level Domain TLD is the last part of domain name, for example pakarhosting.net  the net is the top-level domain. TLD divided into categories like gTLD for generic such as .com and .net, ccTLD for country-code such as .my .sg and .id, and sTLD for sponsored such as .museum and .asia.

The Secondary-Level Domain is the second part of domain name before the top-level domain TLD, Lower-Level domain is the third part and so on part of domain name before the secondary-level domain SLD, for example www.pakarhosting.net consist of www as lower-level domain, pakarhosting as secondary-level domain SLD and net as TLD. Country-Code Secondary-Level Domain ccSLD is the part of domain before ccTLD such as .com.my, .com.sg and .co.id .

cara daftar domain malaysia
internet networks

HOW TO REGISTER A DOMAIN NAME IN PAKAR HOSTING

1.Type a domain name into the domain search form at home-page and domain promotion-page of our website, then click on search button or enter.

2.Click on order button then search.

3.Select the add on, id protection is to hide the administrator data in the world wide. Dns management is to manage the records of domain to configure it within blogspot, shopify, tumblr and others system.

4.Type the hosting name server if you want configure domain within others hosting provider.

5.Click on checkout button.

6.Register new account or log into existing account.

7.A invoice will be generated after confirming the purchase.

8.Open ticket and mentioan to the admin that you already make payment.