Hello all, I checked over the internet and I couldn’t find a possible script to backup multiple databases using percona backup tool. Hence, I wrote it myself. The below script will help us to backup at most 3 databases...
Continue reading →
Hi, Are you trying to enable bookmarks in your phpMyAdmin page.?.. The following steps will help you to enable it. Login to mysql CREATE USER 'pma'@'localhost' IDENTIFIED by 'pmapass'; GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY...
Continue reading →
Hi, You can reset forgotten MySQL’s root password by following the below steps. First stop the running MySQL process by using the following command. [user@linux]# /etc/init.d/mysql stop Then start the mysql daemon by skipping the grant tables which stores the...
Continue reading →
Command to create mysql user ============================ CREATE USER 'username'@'localhost' IDENTIFIED by 'password'; Command to grant all privileges to a user to databases starting with any name ============================================================================= GRANT ALL PRIVILEGES ON database_.* TO 'username'@'localhost' IDENTIFIED BY 'password'; flush privileges; The...
Continue reading →
All MySQL helping commands updated in helpinlinux.com are displayed here.
Continue reading →