Paul,
my Server is up and running! It was at least the "&" at the line's end.
Many thanks to you, Egor and Michael and all who helped. It was nice
working with you.
Helmuth
[EMAIL PROTECTED]
PS.: -> stop the server (control-Z) did not work, but killing within
another terminal window did.
-----------------------------------------------------------------------------------------------------------------------------
Am Mittwoch den, 30. Januar 2002, um 17:19, schrieb Paul DuBois:
> 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 <mysql-unsubscribe-
>> [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
>
---------------------------------------------------------------------
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
