At 9:57 +0100 1/30/02, Lutz, Helmuth wrote:
>Paul,
>
>>Okay, then try adding the --user=mysql option to the command.
>
>I killed the server (kill -9) and brought it back up with -Sg --user=mysql:
>
>The result:
>[localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg
>--user=mysql
Okay, here I forgot something. You need a & on the end of the command
to start the server in the background.
To solve your problem below, open a new window and run mysql to connect
to the server *or* stop the server (control-Z) and resume it in the background
(Use "bg"), then run mysql to connect.
The UPDATE statement that you pasted in is being ignored. You should issue
it from within the mysql program.
>---> Here came some hints
>Cannot initialize InnoDB as 'innidb_data_file_path' is not set.
>If you do not want to use transactional InnoDB tables, add a line
>skip-innodb
>to the [mysqld] section of init parameters in your my.conf
>or my.ini. If you want to use InnoDB tables, add for example,
>innodb_data_file_path = /mysql/data/ibdata1:20M
>But to get good performance ....
>--->end hint and this line
>/usr/local/mysql/bin/mysqld: ready for connections
>
>This looks nice I think
>
>but then I made this mistake:
>I copy and pasted 2 lines to the terminal (instead of writing them)
>and had the cursor in the 3rd line. I tried to escape without success.
>
>---> My page looks like this:
>/usr/local/mysql/bin/mysqld: ready for connections
>UPDATE user SET Password=PASSWORD('new-password')
>WHERE User='root' AND Host='localhost';
>
>exit
>exit;
>quit;
>stop;
>mysqld test;
> <-- here is the cursor
>
>---> end of my page
>
>1)How can I escape?
>2) would it have been ok if I had used following line at this point?
>UPDATE user SET Password=PASSWORD('myNewPassword') WHERE User='root' AND
>Host='localhost';
>
>>Thanks, Helmuth
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
