I got the following error message during creating database >> Error creating database "AtmModel_ ...". Access denied for user 'name'@'localhost' (using password: YES)

[Jiri Kroc]

Dear all,

Could you help me with a following issue. I am using Windows 7. Database MySQL is installed. Daemon mysqld is running; no green semaphor is visible. Brahms environment is installed, testing project AtmModel is compiled and runned without problem. When I do try to create a new database: File >> Agent Viewer >> New Database (where the correct password and name is inserted), the error message from the title occurs. At this point, I got stucked.

Here it is important to stress out that during installation of MySQL when 'localhost' was inserted, the database itself did not install. It was necessary to manualy change 'localhost' to '127.0.0.1'. Doest it anyhow depend with the error within Brahms? Thank you for your help.

Yours sincerely,

Jiri kroc

[Ron van Hoof]

The Brahms installation directory should contain a Readme file for the AgentViewer. Please read it and make sure the database settings are setup correctly.

Ron

Op ma 24 aug. 2015 3:12 PM schreef Jiri Kroc <jiri.k...@gmail.com>:

--
You received this message because you are subscribed to the Google Groups "Brahms Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to brahms-forum...@googlegroups.com.
To post to this group, send email to brahms...@googlegroups.com.
Visit this group at http://groups.google.com/group/brahms-forum.
For more options, visit https://groups.google.com/d/optout.

[Maarten Sierhuis]

Jiri,

I am not sure if you resolved the problem with Ron’s email. In case not, what Ron meant is that you should look at the AgentViewer_Readme.html file in you Brahms installation folder. It contains the following:

The Agent Viewer is setup by default to access the MySQL server using the username of 'brahms' and user password of 'brahms'. If you wish to use these defaults you must create this user in MySQL and assign it the appropriate privileges.

a. Start mysql in a terminal or command console
-> mysql -u root -p
-> Enter password: <enter your root password>

b. Execute the following commands:
mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'brahms'@'localhost' IDENTIFIED BY 'brahms';
This will allow the brahms user working on the system on which the database is running to create databases, delete databases, and perform all necessary queries on all databases.

c. Under RedHat Linux systems the localhost hostname is broken and requires localhost.localdomain to be used. To enable the privileges for that system enter:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'brahms'@'localhost.localdomain' IDENTIFIED BY 'brahms';

If you setup a different username/password for MySQL you can either start Composer and go to File->Agent Viewer->Database Settings..., then change the username and password in the opened dialog, make sure 'Remember' is checked and press ok. This will store the new credentials encrypted in the agentviewer.cfg file. If you wish to modify the agentviewer.cfg file directory, make sure to use the encpwd tool located in AgentEnvironment/bin to encrypt and encode your username and password and to store the encrypted results in the configuration file.

I hope this helps.


Maarten Sierhuis

[Jiri Kroc]

Dear Maartens,

thank you for your detailed description of the problem. It is answered perfectly. Today, I came at the computer (was away since my first email) done all as is explained in your advices, and it works! Thank you very much. I am a newcomer to your very exciting ABM tool. You will see results, computed by your software, once published. There are enormous possibilities of Brahms software.

Good luck at your work!

jiri

You received this message because you are subscribed to a topic in the Google Groups "Brahms Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/brahms-forum/XyNNdWdCuao/unsubscribe.
To unsubscribe from this group and all its topics, send an email to brahms-forum...@googlegroups.com.