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

CentOS / RHEL: Install MySQL PHP Extension

How do I install a module or extension for PHP applications that use MySQL databases under CentOS / Redhat / RHEL / Fedora Linux?
[click to continue…]

ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

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?
[click to continue…]

MySQL: Set Cache Size

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?
[click to continue…]

MySQL: Log Files in Linux / UNIX / BSD

Can you tell me where are MySQL error and other log files are located under Linux / UNIX / BSD operating systems?
[click to continue…]

MySQL Reset Root Password

I forgot the MySQL root password. How do I reset MySQL root password?
[click to continue…]

Debian / Ubuntu MySQL Error Log File Location

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?
[click to continue…]

Lost MySQL Admin Password

I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?
[click to continue…]

Where Are MySQL Files Stored in UNIX / Linux

Where are my mysql database and table files are stored in UNIX or Linux operating systems?
[click to continue…]

How to: MySQL Delete Column

How do I delete a column from an existing MySQL table using UNIX / Windows / Linux mysql command line utility sql syntax?
[click to continue…]

MySQL: Find Out Which Table is Consuming Resources

Q. How do I find out which table is consuming resources under MySQL Database server from UNIX shell prompt?
[click to continue…]