It is somewhat a frustration that even the official website at the time of writing this doesn’t correctly list out the dependency software.
Anyway in short, make sure you have installed Visual C++ Redistributable Packages for Visual Studio 2013 if you are installing MySQL ODBC Connector 5.3.6.
The official website and many other website I found only mentioned to install Microsoft Visual C++ 2010 Redistributable Package. Some websites even gave an inappropriate installation instruction to user. Although Microsoft Visual C++ 2010 Redistributable Package might be required for older version of ODBC connector, but definitely not version 5.3.6.
Also, it is better if you are installing the latest version of Visual C++ as well. Many website I found (such as this, this, this and this) are still providing link to the old version of Visual C++ even a new version is already available at the time of their writing. You may check the latest version of Visual C++ at Microsoft website here but, even the official website cannot be trusted as I can find a more updated version of Visual C++ 2015 here at the time of writing this article…
In summary, trust yourself.
If you encounter Slave_IO_Running: No but Slave_SQL_Running: Yes in MySQL replication setup, here may have something that can help.
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
1 row in set (0.00 sec)
This basically means that the slave server is working, but for some reason the master does not send anything to the slave. To troubleshoot this problem, go to the master server instead and check the error log. In my case, this is what I found.
[root@master mysql]# tail master.err
120220 10:11:45 Failed to open log (file './master-bin.000050', errno 13)
In my case, the file master-bin.000050 is actually there, but the owner is root which therefore cannot be opened by the account mysql. Most likely it is because someone started MySQL using the root account after a server down and later on someone restarted the MySQL again under the mysql account. Anyway changed the owner of the file and problem fixed.
First of all, this is the case I encountered and may not be useful on your case.
To reset the data in MySQL database, for the sake of fixing out-sync database replication.
- Stopped MySQL service
- Renamed the original data folder for backup purpose
- Create a new data folder with the same original name
- Execute database installation mysql_install_db
- Import the dumped data
- Set up replication
When executing database installation, the error message below appeared.
Installation of system tables failed!
The following command print nothing to the console.
After checking the log at /var/log/message, it is found that the SELinux prevented the installation.
Fix the security context issue used by SELinux
Sorry I am not going to provide the way here because I having really tried that myself.
Permanent set SELinux to Permissive or Disable (Security Risk)
Obviously this is not a good way to fix the problem but if you still want to do that, here is the way.
Edit the file:
Set to permissive
This is what you can see:
[root@my-server ~]# mysqld -V
mysqld Ver 4.1.22-standard-log for pc-linux-gnu on i686 (MySQL Community Edition - Standard (GPL))
Extra: Temperately disable SELinux
Here is the way:
echo 0 > /selinux/enforce
HOWTO: Turning off or disabling SELinux