Go to ...

Techpository

A Better Technical Repository

RSS Feed

Databases

MYSQL: Retrieve user information

Login: mysql -u user -p List users: select * from mysql.user; Select users: select username from mysql.user; Delete users: delete from mysql.user WHERE User=username;

MYSQL: Remote Administration using port forwarding

If a user like root is allowed to log onto the MYSQL locally only, the following method works perfect for remote administration. You will need to know the following information: 1. MYSQL server name 2. MYSQL username 3. MYSQL database name 4. MYSQL listening port.  Usually 3306 5. Install Mysql Navigator on your linux box Connect

MySQL: Zmanda – Notes and Tips

  Decompressing a mysql-zrm backup: mysql-zrm-extract-backup –source-directory /var/lib/mysql-zrm/20120101092426/ __________________________________________________________________________ Start an immediate backup: mysql-zrm-scheduler –now –backup-set dailyrun –backup-level 0 __________________________________________________________________________ An example crontab setup: (crontab -e) 0 1 * * * /usr/bin/zrm-pre-scheduler –action backup –backup-set dailyrun –backup-level 0 –interval daily 0 4 * * * /usr/bin/mysql-zrm –action purge 0 20 * * * /usr/bin/zrm-pre-scheduler –action

MySQL: Zmanda (mysql-zrm) setup

Zmanda Recovery Manager [ZRM] for MySQL simplifies the life of a Database Administrator who needs an easy-to-use yet flexible and robust backup and recovery solution for MySQL server. This article will show you how, in about 15 minutes, you can: Install ZRM for MySQL locally, on a MySQL Database Server. Configure ZRM for MySQL locally,

MySQL: How to GRANT privileges in MySQL

For the purpose of this article, we are going to use the ‘SELECT’ privilege. All code provided are examples. You will want to make sure that you change: database to the database name you are using. username to your database user. password to a strong password unique to that user. Please read our article: Strong

Older Posts›› ‹‹Newer Posts