I was able to reconnect after using mysql -u -p mythconverg<br>
and then it prompted me for the password.<br>
<br>
Thanks guys ;)<br><br><div><span class="gmail_quote">On 9/9/05, <b class="gmail_sendername">Ryan Pisani</b> <<a href="mailto:mythtv@frouse3.homelinux.com">mythtv@frouse3.homelinux.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
try connecting like this:<br><br>mysql -uroot -pmypassword mythconverg<br><br>leave the spaces out.<br><br><br>Ryan<br><br>> Ok, i read section 6.2 again and this is what i get when i try<br>> $ mysql -u root mythconverg
<br>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using<br>> password: NO)<br>><br>> so i checked this file .mysql_history and get this<br>><br>> # cat .mysql_history<br>> UPDATE user SET Password=PASSWORD('mypassword') WHERE user='root';
<br>> FLUSH PRIVILEGES;<br>><br>> So then i try this.<br>><br>> mysql -u root -p 'mypassword' mythconverg<br>><br>> and i get this.<br>><br>> mysql Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386) using readline
<br>> 4.3<br>> Copyright (C) 2002 MySQL AB<br>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,<br>> and you are welcome to modify and redistribute it under the GPL license<br>> Usage: mysql [OPTIONS] [database]
<br>> -?, --help Display this help and exit.<br>> -I, --help Synonym for -?<br>> --auto-rehash Enable automatic rehashing. One doesn't need to use<br>> 'rehash' to get table and field completion, but startup<br>
> and reconnecting may take a longer time. Disable with<br>> --disable-auto-rehash.<br>> -A, --no-auto-rehash<br>> No automatic rehashing. One has to use 'rehash' to get<br>> table and field completion. This gives a quicker start of
<br>> mysql and disables rehashing on reconnect. WARNING:<br>> options deprecated; use --disable-auto-rehash instead.<br>> -B, --batch Don't use history file. Disable interactive behavior.<br>> (Enables --silent)
<br>> --character-sets-dir=name<br>> Directory where character sets are.<br>> --default-character-set=name<br>> Set the default character set.<br>> -C, --compress Use compression in server/client protocol.<br>
> -#, --debug[=#] This is a non-debug version. Catch this and exit<br>> -D, --database=name Database to use.<br>> --delimiter=name Delimiter to be used.<br>> -e, --execute=name Execute command and quit. (Disables --force and history
<br>> file)<br>> -E, --vertical Print the output of a query (rows) vertically.<br>> -f, --force Continue even if we get an sql error.<br>> -g, --no-named-commands<br>> Named commands are disabled. Use \* form only, or use
<br>> named commands only in the beginning of a line ending<br>> with a semicolon (;) Since version 10.9 the client now<br>> starts with this option ENABLED by default! Disable with<br>> '-G'. Long format commands still work from the first
<br>> line. WARNING: option deprecated; use<br>> --disable-named-commands instead.<br>> -G, --named-commands<br>> Enable named commands. Named commands mean this program's<br>> internal commands; see mysql> help . When enabled, the
<br>> named commands can be used from any line of the query,<br>> otherwise only from the first line, before an enter.<br>> Disable with --disable-named-commands. This option is<br>> disabled by default.<br>> -i, --ignore-spaces Ignore space after function names.
<br>> --local-infile Enable/disable LOAD DATA LOCAL INFILE.<br>> -b, --no-beep Turn off beep on error.<br>> -h, --host=name Connect to host.<br>> -H, --html Produce HTML output.<br>> -X, --xml Produce XML output
<br>> --line-numbers Write line numbers for errors.<br>> -L, --skip-line-numbers<br>> Don't write line number for errors. WARNING: -L is<br>> deprecated, use long version of this option instead.<br>> --no-pager Disable pager and print to stdout. See interactive help
<br>> (\h) also. WARNING: option deprecated; use<br>> --disable-pager instead.<br>> --no-tee Disable outfile. See interactive help (\h) also. WARNING:<br>> option deprecated; use --disable-tee instead<br>> -n, --unbuffered Flush buffer after each query.
<br>> --column-names Write column names in results.<br>> -N, --skip-column-names<br>> Don't write column names in results. WARNING: -N is<br>> deprecated, use long version of this options instead.<br>> -O, --set-variable=name
<br>> Change the value of a variable. Please note that this<br>> option is deprecated; you can set variables directly with<br>> --variable-name=value.<br>> --sigint-ignore Ignore SIGINT (CTRL-C)<br>> -o, --one-database Only update the default database. This is useful for
<br>> skipping updates to other database in the update log.<br>> --pager[=name] Pager to use to display results. If you don't supply an<br>> option the default pager is taken from your ENV variable<br>> PAGER. Valid pagers are less, more, cat [> filename],
<br>> etc. See interactive help (\h) also. This option does not<br>> work in batch mode.<br>> -p, --password[=name]<br>> Password to use when connecting to server. If password is<br>> not given it's asked from the tty.
<br>> -P, --port=# Port number to use for connection.<br>> --prompt=name Set the mysql prompt to this value.<br>> --protocol=name The protocol of connection (tcp,socket,pipe,memory).<br>> -q, --quick Don't cache result, print it row by row. This may slow
<br>> down the server if the output is suspended. Doesn't use<br>> history file.<br>> -r, --raw Write fields without conversion. Used with --batch.<br>> --reconnect Reconnect if the connection is lost. Disable with
<br>> --disable-reconnect. This option is enabled by default.<br>> -s, --silent Be more silent. Print results with a tab as separator,<br>> each row on new line.<br>> -S, --socket=name Socket file to use for connection.
<br>> --ssl Enable SSL for connection (automatically enabled with<br>> other flags). Disable with --skip-ssl.<br>> --ssl-key=name X509 key in PEM format (implies --ssl).<br>> --ssl-cert=name X509 cert in PEM format (implies --ssl).
<br>> --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies<br>> --ssl).<br>> --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).<br>> --ssl-cipher=name SSL cipher to use (implies --ssl).
<br>> -t, --table Output in table format.<br>> -T, --debug-info Print some debug info at exit.<br>> --tee=name Append everything into outfile. See interactive help (\h)<br>> also. Does not work in batch mode.<br>
> -u, --user=name User for login if not current user.<br>> -U, --safe-updates Only allow UPDATE and DELETE that uses keys.<br>> -U, --i-am-a-dummy Synonym for option --safe-updates, -U.<br>> -v, --verbose Write more. (-v -v -v gives the table output format).
<br>> -V, --version Output version information and exit.<br>> -w, --wait Wait and retry if connection is down.<br>> --connect_timeout=# Number of seconds before connection timeout.<br>> --max_allowed_packet=#<br>
> Max packet length to send to, or receive from server<br>> --net_buffer_length=#<br>> Buffer for TCP/IP and socket communication<br>> --select_limit=# Automatic limit for SELECT when using --safe-updates<br>> --max_join_size=# Automatic limit for rows in a join when using
<br>> --safe-updates<br>> --secure-auth Refuse client connecting to server if it uses old<br>> (pre-4.1.1) protocol<br>><br>> Default options are read from the following files in the given order:<br>> /etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf
<br>> The following groups are read: mysql client<br>> The following options may be given as the first argument:<br>> --print-defaults Print the program argument list and exit<br>> --no-defaults Don't read default options from any options file
<br>> --defaults-file=# Only read default options from the given file #<br>> --defaults-extra-file=# Read this file after the global files are read<br>><br>> Variables (--variable-name=value)<br>> and boolean options {FALSE|TRUE} Value (after reading options)
<br>> ------------------------------ --- -----------------------------<br>> auto-rehash TRUE<br>> character-sets-dir (No default value)<br>> default-character-set latin1<br>> compress FALSE<br>> database (No default value)
<br>> delimiter ;<br>> vertical FALSE<br>> force FALSE<br>> named-commands FALSE<br>> local-infile FALSE<br>> no-beep FALSE<br>> host (No default value)<br>> html FALSE<br>> xml FALSE<br>> line-numbers TRUE
<br>> unbuffered FALSE<br>> column-names TRUE<br>> sigint-ignore FALSE<br>> port 3306<br>> prompt mysql><br>> quick FALSE<br>> raw FALSE<br>> reconnect TRUE<br>> socket (No default value)<br>
> ssl FALSE<br>> ssl-key (No default value)<br>> ssl-cert (No default value)<br>> ssl-ca (No default value)<br>> ssl-capath (No default value)<br>> ssl-cipher (No default value)<br>> table FALSE<br>> debug-info FALSE
<br>> user root<br>> safe-updates FALSE<br>> i-am-a-dummy FALSE<br>> connect_timeout 0<br>> max_allowed_packet 16777216<br>> net_buffer_length 16384<br>> select_limit 1000<br>> max_join_size 1000000
<br>> secure-auth FALSE<br>> _______________________________________________<br>> mythtv-users mailing list<br>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>><br><br></blockquote></div><br>