UKC

How to: Connect to MySQL Remotely

mysqlEnabling Plesk 12 Remote MySQL Connections

1. Connect to your server via SSH.

2. Log into MySQL.

mysql -u admin -p`cat /etc/psa/.psa.shadow`

3. If you are attempting to grant non-localhost access to a user, you should use this line:

GRANT ALL PRIVILEGES ON dbname.* TO username@'IP' IDENTIFIED BY 'password';

Where:

  • dbname is replaced by the database you’d like to open up (a * here will open up all databases)
  • username is replaced by the user to be allowed access
  • IP is replaced by the actual IP to connect from (a % here will open up to all IPs — NOT RECOMMENDED).
  • password is replaced by the desired password. A blank field here will result in no password (NOT RECOMMENDED). Changing the password for that user listed in Plesk will set it as well.

4. Apply these changes by using the MySQL command:

FLUSH PRIVILEGES;

5. Next, quit MySQL by using this command:

quit

6. You may need to allow the source IP from which you are connecting to connect to port 3306 after granting the privileges inside MySQL. Connect to your server as “root” and issue the following command:

iptables -I INPUT -s -p tcp --dport 3306 -j ACCEPT

Be sure to replace with your IP address.

UK Cheapest – The Smart Choice for Domain Registration

10 Reasons Why People Choose UK Cheapest

With so many domain registrars to choose from it is difficult to determine which deals are the best. If you have done your homework you will have already discovered that the initial registration cost is not the only cost you need to consider. We make calculating hidden fees easy – by not having any!

  • NO Transfer Out Fees – Our Transfer Away fees are £0.00, that’s right, we do not hold you to ransom if you register your domain with us.
  • NO WHOIS Record Fees – It is important to keep your WHOIS details up to date. We do not charge for any changes to your WHOIS record.
  • NO IPSTAG Change Fees – No fee to transfer your UK domain or for IPSTAG changes. Many registrars make this fee so high that you are stuck with them.
  • NO Registrar Lock Fees – It is important to lock your non-UK domain but we don’t extort you for it. We give you FREE control over your Domain Locking.
  • NO Transfer Code Fees – Registrars often quote free transfer outs and then charge you for the AUTH code! Get your auth code from us at ANY time for FREE.
  • NO Parked Domain Ads – To many registrars place ads on your parked domains. WE do not place ANY advertisements on YOUR parked domain names.
  • NO Web Forwarding Fees – Forward your domain to any location and change this setting whenever your wish. For free. No charges. Ever.
  • NO Name Server Change Fees – Change your name servers as you wish. You can change your name servers as often as you want at absolutely no cost. Ever.
  • NO DNS Management Fees – This is often an additional fee based service to your domain registration. With us, you have FULL control over your domain DNS Management at all times.
  • No Email Forwarding Fees – Create an unlimited number of email forwarders (or aliases) for every single one of your domain names. Absolutely no charge. Ever.

Avoid nasty surprises. BEFORE you use another provider, find out their hidden fees.

newgtld2

Great New Top Level Domains available for Registration

The Domain Name Landscape has changed recently.

For years, we had little choice of gTLDs (Global Top Level Domains) and we kinda got used to the idea that it was all about .co.uk, .com, .net.

But times have changed.

There are now new gTLDs for all business categories and organisation types.

If your business is accountancy, no longer do you fight to register “MyFirm.com”, you can register the more appropriate “MyFirm.accountants”. How good does that look?

But, you need to hurry. These new tLDS are catching on, and as with the original domain name extensions, soon all the great names will be gone.

Extensions we have added and that are available for registration right now include:

  • .accountants
  • .agency
  • .business
  • .associates
  • .catering
  • .cleaning
  • register-a-domain-name.consulting
  • .design
  • .enterprises
  • .estate
  • .events
  • .gifts
  • .guide
  • .life
  • .limited
  • .media
  • .network
  • .photos
  • .photography
  • .plumbing
  • .properties
  • .pub
  • .restaurant
  • .solutions
  • .town
  • .vet

Register and reserve your business relevant names now – before someone else does!

red_ordernow

How to add Web Site Builder to your Hosting Plan

How to Upgrade Web Presence Builder

All Hosting Plans come equipped with a fully functional version of the Web Presence Builder Trial installed. This enables you to try the product before you commit.

To publish a site built using the Web Presence Builder Trial, you will need to upgrade your Hosting Plan to include a Web Presence Builder license. Login to your Client Area and follow the instructions below.

How to Order an SSL Certificate for your Website

How to add SSL Security to your Hosted Domain

Adding an SSL Certificate to your hosting service could not be easier. You don’t need to worry about the technicalities of generating a Certificate Signing Request (CSR) or even installing the certificate, we do all of that for you. All you need to do is order the certificate.