jariza
16th May 2008 10:40 UTC

Problem in spite of putting password to the root in mysql 4.1
Hello, I am doing an installer that would install a MySQL server 4.1 totally.

The principal problem is when I want to give a password to my root account. I've been trying very hard but I can`t reach a solution. I've tried with these solutions.

ExecWait `"$PROGRAMFILES\MySQL4.1\bin\mysql -u root" -p " " SET PASSWORD = PASSWORD('root')`

nsExec::ExecToLog 'cmd /C IF 1==1 "$PROGRAMFILES\MySQL4.1\bin\mysql" -u "root" -p " " SET PASSWORD = PASSWORD('root')`      
    
nsExec::ExecToLog 'cmd /C IF 1==1 "$PROGRAMFILES\MySQL4.1\bin\mysql -u root" < SET PASSWORD FOR ''@'localhost' = PASSWORD('root');

nsExec::ExecToLog 'cmd /C IF 1==1 "$PROGRAMFILES\MySQL4.1\bin\mysql" -u "root" < "$PROGRAMFILES\MySQL4.1\bin\mysql\install.txt"'
where install.txt:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root'); 

Could someone help me?

Thank you in advance.

{_trueparuex^}
16th May 2008 23:06 UTC

Well at least the first one has a quote problem.

Try this.

ExecWait `"$PROGRAMFILES\MySQL4.1\bin\mysql" -u "root" -p " " SET PASSWORD = PASSWORD('root')`

Par