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

I‘m getting the following error in my mysql.log file:

100630 2:03:39 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘./app2_db/aix_data_user_c.MYI'; try to repair it

How do I fix this error and repair my table under UNIX or Linux operating systems?

{ 1 comment }

How do I install Oracle (Sun) MySQL database server v5.x under Ubuntu Linux operating systems? How do I add a new user and database for Apache web server and php access under Ubuntu Linux?

{ 6 comments }

I‘m trying to set ‘thread_concurrency to 8 under Linux MySQL server. But when I try to restart the mysql server, I get the following error:

[ERROR] /usr/local/libexec/mysqld: unknown variable ‘thread_concurrency=8′

How do I fix this problem?

{ 0 comments }

I got new server and installed phpMyAdmin. But whenever I visit the phpmyadmin url it says:

Cannot load mysql extension. Please check your PHP configuration

How do I fix this problem under CentOS / RHEL / Fedora Linux Apache web server?

{ 5 comments }