RSS Feed
Knowledgebase : MySQL
     
INTRO TO CPANEL MYSQL DATABASES Each database you use on your account needs to have a distinct name. Each database you connect to needs a database username assigned to the database so your scripts/website can connect to it. For this document, we'll a...
In order for your MySQL database to work as intended, it will need a script calling or querying the database for the information it stores. In order to do this, you must connect your script to the database with a configuration file. CONFIGURATION SET...
If CPANEL IS DISPLAYING THE WRONG VERSION OF MYSQL you'll need to access the filesystem for that particular user and remove/rename a file or two... * If cPanel is displaying the wrong version of MySQL, you'll need to: cd /home/cpanelusername/...
Let's say you're developing a script on your PC at home, and you need to connect to your database remotely using a MySQL admin program. No problem. This procedure is a little quirky, but here are the steps to grant remote access to your database. _NOTE...
First, create the database.. /path/to/bin/mysqladmin -u $mysqlusername -p$mysqlpassword create $mysqldatabasename Then, add user permission to it.. /path/to/bin/mysqladmin -u usernamehere -ppasshere create databasename Finally, add the tables back...
mysqldump -u DBUSER -pDBPASS DBNAME > dump.sql Replace the text in the uppercase letters with the appropriate information: * DBUSER - Database user with privileges to the database * DBPASS - Password for the database user * DBNAME - Database ...
mysql -u DBUSER -pDBPASS DBNAME < dump.sql Replace text in uppercase with the appropriate information: * DBUSER - Database user with privileges to the database * DBPASS - Password for the database user * DBNAME - Database name ...
It's easy to learn how to manage MySQL databases with phpMyAdmin. Let's get started: * Log in to your cPanel account [1] * Click PHPMyAdmin in the Databases section * Click Test in the left-hand side of your screen in the gray shaded area ...
The easiest way to achieve merging two MySQL databases is to essentially copy data from a table to another table and back again. Both databases need to exist on the same account. If they do not, you will need to create a backup of one and move it ov...
MySQL is the world's most widely used open-source relational database management system that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for ...
MYSQL QUERY BROWSER is an alternative to phpMyAdmin when it comes to managing your MySQL databases. You can use it to create, drop, and edit tables and perform queries. Setting up MySQL Query Browser to work with your account is relatively simple. PR...
SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data, or destruction of critical data. SQL injection attacks should only be a concern for PHP deve...
Help Desk Software by Kayako fusion