Tune MySQL
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Connect to the MySQL server Use the following …
The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0. Many changes were made between MySQL 3.x, 4.0.x, …
Overview This function displays a table of the processes that use CPU, memory, and MySQL. The table displays who is using the process, CPU usage …
While gettting transferred from one host to another you need to take many precautions one of them is of your database (MySQL) You should backup …
Solution This error is encountered by both scripts and applications, that are unable to use the new authentication protocol introduced by MySQL 4.1.x. The only …
Solution Make sure root pass is in /root/.my.cnf This is usually the first root pass the box was given once cpanel is installed. If it …
Solution: There is a multitude of administration tools ranging from ssh’ing into the server and directly issuing commands to commercial GUI software. phpMyAdmin is very …
Solution 1. Log into your cPanel ( https://www.yourdomain.com:2082). 2. Click on the “MySQL Databases” link. This will display the “MySQL Account Maintenance” screen. 3. Now …
First apply latest hotfix 2.8 on your machine and follow these steps: Stop all IIS and Hosting Controller Services. Copy mySQLdump.exe from (X:/mySQL installation path/Bin) …