You only need the export/import if you are changing the underlying database (e.g. do the username & password I set here HAVE to match those that were set in the original database. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. How come the Sun's gravity can hold distant planets in orbit, but cannot rip humans off Earth? https://confluence.atlassian.com/jirakb/jira-user-does-not-have-permission-to-access-the-database-214864262.html
I must apologise though - I should have spotted this sooner. "Grant usage" creates a user with a password, but with NO privileges. Changed user's Host from 'localhost' to 'localhost%' 4. The special character password case is tracked in the following bug: JRA-27796 - Cannot use special characters in the database password Resolved Resolution Grant the appropriate permissions to the JIRA user,
cant explain that. asked 5 years ago viewed 799 times active 5 years ago Blog How Do Software Developers in New York, San Francisco, London and Bangalore… Related 1java.sql.SQLException: Access denied for user 'root'@'localhost' Yes No Thanks for your feedback! Mysql Show Users The latter was tried because of the info on the following page: https://confluence.atlassian.com/display/CONFKB/Known+Issues+for+MySQL see the section "Access Denied".
Only just back on trying to move JIRA OK: So I backed up the HOME and INSTALL Directories after exporting the data. Jira Mysql Restart JIRA. Shut down JIRA before you begin, unless you are running the setup wizard. https://confluence.atlassian.com/display/JIRA/Setting+Up+a+MySQL+Database+on+Linux+for+JIRA Oracle -> MySQL) or upgrading older versions of Jira (newer versions from 4.something, it's recommended to use the automatic upgrade function)NickWJun 24, 2014Thanks Nic...I am moving both the database and JIRA
Username Located in the
Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search Linked ApplicationsLoading… Quick Search Help About Confluence Log in Sign up QuestionsTopicsLeaderboardRewardsAccess https://answers.atlassian.com/questions/303416/moving-jira JIRA configuration tool Run the JIRA configuration tool as follows: Windows: Open a command prompt and run config.bat in the bin sub-directory of the JIRA installation directory. Unknown System Variable 'storage_engine' Jira If not, you may encounter problems when creating issues in JIRA. 4 byte characters—Please note that JIRA does not support using MySQL with 4 byte characters. Jira Download Start JIRA Check for errors in the log files.
Not the answer you're looking for? navigate here Create MySQL database and user Create a MySQL user called 'jirauser' and database called 'jiradb': [email protected]:~$ mysql --user=root -p Enter password: Welcome to the MySQL monitor. To copy the MySQL JDBC driver to your application server: Get the MySQL driver: If you are installing JIRA, download the recommended MySQL driverJDBC Connector/J 5.1. Fill out the fields, as described in the Database connection fieldssection below. Grant All Privileges Mysql
The licences is X users on a single server. It really has to say amp with an ampersand and a semicolon at either end. MySQL JDBC Drivers Ensure that you are using the latest (5.1) MySQL Java Connector. Check This Out Thanks for you help Nick jirajira-administrationsetupCommentCommentAdd your comment...3 answers10-1Peter Van de VoordeJun 24, 2014Hi Nick, Just a question: Why don't you simply install a new JIRA instance and use the restore
I am sure this is linked to what you wrote nic.. NickWJun 09, 2014OK. Both the JIRA setup wizard and database configuration tool also add the element
For further information see the MySQL documentation on character sets on collations. that is why I have moved JIRA... share|improve this answer answered Aug 12 '11 at 13:44 Devart 77.9k12104124 add a comment| up vote 0 down vote You don't have the rights to access the remote mysql server. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.
The name of the database in the example is confluence. namely copy and replace the installation and home dirs after importing the exported data. If so is there anyway i can retrieve this as at the moment I cannot remember/locate them. http://ascadys.net/jira-error/jira-error-connecting-to-database.html What's the verb for "to drink small amounts of drink"?
As Peter says, you really should be using the database's own tools to get a full clean copy and import that (unless you're changing database or upgrading really old Jiras)NickWJun 24, Binary logging— Be aware that JIRA uses the 'READ-COMMITTED' transaction isolation level with MySQL, which currently only supports row-based binary logging. Again, if you see an 'Access denied' error: Access denied for user 'jirauser'@'localhost.localdomain' (using password: YES) Then you need to adjust your /etc/hosts so that 'localhost' comes before 'localhost.localdomain', and restart