RSS Feed
Knowledgebase : Security > Database
CONNECTION STRING WITH STANDARD SECURITY: Data Source=SQL_SERVER_IP,MSSQL_PORT;Initial Catalog=DATABASE_NAME;User Id=DATABASE_USER;Password=DATABASE_USER_PASSWORD; ALTERNATIVE SYNTAX 1: Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User ID=DA...
This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables. ABOUT CHARACTER SETS AND COLLATION MySQL enables you to store and process data in a wide variety of languages using various character sets. Fo...
Before you attempt to connect, make sure you have created a database in your hosting account. To connect to your SQL database using SQL Server Management Studio (SSMS), follow the steps listed below: * Open SQL SERVER MANAGEMENT STUDIO, the CONNECT TO ...
CREATING A DATABASE To create a database, follow these steps: 1. Log in to Plesk. 2. In the left sidebar, click DATABASES. The DATABASES page appears. 3. Click ADD DATABASE. The ADD A DATABASE page appears. 4. In the DATABASE NAME text box, type ...
MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitation is 1GB. If a database on your account has exceeded the database size limitation (or it is getting close to reaching the limi...
It's very easy to rename a table in phpMyAdmin. To do so, simply follow these steps: * Log in to cPanel. * From the DATABASES section, click on the PHPMYADMIN icon. * In the narrow left column, select the database containing the table you wis...
STEP 1: BACKING UP THE DATABASES Before you attempt to repair any database, you should back it up first. To back up all of the files from all of your databases, follow these steps: * Log in to your server using SSH. * Stop the MySQL server using th...
HOW TO REPAIR DATABASE TABLES Before we start a repair of a database table, we want to first check to see if we have to do it. 1) Log into your cPanel and select the PHPMyAdmin icon. 2) Select the database you wish to check. 3) Select the tables you...
Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import or export a MySQL database into an existing database on your account. Please note that in the examples below the -P will prompt for ...
Package : phpMyAdmin Date : December 31, 2011 Affected: Enterprise Server 5.0 ______________________________  PROBLEM DESCRIPTION: Multiple vulnerabilities have been found and corrected in phpMyAdmin: Importing a specially-crafted XML file whic...
ATTENTION: All website users using PhpMyAdmin 3.4.8 or older. Dear valued customers, Vendor: phpMyAdmin (http://www.phpmyadmin.net/ [http://www.phpmyadmin.net/]) Product: phpMyAdmin Version affected: 3.4.8 and prior PRODUCT DESCRIPTION: An open-s...
TWEAK MYSQL USING MYSQLTUNER MySQLTuner is used to analyze the MySQL configuration and we can tweak it based on the suggestions it provides. We need to install and run the script and it will show the exact parameters needed to be changed inside the 'my.c...
 ... The MySQL trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MySQL statements on the table: _INSERT, UPDAT...
Copyright © 1998 - 2018 Shinjiru International Inc. All Rights Reserved.