4. Selecting data from mysql using qt?

Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

Selecting data from mysql using qt?


  • db.lasterror().text() should come after line 16 (db.open()).
    The password in the Qt code must be the same what you have specified in the GRANT command above.

    I suspect probably, you haven't made the database and the table in mysql yet, if you go back to mysql command line, what do you get by these commands:

    @SHOW databases;

    USE testTwo;

    SHOW tables;@

    I go to dinner, be back in a few minutes :)

    0

  • You put my debug before opening the connection. Put it after.

    0

  • i changed db.lastError().text(); and place it after db.open()
    this is the output
    @
    Starting /home/zafar/c++/dbExample-build-desktop/dbExample...
    "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
    false
    QSqlQuery::exec: database not open
    /home/zafar/c++/dbExample-build-desktop/dbExample exited with code 0
    @

    the commands in mysql displayed are here
    repectively to your commands

    @
    mysql> show databases;
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | cdcol |
    | mysql |
    | phpmyadmin |
    | test |
    | testTwo |
    +--------------------+
    6 rows in set (0.01 sec)

    mysql> use testTwo
    Database changed
    mysql> show tables
    -> ;
    +-------------------+
    | Tables_in_testTwo |
    +-------------------+
    | testTable |
    +-------------------+
    1 row in set (0.01 sec)

    @

    0

  • any clues?

    0

  • Change the 19th line to

    @QSqlQuery query(db);@

    0

  • same error again

    0

  • Take a look into mysql logs to see what happens when you are trying to connect from your application.

    0

  • how can i check that mysql logs and from where?

    0

  • [quote author="doforumda" date="1286880547"]how can i check that mysql logs and from where? [/quote]

    Try to find them:
    @find /opt/lampp -name log -type d@

    When you find the log directory, find a log for mysql and use tail utility:

    @tail -f /path/to/mysql.log@

    0

  • this command didnt return something
    @
    root@zafar-laptop:/# find /opt/lampp -name log -type d
    root@zafar-laptop:/#
    @

    0

  • i have a folder inside lampp with the name logs. is it the one which your are talking about

    0

  • Solution 1:
    @find /opt/lampp -name '*.log'@
    This might need sudo'ing.

    Solution 2:
    If 1st fails then you need to find the config files for mysql (it should be located in /opt/lampp directory) and try to find out what is the location of mysql's log files.

    0

  • there are 6 files in there but no mysql.log

    these are the files
    access_log, cgisock.1693, error_log, httpd.pid, php_error_log, ssl_request_log

    0

  • Don't bother with the log files, I guess Qt looks at the wrong place for the socket file...

    Let's check this line in your mysql config file (my.cnf):

    socket = /var/run/mysqld/mysqld.sock

    You should find my.cnf in /etc/ or /etc/mysql/ ... I don't know ubuntu that much.

    0

  • 1st solution returns this
    @
    root@zafar-laptop:/# find /opt/lampp -name *.log
    /opt/lampp/htdocs/xampp/contrib/sqlnet.log
    @

    0

  • with which editor i can view that .conf file. with gedit or something.

    0

  • [quote author="¤ Dii ¤" date="1286881470"]
    You should find my.cnf in /etc/ or /etc/mysql/ ... I don't know ubuntu that much.[/quote]

    I don't think that this config will be in /etc. He uses lampp - a preconfigured bundle. That config might be in /opt/lampp.

    0

  • BTW a quick sum:

    • mysql is installed
    • database and tables are created
    • access is granted
    • qt code looks fine

    I see two possibilities here: libmysqlclient is missing, or the socket file is at different place.

    0

  • the file my.cnf is in etc/mysql folder

    0

  • doforumda: use gedit

    sudo gedit /etc/mysql/my.cnf

    at least most of the ubuntu machines have the config file there.

    0

  • this is the socket line in my.cnf

    @
    socket = /var/run/mysqld/mysqld.sock
    @

    0

  • ok then the wrong socket guess was wrong... but let's make it sure:

    sudo ls -l /var/run/mysqld/*

    0

  • after running this sudo ls -l /var/run/mysqld/* there is nothing inside run directory

    0

  • uhmmmmmmm that's more than strange, the socket file should be there somewhere, let's find it:

    find /var -name mysqld.sock

    if no result:

    find /opt -name mysqld.sock

    0

  • both of them didnt return any resutl

    @
    root@zafar-laptop:/# find /var -name mysqld.sock
    root@zafar-laptop:/# find /opt -name mysqld.sock
    root@zafar-laptop:/#
    @

    0

  • I have bitnami lampp stack installed and when I start it then the socket file is created in /opt/lamppstack/mysql/tmp/mysql.sock. I think doforumda shoudl have similar directory and we need to check the permissions for that directory.

    0

  • Usually that means, that the mysql daemon is not running... but the the command line should not work as well... ;(

    It doesn't hurt to try to start the daemon:

    sudo /etc/init.d/mysql start

    ... and do the search for the socket file as above.

    0

  • gosh, do the find with sudo:

    sudo find /opt -name mysqld.sock
    sudo find /var -name mysqld.sock

    damn, I always forget that with ubuntu

    0

  • lyuts: yes, if he have the socket file at the same place, we need to symlink it to the /var/... location and happy end :) I hope so.

    0

  • tyut: yes i have one file with the name of mysql.sock in /opt/lampp/var/mysql/mysql.sock

    0

  • the permissions on mysql.sock it read write exe for all types of users

    0

  • Great, don't give up, we are close :D

    ls -l /opt/lampp/var/mysql/*

    maybe you have another mysql config file somewhere:

    ls -l /opt/lampp/etc/my.cnf
    or
    ls -l /opt/lampp/etc/mysql/my.cnf
    ?

    0

  • gosh... all with sudo please

    0

  • 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

    @

    0

  • @
    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

    @

    0

  • @
    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

    @

    0

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

    0

  • @
    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

    @

    0

  • 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
    @

    0

  • 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?

    0
Log in to reply