How to set up a remote MySQL connection to your database

If you’re an Intek Host user looking to manage your databases with advanced tools like MySQL Workbench, this article will guide you through the process of connecting to our database using Remote MySQL Access. While the integrated phpMyAdmin tool is available, using remote SQL can provide you with additional features and robustness for efficient database […]

Read More

What does this mean – “MySQL server has gone away”?

The most typical cause of the MySQL server has gone away problem is because the query timed out and the connection was ended. This can occur when a MySQL query times out (i.e. is too sluggish). To attempt and help with this error, we propose conducting a MySQL check/optimization through phpMyAdmin, as follows: 1. Sign […]

Read More

What’s the maximum MySQL database size allowed?

Here at Intek Host, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise of only text, this is a lot of space in real terms; to put it into perspective, a client at Intek Host’s average database size is just 10 MB. In the rare event that you […]

Read More

What is MariaDB?

MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL. This makes MariaDB a backward compatible, drop-in replacement for MySQL. We currently run MariaDB version 10.2.29 To check the version of MariaDB: Head to Manage Hosting, then phpMyAdmin. Select the database in the left-hand panel. Select the Query tab at the top. […]

Read More

How To Manually Change WordPress Username & Password from the Database

When you lose your login details, you can manually go through your StackPanel database and set a new username and password. This guide below will help you accomplish this: 1. Open your Intek Host StackPanel and single-click on your File Manager (which is usually located on the Web Files tab).   2. Next open the public_html folder (or the […]

Read More

How do I import a .sql file via phpMyAdmin?

You can use phpMyAdmin to import an .SQL file with your database information. To do this: ● Log in to your database via phpMyAdmin (https://cp.intekhost.net > Manage Hosting > [select package] > phpMyAdmin) ● Choose the database you want to import your .SQL file to from the left hand side. ● Click the Import tab at the top of the page. ● Select Choose File and […]

Read More

Can I view my FTP, email address, or database passwords?

We encrypt all FTP, email, and database passwords so they are not visible as plain text inside your control panel. The exception is the very first FTP account: this password is visible on the right-hand side when you manage your hosting. You’re able to change all passwords and changes are usually processed immediately. Please note: the […]

Read More

Can I set my database hostname as ‘localhost’?

Unfortunately, you would need to set the database hostname as the server that is provided on your MySQL Databases. You can find this by going to the MySQL Databases icon within a package. The hostname you’ll need to use will be something similar to ‘shareddb1b.hosting.stackcp.net’ although it’s likely the database name on your package will be different. […]

Read More