MySQL Learning (i) ODBC installation

• Pre-write instructions

The first contact with MySQL, all say MySQL all kinds of good. I also come to study and study. Previously only SQLServer2008 experience, in fact, is only fur. Because SQL Server is still relatively easy to get started with. It's no trouble. But the things that are deep inside are not touching. It's the point here!

• Connection-driven installation of MySQL.

You need to connect to the R database when learning the R language. However, you need to install ODBC connection drivers.

Lookup discovery was not previously installed.

MySQL connection drivers are not found in the. Need to be installed.

After the installation of the

Choose the format for Unicode encoding

Select Test to find the following error:

Access denied for user ' root ' @ ' localhost ' (using Password:yes)

At first I was also because it is a password problem, and later on the Internet check to know the root authority problem, I think it may be because the Win7 system I do not use as an administrator in the installation, so root role does not have permissions, from the Internet to find a solution to solve, here to record:

1. Administrator login system, stop the MySQL service or end the MYSQLD-NT process;
2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:\mysql\, CMD enters the command line;
3. Run D:\Program files\mysql\mysql Server 5.6\bin\mysqld--skip-grant-tables start MySQL, turn off check of permissions;
4. Run D:\Program files\mysql\mysql Server 5.6\bin\mysqladmin-u root flush-privileges password "newpassword" to reset the root password;
5. Restart the MySQL service;

MySQL Learning (i) ODBC installation