GRANT on the database is not what you need. Grant on the tables directly. Granting privileges on the database mostly is used to grant or revoke connect privileges. This allows you to specify who may do stuff in the database if they have sufficient other permissions. You want instead: GRANT ALL PRIVILEGES ON TABLE side_adzone … Read more
I had the same problem as the title of this question, so incase anyone else googles upon this question and wants to start MySql in ‘skip-grant-tables’ mode on Windows, here is what I did. Stop the MySQL service through Administrator tools, Services. Modify the my.ini configuration file (assuming default paths) C:\Program Files\MySQL\MySQL Server 5.5\my.ini or … Read more
If the GRANT ALL doesn’t work, try: Stop mysqld and restart it with the –skip-grant-tables option. Connect to the mysqld server with just: mysql (i.e. no -p option, and username may not be required). Issue the following commands in the mysql client: UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE User=”root”; FLUSH PRIVILEGES; After that, you should … Read more
Inno Setup 6 has a built-in support for non-administrative install mode. Basically, you can simply set PrivilegesRequiredOverridesAllowed: [Setup] PrivilegesRequiredOverridesAllowed=commandline dialog Additionally, you will likely want to use the auto* variants of the constants. Notably the {autopf} for the DefaultDirName. [Setup] DefaultDirName={pf}\My Program The following is my (now obsolete) solution for Inno Setup 5, based on … Read more
I don’t believe that it is possible to elevate the currently running process. It is built into Windows Vista that administrator privileges are given to a process upon startup, as I understand. If you look at various programs that utilise UAC, you should see that they actually launch a separate process each time an administrative … Read more