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 a module or extension for PHP applications that use MySQL databases under CentOS / Redhat / RHEL / Fedora Linux?

{ 3 comments }

When I run the following command at mysql> I get an error which read as follows:

mysql> use dbname;
mysql> show tables;
ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

How do I fix this problem under Debian Linux?

{ 7 comments }

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?

{ 0 comments }

Can you tell me where are MySQL error and other log files are located under Linux / UNIX / BSD operating systems?

{ 0 comments }

I forgot the MySQL root password. How do I reset MySQL root password?

{ 17 comments }

Can you tell me the location of for the MySQL error log file under Debian or Ubuntu Linux? How do I view error log file?

{ 2 comments }