Run MySQL with a normal user?
On Unix, the MySQL server mysqld can be started and run by any user. To change mysqld to run as a normal unprivileged Unix user …
Latest articles for category: Database
Why should I disable autocommit while dumping a database?
Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the …
How does memory overcommit affect PostgreSQL?
In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL. Because of the way that the kernel implements memory overcommit, …
Create PostgreSQL user account
It is advisable to run PostgreSQL under a separate user account. This user account should only own the data that is managed by the server, …
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 …
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 …
Showing 34 - 44 of 90 articles