tulp
3rd March 2006 09:53 UTC

MySQL login
Can I login in my MySQL account? I want to change my password, create a database and import a database.
CAn somebody give me a sample how I can do that?

Tulp

Larsen
3rd March 2006 10:41 UTC

You can use mysql with command line parameters to execute sql commands. That way you should be able to create database and import from a file.

I don´t remember the actual syntax so have a look at the mysql documentation.

tulp
3rd March 2006 11:32 UTC

someone know how I can do that exactly?

tulp
3rd March 2006 14:02 UTC

OK, I found out the command to use,l but NSIS gives an error.

ExecWait '$INSTDIR\MySQL\bin>mysql --user=root -e "set password = password('Mira 0101')"'

The problem is in the quotes?

Larsen
3rd March 2006 14:11 UTC

I think it should look like this:
ExecWait `$INSTDIR\MySQL\bin\mysql --user=root -e "set password = password('Mira 0101')"`

You have to use different quotes, NSIS supports " ' and `.
Also, after bin there has to be a backslash not a ">"

Nevertheless, it would be better, if you posted the error.

tulp
3rd March 2006 16:53 UTC

Thank you for the reply Larsen.
The command works now but it still don't change the password. I can go in the mysql by typing ENTER.
So no password need, but I want that the user enter a password. Where is the problem?

Instructor
3rd March 2006 21:33 UTC

http://nsis.sourceforge.net/ExecCmd_plug-in

tulp
8th March 2006 08:38 UTC

Sorry for the late reaction!

Thanx for the link Instructor.
I tryed this command but still no result, it doesn't give any error message, but it skip the command:

ExecCmd::exec `$INSTDIR\MySQL\bin\mysql --user=root --password= -e "set password = password('Mira 0101')"`

Any help?

Instructor
8th March 2006 12:17 UTC

ExecCmd::exec `"$INSTDIR\MySQL\bin\mysql" --user=root --password= -e "set password = password('Mira 0101')"`
Pop $0
MessageBox MB_OK "Exit code $0"

tulp
8th March 2006 15:31 UTC

Thanks for tye reply Instructor.
I tryed your code, but it doesn't work.
It still skip the command!
If I use the command in cmd mode, it works properly, only in NSIS it doen's work.

hugi
8th March 2006 17:14 UTC

You must do it like this:
ReadEnvStr $0 COMSPEC
ExecWait '$0 /C "$INSTDIR\MySQL\bin\mysql" --user=root --password= -e "set password = password('Mira 0101')"' $R9

for example... you need the context of the console!!!

tulp
9th March 2006 11:01 UTC

Thanks for the reply Hugi,

It still skip the command.
There's an error in ur command hugi, after ExecWait u use: '', U have to use the `` parameters.

But it still doesn't work.
Any help?

Takhir
9th March 2006 11:16 UTC

I am not sure, but most of Windows executables have exe extension and I see right now "MySQL\MySQL Server 4.1\mysql.exe" file :) This is not required in DOS window, but is mandatory for system calls. And I could print --help to file

  ExecCmd::exec /TEST /TIMEOUT=10000 \
   '"$PROGRAMFILES\MySQL\MySQL Server 4.1\bin\mysql.exe" --help >stdout.txt'
  Pop $0
  MessageBox MB_OK "Exit code $0"

Instructor
9th March 2006 11:41 UTC

There probably need empty string for correct stack output:

  ExecCmd::exec /TEST /TIMEOUT=10000 \
   '"$PROGRAMFILES\MySQL\MySQL Server 4.1\bin\mysql.exe" --help >stdout.txt' ""
  Pop $0
  MessageBox MB_OK "Exit code $0"

Takhir
9th March 2006 11:42 UTC

Yes, if stack is not empty :)

tulp
9th March 2006 12:06 UTC

@Takhir and @Instructor,

Where can I implement my code with yours?

Instructor
9th March 2006 14:17 UTC

Tested :)

nsExec::Exec `"d:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe" --user=root --password="old password" -e "SET PASSWORD = PASSWORD('new password')"`
Pop $0
MessageBox MB_OK '$$0={$0}'