SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2000
    Location
    Norcross, GA
    Posts
    136
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When I run:

    [prompt] mysql

    The following appears on the screen:

    Code:
    Usage: mysql [OPTIONS] database
      -B, --batch           print results with a tab as separator, each row on
                            a new line
      -#, --debug=...       output debug log. Often this is 'd:t:o,filename`
      -T, --debug-info      print some debug info at exit
      -e, --exec=...        execute command and quit.(--batch is implicit)
      -f, --force           continue even if we get an sql error.
      -?, --help            display this help and exit
      -h, --host=...        connect to host
      -n, --unbuffered      flush buffer after each query
      -p, --password[=...]  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
      -q, --quick           don't cache result, print it row by row. This may
                            slow down the server if the output is suspended
      -r, --raw             write fields without conversion. Used with --batch
      -s, --silent          be more silent.
      -S  --socket=...      Socket file to use for connection
      -u, --user=#          user for login if not current user
      -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
    
    [root@somecomputer bin]#
    MySQL is installed - when I ran mysql_install_db it says:

    mysql privilege databases already installed. If you want to recreate all privilege tables, execute 'rm -i /var/lib/mysql/mysql/*.IS?'and run this script again

    What is wrong with the installation? Why am I not getting a mysql prompt?

    (Redhat 6.2)

  2. #2
    SitePoint Zealot
    Join Date
    Dec 2000
    Location
    Norcross, GA
    Posts
    136
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Update. Just fooling around I was able to get a mysql prompt by typing:

    % mysql test

    In other systems I've worked on I didn't have to specify a table name in order to get the mysql prompt. Is there a setting that can be changed to allow this?

  3. #3
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    What version of MySQL are you running?
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  4. #4
    SitePoint Zealot
    Join Date
    Dec 2000
    Location
    Norcross, GA
    Posts
    136
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, that was the problem.

    I thought I was using 3.23, but it was actually 3.20. After removing 3.20 and installing 3.23 things are working like normal.

  5. #5
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Glad to hear it! You were freaking me out for a minute, there.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •