MySql C++调用库Connector/c++编译 和 接口封装【一】mysql数据库安装

时间:2021-06-05 06:26:53
Connector/c++库的源文件编译,你需要先准备好以下工具:
    mysql数据库(编译时要依赖),boost库,cmake(生成sln工程文件),connector/c++的源文件,visual stdio 2003版本以上。例子使用vs2010。
 
一、mysql数据库安装:
1.先安装windows下,建议去官服下载 install 版本。 zip版其实和 install一样的。但zip版要大多了。
下载链接:http://dev.mysql.com/downloads/windows/installer/  下面有个 Select Platform: 的选项,不过要*才能选。
 
2.把mysql安装目录下的 bin目录,加入环境变量。
  1.mysql目录下的 my-default.ini  为参考,修改 my.ini文件。下面的是参考:
  
[client]
password =
port =
socket = /tmp/mysql.sock [mysqld]
basedir=C:/Program Files/MySQL/MySQL Server 5.6
datadir=C:/Program Files/MySQL/MySQL Server 5.6/data
log-error=C:/Program Files/MySQL/MySQL Server 5.6/log/mysql.log
port =
socket = /tmp/mysql.sock
  2. 控制台(cmd)输入:
mysqld --install MySQL --defaults-file="C:\Program Files\MySQL\MySQL Server 5.6\my.ini"
  3. 启动服务: 
net start MySQL   //net start MySQL 可能会提示 1067错误,就是配置错误。有时会出现,有时没有。按网上的建议,没弄没白规律

   net start MySql 只需要第一次启动执行。以后开机后,会自动启动服务。可以去

  ps:关闭并删除服务命令:

net stop MySQL
sc delete MySQL

附官服的启动说明:

User Comments

Posted by Paolo Lancelli on October 24 2007 2:56pm [Delete] [Edit]

In case you receive "The system cannot find the file specified", remember that you have to install the service with the absolute path, in my case "C:\mysql\bin\mysqld --install". I added the \bin to the windows path, and I was installing the service only with "mysqld --install".

Posted by Junaid Nazir on December 29 2007 9:14pm [Delete] [Edit]

As mentioned earlier by another user, I fell into the trap of adding MySQL to start as a service via a command like

C:\> mysqld --install

The service is reported as being installed successfully, however, under the Services panel it shows the executable path as 'C:\mysqld' when in fact it is located under 'C:\mysql\bin'. I was working under the assumption that the mysql\bin directory had been added to the system PATH variable, but really you need to use absolute file paths when installing services. In my case, I used;

C:\> C:\mysql\bin\mysqld --install MySQL --defaults-file=C:\mysql\my.ini

This starts the service automatically with Windows bootup, and will load the my.ini configuration file which you have to place within the mysql directory. For the first time however, you will need to start the mysql service manually, since the earlier command makes mysql start and end with windows shutdowns and restarts.

net start mysql

Posted by bob eff on June 8 2008 4:16am [Delete] [Edit]

If you have problems installing the service on Windows Vista, just run the normal install and add the service manually with the following command:

use the sc create command in a dos window to add the service:

sc create MySQL start= auto DisplayName= MySQL binPath= c:\program files\mysql\mysql server 5.1\bin\mysqld.exe

then if you need to alter any parameters, use the administrative tools/services utility

Posted by Baruch Atta on January 14 2010 5:49pm [Delete] [Edit]

Another "got-ya"... Make sure your my.ini file is in your MySQL directory, and the variables are pointing to the correct directories.

Posted by Rich Wingerter on July 5 2011 3:09am [Delete] [Edit]

In order to overcome the "The system cannot find the file specified" message, I had to use the short 8dot3 names because my command program would not take the long names in quotes. Since I have mysql installed under EasyPHP on the D: drive, I had to use:

D:\progra~2\easyph~1.0\mysql\bin\mysqld --install

to get to mysqld in

D:\Program Files (x86)\EasyPHP-5.3.6.0\mysql\bin

You can get the short names with the directory command:

DIR /X