Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Selecting data from mysql using qt?

Selecting data from mysql using qt?

Scheduled Pinned Locked Moved General and Desktop
150 Posts 7 Posters 186.2k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    doforumda
    wrote on last edited by
    #110

    i got this output from this command sudo ls -l /opt/lampp/var/mysql/*

    the output is too long so i am posting it in pieces
    @
    root@zafar-laptop:/# ls -l opt/lampp/var/mysql/*
    -rw-rw---- 1 nobody nogroup 10485760 2010-10-10 22:58 opt/lampp/var/mysql/ibdata1
    -rw-rw---- 1 nobody nogroup 5242880 2010-10-11 12:20 opt/lampp/var/mysql/ib_logfile0
    -rw-rw---- 1 nobody nogroup 5242880 2010-10-09 20:01 opt/lampp/var/mysql/ib_logfile1
    srwxrwxrwx 1 nobody nogroup 0 2010-10-11 12:20 opt/lampp/var/mysql/mysql.sock
    -rw-r--r-- 1 nobody root 6 2008-12-02 10:52 opt/lampp/var/mysql/mysql_upgrade_info
    -rw-rw---- 1 nobody root 3658 2010-10-11 12:20 opt/lampp/var/mysql/zafar-laptop.err
    -rw-rw---- 1 nobody nogroup 5 2010-10-11 12:20 opt/lampp/var/mysql/zafar-laptop.pid

    opt/lampp/var/mysql/cdcol:
    total 20
    -rw-rw---- 1 nobody root 8658 2007-03-23 20:54 cds.frm
    -rw-rw---- 1 nobody root 172 2009-07-30 11:58 cds.MYD
    -rw-rw---- 1 nobody root 2048 2009-07-30 12:29 cds.MYI

    opt/lampp/var/mysql/mysql:
    total 5324
    -rw-rw---- 1 nobody root 8820 2008-12-02 10:52 columns_priv.frm
    -rw-rw---- 1 nobody root 23490 2008-12-02 10:52 columns_priv.MYD
    -rw-rw---- 1 nobody root 8192 2008-12-02 10:52 columns_priv.MYI
    -rw-rw---- 1 nobody root 9582 2008-12-02 10:52 db.frm
    -rw-rw---- 1 nobody root 2200 2010-10-11 21:41 db.MYD
    -rw-rw---- 1 nobody root 5120 2010-10-11 21:41 db.MYI
    -rw-rw---- 1 nobody root 10223 2008-12-02 10:52 event.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 event.MYD
    -rw-rw---- 1 nobody root 2048 2008-12-02 10:52 event.MYI
    -rw-rw---- 1 nobody root 8665 2008-12-02 10:52 func.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 func.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 func.MYI
    -rw-rw---- 1 nobody root 35 2008-12-02 12:19 general_log.CSM
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 general_log.CSV
    -rw-rw---- 1 nobody root 8776 2008-12-02 10:52 general_log.frm
    -rw-rw---- 1 nobody root 8700 2008-12-02 10:52 help_category.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_category.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_category.MYI
    -rw-rw---- 1 nobody root 8612 2008-12-02 10:52 help_keyword.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_keyword.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_keyword.MYI
    -rw-rw---- 1 nobody root 8630 2008-12-02 10:52 help_relation.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_relation.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_relation.MYI
    -rw-rw---- 1 nobody root 8770 2008-12-02 10:52 help_topic.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_topic.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_topic.MYI
    -rw-rw---- 1 nobody root 9510 2008-12-02 10:52 host.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 host.MYD
    -rw-rw---- 1 nobody root 2048 2008-12-02 10:52 host.MYI
    -rw-rw---- 1 nobody root 8778 2008-12-02 10:52 ndb_binlog_index.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 ndb_binlog_index.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 ndb_binlog_index.MYI
    -rw-rw---- 1 nobody root 8586 2008-12-02 10:52 plugin.frm
    -rw-rw---- 1 nobody root 1154 2009-04-10 10:16 plugin.MYD
    -rw-rw---- 1 nobody root 2048 2009-04-10 10:16 plugin.MYI
    -rw-rw---- 1 nobody root 9996 2008-12-02 10:52 proc.frm
    -rw-rw---- 1 nobody root 740 2008-12-02 12:14 proc.MYD
    -rw-rw---- 1 nobody root 4096 2008-12-02 12:19 proc.MYI
    -rw-rw---- 1 nobody root 8875 2008-12-02 10:52 procs_priv.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 procs_priv.MYD
    -rw-rw---- 1 nobody root 4096 2008-12-02 10:52 procs_priv.MYI
    -rw-rw---- 1 nobody root 8838 2008-12-02 10:52 servers.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 servers.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 servers.MYI
    -rw-rw---- 1 nobody root 35 2008-12-02 12:19 slow_log.CSM
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 slow_log.CSV
    -rw-rw---- 1 nobody root 8976 2008-12-02 10:52 slow_log.frm
    -rw-rw---- 1 nobody root 8955 2008-12-02 10:52 tables_priv.frm
    -rw-rw---- 1 nobody root 3404 2008-12-02 10:52 tables_priv.MYD
    -rw-rw---- 1 nobody root 8192 2008-12-02 10:52 tables_priv.MYI
    -rw-rw---- 1 nobody root 8636 2007-03-23 20:54 time_zone.frm
    -rw-rw---- 1 nobody root 8624 2008-12-02 10:52 time_zone_leap_second.frm
    -rw-rw---- 1 nobody root 0 2008-12-02 10:52 time_zone_leap_second.MYD
    -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 time_zone_leap_second.MYI
    -rw-rw---- 1 nobody root 11795 2008-12-30 14:16 time_zone.MYD
    -rw-rw---- 1 nobody root 19456 2008-12-30 14:16 time_zone.MYI
    -rw-rw---- 1 nobody root 8606 2008-12-02 10:52 time_zone_name.frm
    -rw-rw---- 1 nobody root 331945 2008-12-30 14:16 time_zone_name.MYD
    -rw-rw---- 1 nobody root 37888 2008-12-30 14:16 time_zone_name.MYI
    -rw-rw---- 1 nobody root 8686 2008-12-30 14:16 time_zone_transition.frm
    -rw-rw---- 1 nobody root 1992570 2008-12-30 14:16 time_zone_transition.MYD
    -rw-rw---- 1 nobody root 2216960 2008-12-30 14:16 time_zone_transition.MYI
    -rw-rw---- 1 nobody root 8748 2008-12-30 14:16 time_zone_transition_type.frm
    -rw-rw---- 1 nobody root 293208 2008-12-30 14:16 time_zone_transition_type.MYD
    -rw-rw---- 1 nobody root 112640 2008-12-30 14:16 time_zone_transition_type.MYI
    -rw-rw---- 1 nobody root 10466 2008-12-02 10:52 user.frm
    -rw-rw---- 1 nobody root 388 2010-10-11 21:41 user.MYD
    -rw-rw---- 1 nobody root 2048 2010-10-11 21:41 user.MYI

    @

    1 Reply Last reply
    0
    • D Offline
      D Offline
      doforumda
      wrote on last edited by
      #111

      @
      opt/lampp/var/mysql/phpmyadmin:
      total 144
      -rw-rw---- 1 nobody root 54 2004-12-06 15:56 db.opt
      -rw-rw---- 1 nobody root 8682 2007-03-23 20:54 pma_bookmark.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_bookmark.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_bookmark.MYI
      -rw-rw---- 1 nobody root 12964 2007-03-23 20:54 pma_column_info.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_column_info.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_column_info.MYI
      -rw-rw---- 1 nobody root 8704 2007-03-11 11:50 pma_designer_coords.frm
      -rw-rw---- 1 nobody root 0 2007-03-11 11:50 pma_designer_coords.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-11 11:50 pma_designer_coords.MYI
      -rw-rw---- 1 nobody root 8730 2007-03-23 20:54 pma_history.frm
      -rw-rw---- 1 nobody root 560 2010-10-11 12:21 pma_history.MYD
      -rw-rw---- 1 nobody root 5120 2010-10-11 12:21 pma_history.MYI
      -rw-rw---- 1 nobody root 8644 2007-03-23 20:54 pma_pdf_pages.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_pdf_pages.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_pdf_pages.MYI
      -rw-rw---- 1 nobody root 8800 2007-03-23 20:54 pma_relation.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_relation.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_relation.MYI
      -rw-rw---- 1 nobody root 8708 2007-03-23 20:54 pma_table_coords.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_table_coords.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_table_coords.MYI
      -rw-rw---- 1 nobody root 8656 2007-03-23 20:54 pma_table_info.frm
      -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_table_info.MYD
      -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_table_info.MYI

      opt/lampp/var/mysql/test:
      total 0

      opt/lampp/var/mysql/testTwo:
      total 24
      -rw-rw---- 1 nobody nogroup 65 2010-10-10 13:13 db.opt
      -rw-rw---- 1 nobody nogroup 8634 2010-10-10 13:14 testTable.frm
      -rw-rw---- 1 nobody nogroup 44 2010-10-10 13:15 testTable.MYD
      -rw-rw---- 1 nobody nogroup 2048 2010-10-10 22:58 testTable.MYI
      root@zafar-laptop:/#
      root@zafar-laptop:/# sudo ls -l opt/lampp/var/mysql/*
      -rw-rw---- 1 nobody nogroup 10485760 2010-10-10 22:58 opt/lampp/var/mysql/ibdata1
      -rw-rw---- 1 nobody nogroup 5242880 2010-10-11 12:20 opt/lampp/var/mysql/ib_logfile0
      -rw-rw---- 1 nobody nogroup 5242880 2010-10-09 20:01 opt/lampp/var/mysql/ib_logfile1
      srwxrwxrwx 1 nobody nogroup 0 2010-10-11 12:20 opt/lampp/var/mysql/mysql.sock
      -rw-r--r-- 1 nobody root 6 2008-12-02 10:52 opt/lampp/var/mysql/mysql_upgrade_info
      -rw-rw---- 1 nobody root 3658 2010-10-11 12:20 opt/lampp/var/mysql/zafar-laptop.err
      -rw-rw---- 1 nobody nogroup 5 2010-10-11 12:20 opt/lampp/var/mysql/zafar-laptop.pid

      @

      1 Reply Last reply
      0
      • D Offline
        D Offline
        doforumda
        wrote on last edited by
        #112

        @
        opt/lampp/var/mysql/cdcol:
        total 20
        -rw-rw---- 1 nobody root 8658 2007-03-23 20:54 cds.frm
        -rw-rw---- 1 nobody root 172 2009-07-30 11:58 cds.MYD
        -rw-rw---- 1 nobody root 2048 2009-07-30 12:29 cds.MYI

        opt/lampp/var/mysql/mysql:
        total 5324
        -rw-rw---- 1 nobody root 8820 2008-12-02 10:52 columns_priv.frm
        -rw-rw---- 1 nobody root 23490 2008-12-02 10:52 columns_priv.MYD
        -rw-rw---- 1 nobody root 8192 2008-12-02 10:52 columns_priv.MYI
        -rw-rw---- 1 nobody root 9582 2008-12-02 10:52 db.frm
        -rw-rw---- 1 nobody root 2200 2010-10-11 21:41 db.MYD
        -rw-rw---- 1 nobody root 5120 2010-10-11 21:41 db.MYI
        -rw-rw---- 1 nobody root 10223 2008-12-02 10:52 event.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 event.MYD
        -rw-rw---- 1 nobody root 2048 2008-12-02 10:52 event.MYI
        -rw-rw---- 1 nobody root 8665 2008-12-02 10:52 func.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 func.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 func.MYI
        -rw-rw---- 1 nobody root 35 2008-12-02 12:19 general_log.CSM
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 general_log.CSV
        -rw-rw---- 1 nobody root 8776 2008-12-02 10:52 general_log.frm
        -rw-rw---- 1 nobody root 8700 2008-12-02 10:52 help_category.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_category.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_category.MYI
        -rw-rw---- 1 nobody root 8612 2008-12-02 10:52 help_keyword.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_keyword.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_keyword.MYI
        -rw-rw---- 1 nobody root 8630 2008-12-02 10:52 help_relation.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_relation.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_relation.MYI
        -rw-rw---- 1 nobody root 8770 2008-12-02 10:52 help_topic.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 help_topic.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 help_topic.MYI
        -rw-rw---- 1 nobody root 9510 2008-12-02 10:52 host.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 host.MYD
        -rw-rw---- 1 nobody root 2048 2008-12-02 10:52 host.MYI
        -rw-rw---- 1 nobody root 8778 2008-12-02 10:52 ndb_binlog_index.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 ndb_binlog_index.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 ndb_binlog_index.MYI
        -rw-rw---- 1 nobody root 8586 2008-12-02 10:52 plugin.frm
        -rw-rw---- 1 nobody root 1154 2009-04-10 10:16 plugin.MYD
        -rw-rw---- 1 nobody root 2048 2009-04-10 10:16 plugin.MYI
        -rw-rw---- 1 nobody root 9996 2008-12-02 10:52 proc.frm
        -rw-rw---- 1 nobody root 740 2008-12-02 12:14 proc.MYD
        -rw-rw---- 1 nobody root 4096 2008-12-02 12:19 proc.MYI
        -rw-rw---- 1 nobody root 8875 2008-12-02 10:52 procs_priv.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 procs_priv.MYD
        -rw-rw---- 1 nobody root 4096 2008-12-02 10:52 procs_priv.MYI
        -rw-rw---- 1 nobody root 8838 2008-12-02 10:52 servers.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 servers.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 servers.MYI
        -rw-rw---- 1 nobody root 35 2008-12-02 12:19 slow_log.CSM
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 slow_log.CSV
        -rw-rw---- 1 nobody root 8976 2008-12-02 10:52 slow_log.frm
        -rw-rw---- 1 nobody root 8955 2008-12-02 10:52 tables_priv.frm
        -rw-rw---- 1 nobody root 3404 2008-12-02 10:52 tables_priv.MYD
        -rw-rw---- 1 nobody root 8192 2008-12-02 10:52 tables_priv.MYI
        -rw-rw---- 1 nobody root 8636 2007-03-23 20:54 time_zone.frm
        -rw-rw---- 1 nobody root 8624 2008-12-02 10:52 time_zone_leap_second.frm
        -rw-rw---- 1 nobody root 0 2008-12-02 10:52 time_zone_leap_second.MYD
        -rw-rw---- 1 nobody root 1024 2008-12-02 10:52 time_zone_leap_second.MYI
        -rw-rw---- 1 nobody root 11795 2008-12-30 14:16 time_zone.MYD
        -rw-rw---- 1 nobody root 19456 2008-12-30 14:16 time_zone.MYI
        -rw-rw---- 1 nobody root 8606 2008-12-02 10:52 time_zone_name.frm
        -rw-rw---- 1 nobody root 331945 2008-12-30 14:16 time_zone_name.MYD
        -rw-rw---- 1 nobody root 37888 2008-12-30 14:16 time_zone_name.MYI
        -rw-rw---- 1 nobody root 8686 2008-12-30 14:16 time_zone_transition.frm
        -rw-rw---- 1 nobody root 1992570 2008-12-30 14:16 time_zone_transition.MYD
        -rw-rw---- 1 nobody root 2216960 2008-12-30 14:16 time_zone_transition.MYI
        -rw-rw---- 1 nobody root 8748 2008-12-30 14:16 time_zone_transition_type.frm
        -rw-rw---- 1 nobody root 293208 2008-12-30 14:16 time_zone_transition_type.MYD
        -rw-rw---- 1 nobody root 112640 2008-12-30 14:16 time_zone_transition_type.MYI
        -rw-rw---- 1 nobody root 10466 2008-12-02 10:52 user.frm
        -rw-rw---- 1 nobody root 388 2010-10-11 21:41 user.MYD
        -rw-rw---- 1 nobody root 2048 2010-10-11 21:41 user.MYI

        @

        1 Reply Last reply
        0
        • L Offline
          L Offline
          lyuts
          wrote on last edited by
          #113

          I bet it is here @/opt/lampp/mysql/my.cnf@

          I'm a rebel in the S.D.G.

          1 Reply Last reply
          0
          • D Offline
            D Offline
            doforumda
            wrote on last edited by
            #114

            @
            opt/lampp/var/mysql/phpmyadmin:
            total 144
            -rw-rw---- 1 nobody root 54 2004-12-06 15:56 db.opt
            -rw-rw---- 1 nobody root 8682 2007-03-23 20:54 pma_bookmark.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_bookmark.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_bookmark.MYI
            -rw-rw---- 1 nobody root 12964 2007-03-23 20:54 pma_column_info.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_column_info.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_column_info.MYI
            -rw-rw---- 1 nobody root 8704 2007-03-11 11:50 pma_designer_coords.frm
            -rw-rw---- 1 nobody root 0 2007-03-11 11:50 pma_designer_coords.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-11 11:50 pma_designer_coords.MYI
            -rw-rw---- 1 nobody root 8730 2007-03-23 20:54 pma_history.frm
            -rw-rw---- 1 nobody root 560 2010-10-11 12:21 pma_history.MYD
            -rw-rw---- 1 nobody root 5120 2010-10-11 12:21 pma_history.MYI
            -rw-rw---- 1 nobody root 8644 2007-03-23 20:54 pma_pdf_pages.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_pdf_pages.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_pdf_pages.MYI
            -rw-rw---- 1 nobody root 8800 2007-03-23 20:54 pma_relation.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_relation.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_relation.MYI
            -rw-rw---- 1 nobody root 8708 2007-03-23 20:54 pma_table_coords.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_table_coords.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_table_coords.MYI
            -rw-rw---- 1 nobody root 8656 2007-03-23 20:54 pma_table_info.frm
            -rw-rw---- 1 nobody root 0 2007-03-23 20:54 pma_table_info.MYD
            -rw-rw---- 1 nobody root 1024 2007-03-23 20:54 pma_table_info.MYI

            opt/lampp/var/mysql/test:
            total 0

            opt/lampp/var/mysql/testTwo:
            total 24
            -rw-rw---- 1 nobody nogroup 65 2010-10-10 13:13 db.opt
            -rw-rw---- 1 nobody nogroup 8634 2010-10-10 13:14 testTable.frm
            -rw-rw---- 1 nobody nogroup 44 2010-10-10 13:15 testTable.MYD
            -rw-rw---- 1 nobody nogroup 2048 2010-10-10 22:58 testTable.MYI

            @

            1 Reply Last reply
            0
            • D Offline
              D Offline
              doforumda
              wrote on last edited by
              #115

              yes the second command returns this

              @
              root@zafar-laptop:/# sudo ls -l /opt/lampp/etc/my.cnf
              -rw-r--r-- 1 root root 5030 2009-04-10 10:11 /opt/lampp/etc/my.cnf
              @

              1 Reply Last reply
              0
              • D Offline
                D Offline
                Dii
                wrote on last edited by
                #116

                ok doforumda, that's enough... I want to make it sure, can you check, the
                sudo ls -l /opt/lampp/etc/my.cnf
                or
                sudo ls -l /opt/lampp/etc/mysql/my.cnf
                ?
                If one of them is there, let's take a look with gedit, for the
                socket = /something
                part?

                1 Reply Last reply
                0
                • D Offline
                  D Offline
                  Dii
                  wrote on last edited by
                  #117

                  ok, then
                  sudo gedit /opt/lamp/etc/my.cnf

                  look for the socket = something line

                  1 Reply Last reply
                  0
                  • L Offline
                    L Offline
                    lyuts
                    wrote on last edited by
                    #118

                    ¤ Dii ¤, maybe this would be easier?

                    @sudo find /opt/lampp -name my.cnf -type f | xargs grep -n socket@

                    I'm a rebel in the S.D.G.

                    1 Reply Last reply
                    0
                    • D Offline
                      D Offline
                      doforumda
                      wrote on last edited by
                      #119

                      Dii: i use this command sudo gedit /opt/lamp/etc/my.cnf but unfortunately the file is empty. there is nothing in it.

                      lyut: your command sudo find /opt/lampp -name my.cnf -type f | xargs grep -n socket

                      displays this
                      @
                      root@zafar-laptop:/# sudo find /opt/lampp -name my.cnf -type f | xargs
                      /opt/lampp/etc/my.cnf
                      @

                      1 Reply Last reply
                      0
                      • D Offline
                        D Offline
                        doforumda
                        wrote on last edited by
                        #120

                        sorry wait

                        1 Reply Last reply
                        0
                        • D Offline
                          D Offline
                          Dii
                          wrote on last edited by
                          #121

                          lyuts: yes it should be easier...

                          doforumda: i misstyped the command, try this:
                          sudo gedit /opt/lampp/etc/my.cnf

                          1 Reply Last reply
                          0
                          • D Offline
                            D Offline
                            doforumda
                            wrote on last edited by
                            #122

                            lyut: your command sudo find /opt/lampp -name my.cnf -type f | xargs grep -n socket actually displays this. above one was wrong because i use the wrong command

                            @
                            root@zafar-laptop:/# sudo find /opt/lampp -name my.cnf -type f | xargs grep -n socket
                            21:socket = /opt/lampp/var/mysql/mysql.sock
                            28:socket = /opt/lampp/var/mysql/mysql.sock
                            44:# All interaction with mysqld must be made via Unix sockets or named pipes.
                            @

                            1 Reply Last reply
                            0
                            • D Offline
                              D Offline
                              doforumda
                              wrote on last edited by
                              #123

                              lyut: sudo gedit /opt/lampp/etc/my.cnf this command does open my.cnf and it also have

                              socket = /opt/lampp/var/mysql/mysql.sock

                              in two lines means there are two entries for socket in my.cnf

                              1 Reply Last reply
                              0
                              • L Offline
                                L Offline
                                lyuts
                                wrote on last edited by
                                #124

                                I think this is rather rough solution, but worth trying:

                                @sudo mkdir -p /var/run/mysqld
                                sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock@

                                I'm a rebel in the S.D.G.

                                1 Reply Last reply
                                0
                                • D Offline
                                  D Offline
                                  doforumda
                                  wrote on last edited by
                                  #125

                                  so what next i think here the path for socket is correct because i have one mysql.sock file in that exactly same directory

                                  1 Reply Last reply
                                  0
                                  • D Offline
                                    D Offline
                                    doforumda
                                    wrote on last edited by
                                    #126

                                    you mean i should create a dir at opt/lampp/var/run/mysqld ????

                                    1 Reply Last reply
                                    0
                                    • D Offline
                                      D Offline
                                      doforumda
                                      wrote on last edited by
                                      #127

                                      millions of thanks to both of you TYUT and Dii. it works. one more question can please tell me what does this command do
                                      @
                                      sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock
                                      @

                                      and also if i want to install everything from scratch then once i have to use this command to make it work?

                                      1 Reply Last reply
                                      0
                                      • D Offline
                                        D Offline
                                        Dii
                                        wrote on last edited by
                                        #128

                                        doforumda: the problem was ~small... the Qt mysql driver looks for the socket file (the connection to mysql) in the default location (var/run/mysqld/mysqld.sock), though you had it somewhere else, because your lampp package changed the path.

                                        The "ln -s" made a symbolic link to that, so the /var/run/mysqld/mysqld.sock point to the /opt/lampp/var/mysql/mysql.sock. This way Qt can find it. If you do a new installation, with lampp, you should do it again, if you use the regular mysql package, probably, you won't face this problem.

                                        lyuts: great work, we deserve these points :)

                                        1 Reply Last reply
                                        0
                                        • L Offline
                                          L Offline
                                          lyuts
                                          wrote on last edited by
                                          #129

                                          I think our solution is rough enough, but at least it works. I think the best solution is to set the socket parameter in my.cnf to /var/run/mysqld/mysqld.sock. But it is up to you doforumda.

                                          bq. millions of thanks to both of you TYUT and Dii.

                                          Hey, I'm lyuts, not TYUT :)

                                          doforumda and ¤ Dii ¤, my congratulations, we did it.

                                          I'm a rebel in the S.D.G.

                                          1 Reply Last reply
                                          0

                                          • Login
                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved