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?
{ 1 comment }
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).
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?
{ 5 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?
{ 2 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 }
