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...