If your server has DirectAdmin installed as the control panel with the CustomBuild plugin, MySQL can be updated with the following steps: 1. Navigate to the custombuild folder # cd /usr/local/DirectAdmin/custombuild 2. Edit the options.conf as below: # mysql=5.1 # mysql_inst=yes # mysql_backup=yes **MySQL: possible values are 5.0, 5.1, 5.3, 5.5, 5.6
Introduction This knowledge base will guide you through the steps to create a MySQL database in DirectAdmin Prerequisites Access to DirectAdmin: Ensure you know your username and password to log in to DirectAdmin. Steps to create MYSQL Database 1. Login into Direct Admin as user. 2. Under Your account, click MySQL Management 3.
When you cannot access your website and you are seeing this kind of message: SQL query: DELETE FROM sessions WHERE expiry <1349879630 MySQL said: #126 – Incorrect key file for table ‘./your_database/sessions.MYI’; try to repair it It is possible that the hosting server had crashed and rebooted. After the server has restarted, your database tables
If your web server does not have phpMyAdmin installed, you may add remote host for your database by first accessing your web server via SSH. Step 1 – Login into MySQL server. Step 2 – If you wish to allow database user “ips1” to access database “myDatabase” at IP address “192.168.1.1“, execute the following command.
MySQL is a popular choice of database for using in web applications and is a central component of the widely used LAMP (Linux, Apache, MySQL, Perl / PHP / Python) web application software stack. Here is a step by step guide to allow remote access to MySQL database via DirectAdmin. Step 1: Login to your
1. Log into your hosting control panel if you do not know how to access to the mysql database phpMyAdmin page. For plesk users, log into the control panel and go into Database under the Applications & Services category. This will bring you to the page below, where you need to click on the small
In order to generate an MSSQL backup, you could use 3rd party tools such as: Microsoft SQL Server Database Publishing Wizard 1.1 SQL Backup and FTP
Introduction This article provides a steps to enable remote connection for MSSQL (Microsoft SQL Server) Prerequisites Remote SQL Server must have a user that have read and write privileges 1. Remote to your Server using RDP, Open Microsoft SQL Management Studio and connect to your MSSQL Instance. 2. Right click instance > Properties >
By default, if the sum of the disk usage of any user being deleted in DirectAdmin exceeds a certain threshold, the account will be deleted by a background process. To prevent time-outs in your browser when deleting excessively large accounts, DirectAdmin will execute the deletion by adding the command to the background’s task.queue, instead of
Introduction If a particular hosting account is overusing the allocated disk space quota on your server with DirectAdmin installed, it may cause issues for other users on the same server, disk space may be limited. To manage such hosting accounts, there are two methods that can be used to suspend the account. Let’s get started!