≡ Menu

MySQL DBA Tutorials & HowTos

MySQL tutorials and howtos for database admins, sysadmins, DBAs, webmasters, and Unix/Linux users who wish to improve their database skills such as backup, security, optimization, management and much more (rss feed).

HowTo SSH Restart Mysql Server on a Linux and Unix Command Line

I'm using a CentOS, RHEL, Fedora Linux server. I want to restart my mysqld server after making some changes to my.cnf file. How do I restart mysql server from a command line on a Linux or Unix-like systems?
[click to continue…]

MySQL/MariaDB Server: Bind To Multiple IP Address

I have MySQL/MariaDB database system running on a FreeBSD/Linux server. The server has multiple ip address. The mysqld used by many websites hosted on two other CentOS Linux based servers. I would like to bind MySQL sever running on a Linux or Unix-like server to more than one IP address such as,, and How can I bind mysqld to multiple ips?
[click to continue…]

CentOS Linux 5/6: Install MySQL Client Only

I have MySQL database server running on Sun Solaris Unix based server. I am using CentOS and I would like to install mysql client only? How do I install mysql client only but skil the entire mysql database installation on CentOS Linux? Is there a way to only install the mysql client on CentOS Linux based Lenovo thinkpad T series?
[click to continue…]

CentOS Linux 5/6 Install Mysql Database Server

How do I install MySQL database server on CentOS Linux version 5 or version 6 using command line options? How do I configuring MySQL server on CentOS Linux?
[click to continue…]

I'm getting the following error when I run mysql -u root -p

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

How do I solve this problem under CentOS / RHEL / Red Hat Enterprise Linux server 5.x or 6.x?
[click to continue…]

Add / Import .SQL file To MySQL Database Server

How do I import a MySQL .SQL text file to MySQL database sever using command line or gui tools?
[click to continue…]

CentOS / RHEL: Install and Configure phpMyAdmin Administration Of MySQL Database Server

How do I install phpMyAdmin to handle the administration of MySQL database server over the World Wide Web under Fedora / Scientific / CentOS / RHEL / Red Hat Enterprise Linux 6.x server systems? How do I install and securely configure phpMyAdmin on a CentOS 6.x / RHEL 6.x server?
[click to continue…]

WordPress: Change Author ID / Attribution On All Posts In a Single Pass

I can access my MySQL database using the command line option provided by vps provider. How do I change author ID or attribution on all wordpress blog posts in a single pass?
[click to continue…]

Debian Linux Install MySQL Database Server

How do I install mysql database server on Debian Linux operating system running on an HP server? How do I install MySQL on Debian or Ubuntu server?
[click to continue…]

mysqldump: Copy Database Using Shell Pipes

How do I use mysqldump command with Unix shell pipes?
[click to continue…]