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).

MySQL Server: Bind To Multiple IP Address

by on December 6, 2012 · 3 comments

I have MySQL database system running on FreeBSD. The server has multiple ip address. The mysqld used by many websites hosted on two other CentOS based servers. I would like to bind MySQL sever running on Unix / Linux server to more than one IP address such as 202.54.1.2, 202.54.1.10, and 202.54.1.15. How can I bind mysqld to multiple ips?

{ 3 comments }

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

by on July 26, 2012 · 9 comments

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?

{ 9 comments }

Add / Import .SQL file To MySQL Database Server

by on July 25, 2012 · 3 comments

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

{ 3 comments }

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

by on July 25, 2012 · 8 comments

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?

{ 8 comments }

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

by on May 7, 2012 · 2 comments

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?

{ 2 comments }

Debian Linux Install MySQL Database Server

by on January 23, 2012 · 3 comments

How do I install mysql database server under Debian Linux operating system running on HP server?

{ 3 comments }

mysqldump: Copy Database Using Shell Pipes

by on June 25, 2011 · 0 comments

How do I use mysqldump command with Unix shell pipes?

{ 0 comments }

← Previous Howtos