1. linux下安装及配置

1.1 编译connector-c

  1. $ tar zxvf mysql-connector-c-6.1.9-src.tar.gz
  2. $ cd mysql-connector-c-6.1.9-src
  3. $ mkdir build
  4. $ cd build
  5. $ cmake ..
  6. $ make

1.2 安装connector-c

  1. $ make install
  3. Install the project...
  4. -- Install configuration: "RelWithDebInfo"
  5. -- Installing: /usr/local/mysql/./COPYING
  6. -- Installing: /usr/local/mysql/./README
  7. -- Installing: /usr/local/mysql/docs/INFO_SRC
  8. -- Installing: /usr/local/mysql/docs/INFO_BIN
  9. -- Installing: /usr/local/mysql/docs/ChangeLog
  10. -- Installing: /usr/local/mysql/include/mysql.h
  11. -- Installing: /usr/local/mysql/include/mysql_com.h
  12. -- Installing: /usr/local/mysql/include/my_command.h
  13. -- Installing: /usr/local/mysql/include/mysql_time.h
  14. -- Installing: /usr/local/mysql/include/my_list.h
  15. -- Installing: /usr/local/mysql/include/my_alloc.h
  16. -- Installing: /usr/local/mysql/include/typelib.h
  17. -- Installing: /usr/local/mysql/include/binary_log_types.h
  18. -- Installing: /usr/local/mysql/include/my_dbug.h
  19. -- Installing: /usr/local/mysql/include/m_string.h
  20. -- Installing: /usr/local/mysql/include/my_sys.h
  21. -- Installing: /usr/local/mysql/include/my_xml.h
  22. -- Installing: /usr/local/mysql/include/mysql_embed.h
  23. -- Installing: /usr/local/mysql/include/my_thread.h
  24. -- Installing: /usr/local/mysql/include/my_thread_local.h
  25. -- Installing: /usr/local/mysql/include/decimal.h
  26. -- Installing: /usr/local/mysql/include/errmsg.h
  27. -- Installing: /usr/local/mysql/include/my_global.h
  28. -- Installing: /usr/local/mysql/include/my_getopt.h
  29. -- Installing: /usr/local/mysql/include/sslopt-longopts.h
  30. -- Installing: /usr/local/mysql/include/my_dir.h
  31. -- Installing: /usr/local/mysql/include/sslopt-vars.h
  32. -- Installing: /usr/local/mysql/include/sslopt-case.h
  33. -- Installing: /usr/local/mysql/include/sql_common.h
  34. -- Installing: /usr/local/mysql/include/keycache.h
  35. -- Installing: /usr/local/mysql/include/m_ctype.h
  36. -- Installing: /usr/local/mysql/include/my_compiler.h
  37. -- Installing: /usr/local/mysql/include/mysql_com_server.h
  38. -- Installing: /usr/local/mysql/include/my_byteorder.h
  39. -- Installing: /usr/local/mysql/include/byte_order_generic.h
  40. -- Installing: /usr/local/mysql/include/byte_order_generic_x86.h
  41. -- Installing: /usr/local/mysql/include/little_endian.h
  42. -- Installing: /usr/local/mysql/include/big_endian.h
  43. -- Installing: /usr/local/mysql/include/thr_cond.h
  44. -- Installing: /usr/local/mysql/include/thr_mutex.h
  45. -- Installing: /usr/local/mysql/include/thr_rwlock.h
  46. -- Installing: /usr/local/mysql/include/mysql_version.h
  47. -- Installing: /usr/local/mysql/include/my_config.h
  48. -- Installing: /usr/local/mysql/include/mysqld_ername.h
  49. -- Installing: /usr/local/mysql/include/mysqld_error.h
  50. -- Installing: /usr/local/mysql/include/sql_state.h
  51. -- Installing: /usr/local/mysql/include/mysql
  52. -- Installing: /usr/local/mysql/include/mysql/service_mysql_alloc.h
  53. -- Installing: /usr/local/mysql/include/mysql/service_my_snprintf.h
  54. -- Installing: /usr/local/mysql/include/mysql/psi
  55. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_mdl.h
  56. -- Installing: /usr/local/mysql/include/mysql/psi/psi_memory.h
  57. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_table.h
  58. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_memory.h
  59. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_idle.h
  60. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_sp.h
  61. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_statement.h
  62. -- Installing: /usr/local/mysql/include/mysql/psi/psi_base.h
  63. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_file.h
  64. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_thread.h
  65. -- Installing: /usr/local/mysql/include/mysql/psi/psi.h
  66. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_ps.h
  67. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_stage.h
  68. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_transaction.h
  69. -- Installing: /usr/local/mysql/include/mysql/psi/mysql_socket.h
  70. -- Installing: /usr/local/mysql/include/mysql/plugin_trace.h
  71. -- Installing: /usr/local/mysql/include/mysql/plugin_auth_common.h
  72. -- Installing: /usr/local/mysql/include/mysql/client_plugin.h
  73. -- Installing: /usr/local/mysql/include/mysql/client_authentication.h
  74. -- Installing: /usr/local/mysql/include/mysql/mysql_lex_string.h
  75. -- Installing: /usr/local/mysql/include/mysql/get_password.h
  76. -- Installing: /usr/local/mysql/include/mysql/client_plugin.h.pp
  77. -- Installing: /usr/local/mysql/lib/libmysqlclient.a
  78. -- Installing: /usr/local/mysql/lib/libmysqlclient.so.18.4.
  79. -- Installing: /usr/local/mysql/lib/libmysqlclient.so.18
  80. -- Installing: /usr/local/mysql/lib/libmysqlclient.so
  81. -- Installing: /usr/local/mysql/bin/my_print_defaults
  82. -- Installing: /usr/local/mysql/bin/perror
  83. -- Installing: /usr/local/mysql/bin/mysql_config

