Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to use default configuration for use root #83

Open
nikolay-dmx opened this issue Aug 8, 2016 · 4 comments
Open

How to use default configuration for use root #83

nikolay-dmx opened this issue Aug 8, 2016 · 4 comments

Comments

@nikolay-dmx
Copy link

Hi,
default user is root and default password is empty but I am not able to use any user with empty password. Can I do or set something ?

@dmarkov
Copy link

dmarkov commented Aug 12, 2016

@yegor256 please do something about it, see par.21

@yegor256
Copy link
Member

@nikolay-dmx what are you doing now? can you show your code/config? we have to reproduce the problem

@nikolay-dmx
Copy link
Author

Hi Yegor,

thanks for your response. Regarding my question, I asked is it possible
MySql user not to be [user:root , pass:root] but some other, for example
as default one :[user:root pass:"EMPTY"] . Anyway I solve that, I just made
different comfigurations for Integration tests and other tests.

Best Regards
Nikolay

On Thu, Aug 18, 2016 at 7:54 PM, Yegor Bugayenko notifications@github.com
wrote:

@nikolay-dmx https://github.com/nikolay-dmx what are you doing now? can
you show your code/config? we have to reproduce the problem


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#83 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AT11I1rDiUFcjbpFKzs3HDdwZPOC_7j0ks5qhI5VgaJpZM4Je_rj
.

@Ivorlun
Copy link

Ivorlun commented Nov 25, 2016

Problem still exists on Windows 10 x64.
No matter what was written in pom-file - perl script will use only default config values as root:root at mysqladmin stage

CMD-output
[INFO] >> Version: '5.6.14-log'  socket: ''  port: 49851  MySQL Community Server (GPL)
[INFO] port 49851 is available after 4s of waiting
[INFO] $ C:\Users\Dubol\NEWworkspace\jas\gui\target\mysql-dist\bin\mysqladmin.exe --no-defaults --port=49851 --user=root --socket=C:\Users\Dubol\NEWworkspace\jas\gui\target\mysql-data\mysql.sock --host=127.0.0.1 password root
[INFO] $ C:\Users\Dubol\NEWworkspace\jas\gui\target\mysql-dist\bin\mysql.exe --port=49851 --user=root --password=root --socket=C:\Users\Dubol\NEWworkspace\jas\gui\target\mysql-data\mysql.sock
[WARNING] >> Warning: Using a password on the command line interface can be insecure.
[INFO] #start('Config(tcpport=49851, dbuser=liquibase-user, dbpa..115..T NAMES utf8', character-set-server=utf8])', C:\\Users\\Dubol\\NEWworkspace\\jas\\gui\\target\\mysql-dist, C:\\Users\\Dubol\\NEWworkspace\\jas\\gui\\target\\mysql-data): in 25s
......
[INFO] >> 2016-11-25 18:09:39 6460 [Warning] Access denied for user 'liquibase-user'@'localhost' (using password: YES)
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 02:27 min
[INFO] Finished at: 2016-11-25T18:09:39+03:00
[INFO] Final Memory: 64M/560M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.5.3:update (gui-db-update) on project gui: Error setting up or running Liquibase: liquibase.exception.DatabaseException: java.sql.SQLException: Access denied for user 'liquibase-user'@'localhost' (using password: YES) -> [Help 1]
POM-file
                     <execution>
                        <id>mysql-test</id>
                        <goals>
                            <goal>classify</goal>
                            <goal>start</goal>
                            <goal>stop</goal>
                        </goals>
                        <configuration>
                            <port>${mysql.port}</port>
                            <data>${project.build.directory}/mysql-data</data>
                            <user>liquibase-user</user>
                            <password>liquibase-password</password>
                            <options>                                
                                <option>lower-case-table-names=1</option>
                                <option>collation-server=utf8_unicode_ci</option>
                                <option>init-connect='SET NAMES utf8'</option>
                                <option>character-set-server=utf8</option>
                            </options>                              
                        </configuration>
                    </execution>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants