Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `migrations` at row: 1 Rumi, April 26, 2018 You can add –max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] section of your my.cnf Note: it will not work if it is not under the [mysqldump] section… Related MySQL MySQLMySQLDump
Install MySQL 5.7 on Ubuntu 20.04 January 9, 2024 Prerequisites Linux servers running Ubuntu 20.04 root privileges Step 1 – Add MySQL APT repository in Ubuntu Ubuntu already comes with the default MySQL package repositories. In order to add or install the latest repositories, we are going to install package repositories . Download the repository using the below command:… Read More
Reset a MySQL root password for Debian July 14, 2016 Use the following steps to reset a MySQL root password by using the command line interface. Stop the MySQL service (Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run… Read More
Perfect way to reset MySQL Root Password on Debian/Ubuntu August 9, 2016 If you forgot your MySQL root password, you can reset it by following these steps. 1. Stop the MySQL service. service mysql stop 2. Start MySQL without password and permission checks. mysqld_safe –skip-grant-tables & 3. Press [ENTER] again if your output is halted. 4. Connect to MySQL. mysql -u root… Read More