1.3 安装mysql

  1. (1)解压tar包
  2. $ tar zxvf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz
  4. (2)添加用户与组
  5. $ groupadd mysql
  6. $ useradd -r -g mysql mysql
  7. $ cd mysql-5.5.62-linux-glibc2.12-x86_64
  8. $ chown -R mysql:mysql ./
  10. (3)安装数据库
  11. $ cd mysql-5.5.62-linux-glibc2.12-x86_64
  12. $ ./scripts/mysql_install_db --user=mysql
  14. (4)配置文件
  15. $ cd support-files
  16. $ cp my-large.cnf /etc/my.cnf
  17. $ cp mysql.server /etc/init.d/mysql
  18. $ vim /etc/init.d/mysql
  19. 修改文件中的两个变更值
  20. basedir=/root/zhn/software/mysql-5.5.62-linux-glibc2.12-x86_64
  21. datadir=/root/zhn/software/mysql-5.5.62-linux-glibc2.12-x86_64/data
  23. (5)配置环境变量
  24. vim /etc/profile
  25. export MYSQL_HOME=/root/zhn/software/mysql-5.5.62-linux-glibc2.12-x86_64
  26. export PATH=$PATH:$MYSQL_HOME/bin
  27. source /etc/profile
  29. (6)添加自启动服务
  30. chkconfig --add mysql
  31. chkconfig mysql on
  33. (7)启动mysql
  34. $ service mysql start
  36. (8)登录mysql及改密码与配置远程访问
  37. 修改root用户密码(密码暂时是mdsoss)
  38. $ mysqladmin -u root password 'mdsoss'
  39. 登录mysql,需要输入密码
  40. $ mysql -u root -p
  41. 允许root用户远程访问
  42. $ mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mdsoss' WITH GRANT OPTION;
  43. 刷新权限
  44. $ mysql> FLUSH PRIVILEGES;
  46. (9)关闭，查看mysql
  47. $ service mysql stop
  48. $ service mysql status

1.4 c++连接测试

  • 通过命令创建database及table(sql语句结尾带分号)

    1. $ mysql -u root -p
    2. Enter password: mdsoss
    3. $ mysql> create database test_db;
    4. 切换到test_db数据库中
    5. $ mysql> use test_db;
    6. 创建一个叫test的表
    7. $ mysql> create table test(name varchar(255),num int(10));
    8. 显示刚才创建的表信息
    9. $ mysql> show create table test;
    10. $ mysql> select * from test;

  • 测试代码 ```

    include

    include

int main(int argc,char *argv[]) { MYSQL conn; int res; mysql_init(&conn); if(mysql_real_connect(&conn,”localhost”,”root”,”mdsoss”,”test_db”,0,NULL,CLIENT_FOUND_ROWS)) //“root”:数据库管理员 “mdsoss”:root密码 “test_db”:数据库的名字 { printf(“connect success!\n”); res=mysql_query(&conn,”insert into test values(‘user’,’123456’)”); if(res) { printf(“error\n”); } else { printf(“OK\n”); } mysql_close(&conn); } return 0; }

  2. - 编译：g++ mysql.cpp `mysql_config --cflags --libs` -o test
  3. - 执行：./test
  4. - 通过命令查询table

$ mysql> select * from test; +———+————+ | name | num | +———+————+ | user | 123456 | +———+————+

  1. <a name="r2ztV"></a>
  2. ## 1.5 navicat跳转配置

Securt-CRT配置 比如mysql在192.168.1.38上 (1)右键配置，选择Properties (2)选择Connection->Port Forwarding->Add… (3)Name：mysql Local：Port->7979 Remote：Hostname->192.168.1.38 Port->3306

Navicat配置 (1)主机：127.0.0.1 端口：7979 用户名：root 密码：mdsoss note：用户名/密码是msyql的密码 ```

2. 参考文献