Install PostgreSQL from source
The following are the commands for installing PostgreSQL from source, refer to the INSTALL file for explanation of each: ./configure gmake su gmake install adduser …
Latest articles
Install Microsoft SQL Server
The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer …
Using the mysql_upgrade Command
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, …
Connect to a remote MySQL server
Log into MySQL as a root user by using the following command: mysql -uUSERNAME -pPASSWORD At the mysql prompt type the following replacing databasename with …
How to Install MySQL Server
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions …
Install PhpMyAdmin
Phpmyadmin installations are of two types that is server specific and domain specific. Inorder to install phpmyadmin for the server Download phpmyadmin from https://www.phpmyadmin.net/home_page/downloads.php Download …
Manage Query Cache
You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …
Access MySQL from the command line
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
MySQL Cluster vs. Replication
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
Tune MySQL
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
What to Do if MySql.sock File is Missing
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Showing 804 - 814 of 1347 articles