MySQL login

17 posts

tulpMarch 3, 2006 at 7:53 AM#

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

LarsenMarch 3, 2006 at 8:41 AM#

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.

tulpMarch 3, 2006 at 9:32 AM#

someone know how I can do that exactly?

tulpMarch 3, 2006 at 12:02 PM#

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?

LarsenMarch 3, 2006 at 12:11 PM#

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.

tulpMarch 3, 2006 at 2:53 PM#

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?

InstructorMarch 3, 2006 at 7:33 PM#

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

tulpMarch 8, 2006 at 6:38 AM#

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?

InstructorMarch 8, 2006 at 10:17 AM#

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

Pop $0

MessageBox MB_OK "Exit code $0"

tulpMarch 8, 2006 at 1:31 PM#

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.

hugiMarch 8, 2006 at 3:14 PM#

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!!!

tulpMarch 9, 2006 at 9:01 AM#

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?

TakhirMarch 9, 2006 at 9:16 AM#edited March 9, 2006 at 9:32 AM

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"

InstructorMarch 9, 2006 at 9:41 AM#

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"

TakhirMarch 9, 2006 at 9:42 AM#

Yes, if stack is not empty 🙂

tulpMarch 9, 2006 at 10:06 AM#

@Takhir and @Instructor,

Where can I implement my code with yours?

InstructorMarch 9, 2006 at 12:17 PM#

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}'