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).
y MySQL database installation has been corrupted. I would like to delete old mysql server. How do I reinstall MySQL database server version 5.x on Linux or Unix-like oses? A software upgrade broke my system. How can I uninstall and re-install mysql again to get fresh full mysql again?
have over 1800+ pending comments and most of them are spams in WordPress based blog. How do I delete all (mass delete) the pending comments using sql statements?
‘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?
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 220.127.116.11, 18.104.22.168, and 22.214.171.124. How can I bind mysqld to multiple ips?
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?
ow 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?
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?