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?
Forum Update on Monday, May 27th 2025

Selecting data from mysql using qt?

Scheduled Pinned Locked Moved General and Desktop
150 Posts 7 Posters 141.9k Views
  • 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 12 Oct 2010, 05:49 last edited by
    #26

    i now put password for root at localhost.
    when i place qDebug() << ok then it displays this
    @
    false
    QSqlQuery::exec: database not open
    @

    false might be the value of ok.

    1 Reply Last reply
    0
    • L Offline
      L Offline
      lyuts
      wrote on 12 Oct 2010, 08:16 last edited by
      #27

      Are you able to connect to your DB from shell?

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

      1 Reply Last reply
      0
      • D Offline
        D Offline
        doforumda
        wrote on 12 Oct 2010, 08:21 last edited by
        #28

        i dont know how to connect to my DB from shell. I install xampp which is easy for me to manage my databases.
        how can i connect from shell?

        1 Reply Last reply
        0
        • L Offline
          L Offline
          lyuts
          wrote on 12 Oct 2010, 08:25 last edited by
          #29

          @mysql -h host -D dbname -u user@

          I guess your can omit host parameter if you are connecting to localhost. You might need to specify "-p password" switch also (depends on mysql configuration).

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

          1 Reply Last reply
          0
          • D Offline
            D Offline
            doforumda
            wrote on 12 Oct 2010, 08:30 last edited by
            #30

            i think i did not install any mysql client. bcause it displays this output
            @
            root@zafar-laptop:/# mysql -h localhost -D testTwo -u root -p xxxxxx
            The program 'mysql' can be found in the following packages:

            • mysql-client-core-5.1
            • mysql-client-5.0
            • mysql-cluster-client-5.1
              Try: apt-get install <selected package>
              @
            1 Reply Last reply
            0
            • L Offline
              L Offline
              lyuts
              wrote on 12 Oct 2010, 08:31 last edited by
              #31

              Run
              @dpkg --list | grep mysql@
              and post the output for this command.

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

              1 Reply Last reply
              0
              • D Offline
                D Offline
                doforumda
                wrote on 12 Oct 2010, 08:35 last edited by
                #32

                here it is
                @
                root@zafar-laptop:/# dpkg --list | grep mysql
                ii libmysqlclient-dev 5.1.41-3ubuntu12.6 MySQL database development files
                ii libmysqlclient16 5.1.41-3ubuntu12.6 MySQL database client library
                ii mysql-common 5.1.41-3ubuntu12.6 MySQL database common files (e.g. /etc/mysql

                @

                1 Reply Last reply
                0
                • L Offline
                  L Offline
                  lyuts
                  wrote on 12 Oct 2010, 08:37 last edited by
                  #33

                  How did you create your database? I don't see any mysql server either.

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

                  1 Reply Last reply
                  0
                  • D Offline
                    D Offline
                    doforumda
                    wrote on 12 Oct 2010, 08:40 last edited by
                    #34

                    well i download xampp and install it. i created database using phpmyadmin.

                    1 Reply Last reply
                    0
                    • D Offline
                      D Offline
                      doforumda
                      wrote on 12 Oct 2010, 08:42 last edited by
                      #35

                      i install xampp in this folder /opt/lampp

                      and my database is in /opt/lampp/var/mysql

                      1 Reply Last reply
                      0
                      • L Offline
                        L Offline
                        lyuts
                        wrote on 12 Oct 2010, 08:44 last edited by
                        #36

                        Ok, I see. What is the location of your XAMPP installation? try to find the mysql binary there. And use the whole path (since I assume it is not in PATH) when connecting, i.e.

                        @/path/to/xampp/bin/mysql -D dbname -u username@

                        UPD: Didn't notice the location of xampp. then try (I guess it would be like this) @/opt/lampp/bin/mysql@

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

                        1 Reply Last reply
                        0
                        • D Offline
                          D Offline
                          doforumda
                          wrote on 12 Oct 2010, 09:00 last edited by
                          #37

                          now here it what it says
                          @
                          root@zafar-laptop:/# /opt/lampp/bin/mysql -D testTwo -h localhost -u root -p 123456
                          Enter password:
                          ERROR 1049 (42000): Unknown database '123456'
                          @
                          i am providing the right pw

                          1 Reply Last reply
                          0
                          • L Offline
                            L Offline
                            lyuts
                            wrote on 12 Oct 2010, 09:01 last edited by
                            #38

                            Try not passing -p switch. I guess you will be prompted to type in your password.
                            or
                            @/opt/lampp/bin/mysql -u root testTwo@

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

                            1 Reply Last reply
                            0
                            • D Offline
                              D Offline
                              doforumda
                              wrote on 12 Oct 2010, 09:08 last edited by
                              #39

                              now it output is Access Denied
                              @
                              root@zafar-laptop:/# /opt/lampp/bin/mysql -u root testTwo
                              ERROR 1045 (28000): Access denied for user 'root'at'localhost' (using password: NO)
                              @

                              1 Reply Last reply
                              0
                              • L Offline
                                L Offline
                                lyuts
                                wrote on 12 Oct 2010, 09:12 last edited by
                                #40

                                I'm sorry i just confused you with my last post.

                                @/opt/lampp/bin/mysql -u root -p 123456 testTwo@

                                I thought that mysql would prompt you but it didn't.

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

                                1 Reply Last reply
                                0
                                • D Offline
                                  D Offline
                                  Dii
                                  wrote on 12 Oct 2010, 09:16 last edited by
                                  #41

                                  Do it this way, then it will prompt for a password:

                                  @/opt/lampp/bin/mysql -D testTwo -h localhost -u root -p
                                  @

                                  1 Reply Last reply
                                  0
                                  • D Offline
                                    D Offline
                                    doforumda
                                    wrote on 12 Oct 2010, 09:16 last edited by
                                    #42

                                    i got a big ouput here but i have not seen any errors in this. when i try to post whole output this forum didnt allow me to post more than 6000 characters

                                    1 Reply Last reply
                                    0
                                    • L Offline
                                      L Offline
                                      lyuts
                                      wrote on 12 Oct 2010, 09:18 last edited by
                                      #43

                                      Cut it into pieces or use something like pastebin.

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

                                      1 Reply Last reply
                                      0
                                      • D Offline
                                        D Offline
                                        doforumda
                                        wrote on 12 Oct 2010, 09:21 last edited by
                                        #44

                                        ok here it is
                                        @
                                        root@zafar-laptop:/# /opt/lampp/bin/mysql -u root -p 123456 testTwo
                                        /opt/lampp/bin/mysql Ver 14.14 Distrib 5.1.41, for pc-linux-gnu (i686) using EditLine wrapper
                                        Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
                                        This software comes with ABSOLUTELY NO WARRANTY. This is free software,
                                        and you are welcome to modify and redistribute it under the GPL license
                                        Usage: /opt/lampp/bin/mysql [OPTIONS] [database]
                                        -?, --help Display this help and exit.
                                        -I, --help Synonym for -?
                                        --auto-rehash Enable automatic rehashing. One doesn't need to use
                                        'rehash' to get table and field completion, but startup
                                        and reconnecting may take a longer time. Disable with
                                        --disable-auto-rehash.
                                        -A, --no-auto-rehash
                                        No automatic rehashing. One has to use 'rehash' to get
                                        table and field completion. This gives a quicker start of
                                        mysql and disables rehashing on reconnect. WARNING:
                                        options deprecated; use --disable-auto-rehash instead.
                                        -B, --batch Don't use history file. Disable interactive behavior.
                                        (Enables --silent)
                                        --character-sets-dir=name
                                        Directory where character sets are.
                                        --column-type-info Display column type information.
                                        -c, --comments Preserve comments. Send comments to the server. The
                                        default is --skip-comments (discard comments), enable
                                        with --comments
                                        -C, --compress Use compression in server/client protocol.
                                        -#, --debug[=#] This is a non-debug version. Catch this and exit
                                        --debug-check Check memory and open file usage at exit.
                                        -T, --debug-info Print some debug info at exit.
                                        -D, --database=name Database to use.
                                        --default-character-set=name
                                        Set the default character set.
                                        --delimiter=name Delimiter to be used.
                                        -e, --execute=name Execute command and quit. (Disables --force and history
                                        file)
                                        -E, --vertical Print the output of a query (rows) vertically.
                                        -f, --force Continue even if we get an sql error.
                                        -G, --named-commands
                                        Enable named commands. Named commands mean this program's
                                        internal commands; see mysql> help . When enabled, the
                                        named commands can be used from any line of the query,
                                        otherwise only from the first line, before an enter.
                                        Disable with --disable-named-commands. This option is
                                        disabled by default.
                                        -g, --no-named-commands
                                        Named commands are disabled. Use * form only, or use
                                        named commands only in the beginning of a line ending
                                        with a semicolon (;) Since version 10.9 the client now
                                        starts with this option ENABLED by default! Disable with
                                        '-G'. Long format commands still work from the first
                                        line. WARNING: option deprecated; use
                                        --disable-named-commands instead.
                                        -i, --ignore-spaces Ignore space after function names.

                                        @

                                        1 Reply Last reply
                                        0
                                        • D Offline
                                          D Offline
                                          doforumda
                                          wrote on 12 Oct 2010, 09:21 last edited by
                                          #45

                                          @
                                          --local-infile Enable/disable LOAD DATA LOCAL INFILE.
                                          -b, --no-beep Turn off beep on error.
                                          -h, --host=name Connect to host.
                                          -H, --html Produce HTML output.
                                          -X, --xml Produce XML output
                                          --line-numbers Write line numbers for errors.
                                          -L, --skip-line-numbers
                                          Don't write line number for errors. WARNING: -L is
                                          deprecated, use long version of this option instead.
                                          -n, --unbuffered Flush buffer after each query.
                                          --column-names Write column names in results.
                                          -N, --skip-column-names
                                          Don't write column names in results. WARNING: -N is
                                          deprecated, use long version of this options instead.
                                          -O, --set-variable=name
                                          Change the value of a variable. Please note that this
                                          option is deprecated; you can set variables directly with
                                          --variable-name=value.
                                          --sigint-ignore Ignore SIGINT (CTRL-C)
                                          -o, --one-database Only update the default database. This is useful for
                                          skipping updates to other database in the update log.
                                          --pager[=name] Pager to use to display results. If you don't supply an
                                          option the default pager is taken from your ENV variable
                                          PAGER. Valid pagers are less, more, cat [> filename],
                                          etc. See interactive help (\h) also. This option does not
                                          work in batch mode. Disable with --disable-pager. This
                                          option is disabled by default.
                                          --no-pager Disable pager and print to stdout. See interactive help
                                          (\h) also. WARNING: option deprecated; use
                                          --disable-pager instead.
                                          -p, --password[=name]
                                          Password to use when connecting to server. If password is
                                          not given it's asked from the tty.
                                          -P, --port=# Port number to use for connection or 0 for default to, in
                                          order of preference, my.cnf, $MYSQL_TCP_PORT,
                                          /etc/services, built-in default (3306).
                                          --prompt=name Set the mysql prompt to this value.
                                          --protocol=name The protocol of connection (tcp,socket,pipe,memory).
                                          -q, --quick Don't cache result, print it row by row. This may slow
                                          down the server if the output is suspended. Doesn't use
                                          history file.
                                          -r, --raw Write fields without conversion. Used with --batch.
                                          --reconnect Reconnect if the connection is lost. Disable with
                                          --disable-reconnect. This option is enabled by default.
                                          -s, --silent Be more silent. Print results with a tab as separator,
                                          each row on new line.
                                          -S, --socket=name Socket file to use for connection.
                                          --ssl Enable SSL for connection (automatically enabled with
                                          other flags). Disable with --skip-ssl.
                                          --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
                                          --ssl).
                                          --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
                                          --ssl-cert=name X509 cert in PEM format (implies --ssl).
                                          --ssl-cipher=name SSL cipher to use (implies --ssl).
                                          --ssl-key=name X509 key in PEM format (implies --ssl).
                                          --ssl-verify-server-cert
                                          Verify server's "Common Name" in its cert against
                                          hostname used when connecting. This option is disabled by
                                          default.
                                          -t, --table Output in table format.
                                          --tee=name Append everything into outfile. See interactive help (\h)
                                          also. Does not work in batch mode. Disable with
                                          --disable-tee. This option is disabled by default.
                                          --no-tee Disable outfile. See interactive help (\h) also. WARNING:
                                          option deprecated; use --disable-tee instead
                                          -u, --user=name User for login if not current user.
                                          -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
                                          -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
                                          -v, --verbose Write more. (-v -v -v gives the table output format).
                                          -V, --version Output version information and exit.
                                          -w, --wait Wait and retry if connection is down.
                                          --connect_timeout=# Number of seconds before connection timeout.
                                          --max_allowed_packet=#
                                          Max packet length to send to, or receive from server
                                          --net_buffer_length=#
                                          Buffer for TCP/IP and socket communication
                                          --select_limit=# Automatic limit for SELECT when using --safe-updates
                                          --max_join_size=# Automatic limit for rows in a join when using
                                          --safe-updates
                                          --secure-auth Refuse client connecting to server if it uses old
                                          (pre-4.1.1) protocol
                                          --server-arg=name Send embedded server this as a parameter.
                                          --show-warnings Show warnings after every statement.

                                          Default options are read from the following files in the given order:
                                          /etc/xampp/my.cnf /opt/lampp/etc/my.cnf ~/.my.cnf
                                          The following groups are read: mysql client
                                          The following options may be given as the first argument:
                                          --print-defaults Print the program argument list and exit
                                          --no-defaults Don't read default options from any options file
                                          --defaults-file=# Only read default options from the given file #
                                          --defaults-extra-file=# Read this file after the global files are read

                                          @

                                          1 Reply Last reply
                                          0

                                          35/150

                                          12 Oct 2010, 08:42

                                          topic:navigator.unread, 115
                                          • Login

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