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

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?

{ 17 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 }

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?

{ 3 comments }

How do I use mysqldump command with Unix shell pipes?

{ 0 comments }

How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?

{ 4 comments }

Find Out MySQL Version

by on January 21, 2011 · 0 comments

How do I find out mysql version under Linux or Unix operating systems?

{ 0 comments }

I‘m trying to make backups using the mysqldump command and getting the following error or warning:

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

How do I fix this problem?

{ 8 comments }