Site Overlay

How to install, configure, create user and database with permissions – MySQL

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. Download and Install MySQL from the following link https://dev.mysql.com/downloads/ Configure Create user and database with permissions Starting with MySQL 8Continue readingHow to install, configure, create user and database with permissions – MySQL

postgresql

How to install, configure, create user and database with permissions – PostgreSQL

PostgreSQL: The World’s Most Advanced Open Source Relational Database PostgreSQL is arguably the most advance and powerful opensource enterprise class relational database system. It is the object relational database system and provides the most standard compliant system for the Database designers. It provides the complete support for reliable transactions thatContinue readingHow to install, configure, create user and database with permissions – PostgreSQL

adminer setup script

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consists of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch, and MongoDB. install script Related posts: How to auto login in Postgres from a shell? mysqld – Got packetContinue readingadminer setup script

mysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row

Add –max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] the section of your my.cnf Note: it will not work if it is not under the [mysqldump] section… Related posts: adminer setup script How to install, configure, create user and database with permissions – PostgreSQL How to install, configure, create user and database with permissions – MySQL Cron job forContinue readingmysqld – Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `memcache` at row