Tag: mysqld

Installing PowerDNS With MySQL On CentOS

What is PowerDNS? PowerDNS is a MySQL-based DNS server, written in C++ and licensed under the GPL. PowerDNS can be managed through a web interface (PowerAdmin). This guide shows how to install it on CentOS.   1. Installing MySQL [root@server ~]# yum -y install mysql mysql-server   2. Create system […]

Remote access to mysql database

Remote access to mysql database   Step 1 : vi /etc/my.cnf ——————————————— pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = mysql server ip # skip-networking ——————————————— bind-address : IP address to bind to. skip-networking : […]

How can I repair corrupt MySQL tables?

How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables. Login to your server via SSH and change directories to the database that is having problems. cd /usr/local/mysql/var/[DBNAME]/ You will need […]

change Mysql data directory

script to move the datadirectory of mysql #!/bin/bash #/***********************************************************************/ #/***This is the script for changing the data directory of mysql**********/ #/***********************************************************************/ #  This program is free software; you can redistribute it and/or modify #  it under the terms of the GNU General Public License as published by #  the Free […]

Linux: Find All File Descriptors Used By a Process

How can I find all the file descriptors used by a process such as httpd (Apache web server) or mysqld (MySQL Database server)? You can use /proc file system or the lsof command to find all the file descriptors used by a process. /proc File System Example Find out process […]