Selecting data from mysql using qt?

Dii

doforumda: use gedit

sudo gedit /etc/mysql/my.cnf

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

doforumda

this is the socket line in my.cnf

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

Dii

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

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

doforumda

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

Dii

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

doforumda

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:/#
@

lyuts

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.

Dii

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.

Dii

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

Dii

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.

doforumda

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

doforumda

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

Dii

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
?

Dii

gosh... all with sudo please

doforumda

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

@

doforumda

@
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

@

doforumda

@
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

@

lyuts

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

doforumda

@
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

@

doforumda

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
@