Go to ...

Techpository

A Better Technical Repository

RSS Feed

Databases

MYSQL: Basic user setup

Make a new user: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; Grant privileges: GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; Flush privileges: FLUSH PRIVILEGES; How To Grant Different User Permissions Here is a short list of other common possible permissions that users can enjoy. ALL PRIVILEGES- as we saw previously, this would allow a

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,

Older Posts›› ‹‹Newer Posts