How to Setup CentOS testing repo
Setting up repos
To install the CentOS testing repo, along with the yum-priorities plugin.
# cd /etc/yum.repos.d
# wget http://dev.centos.org/centos/5/CentOS-Testing.repo
# yum install yum-priorities
The priorities plugin can be used to enforce ordered protection of repositories, by associating priorities to repositories. Packages from repositories with a lower priority will never be used to upgrade packages that were installed from a repository with a higher priority.
Tags: Centos, repo, Setup, testing
The first thing to do is to install the packages. You need to ensure Apache is set up first.
Installation
# yum install mod_dav_svn subversion
When you install from yum, there’s a longer list than the two packages above that will automatically resolve themselves. Some other things will be installed automatically.
Subversions svn tool is the command line client that you will use to talk to the database. To see the use of the tool:
References
Subversion: http://subversion.tigris.org/
Version Control with Subversion: http://svnbook.red-bean.com/
Tags: Centos, Subversion
mysqldump - a database backup program
The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server).
If you are doing a backup on the server and your tables all are MyISAM tables, consider using the mysqlhotcopy instead because it can accomplish faster backups and faster restores. See mysqlhotcopy(1).
There are three general ways to invoke mysqldump:
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] –all-databases
If you do not name any tables following db_name or if you use the –databases or –all-databases option, entire databases are dumped.
Tags: backup, database, mysqldump, program
How to check privileges for an mysql account.
To check the privileges for an account, use SHOW GRANTS:
mysql> SHOW GRANTS FOR ‘root’@'localhost’;
+—————————————————-+
| Grants for root@localhost
+—————————————————-+
| GRANT ALL PRIVILEGES ON *.* TO ‘root’@'localhost’ IDENTIFIED BY PASSWORD ‘*C406D12D7025EFA560629ABD992F09C9E28002C6′ WITH GRANT OPTION |
+—————————————————-+
1 row in set (0.00 sec)
mysql>
Tags: Account, check, mySQL, privileges
How to enable access from all machines for mysql user.
To create a user who has access from all machines in a given domain (for example, serverbuddies.com), you can use the “%” wildcard character in the host part of the account name:
mysql> CREATE USER ‘myname’@'%.serverbuddies.com’ IDENTIFIED BY ‘mypass’;
To do the same thing by modifying the grant tables directly, do this:
mysql> INSERT INTO user (Host,User,Password,…)
-> VALUES(’%.serverbuddies.com’,'myname’,PASSWORD(’mypass’),…);
mysql> FLUSH PRIVILEGES;
Tags: Access, enable, mySQL, User
