MySQL Forums
Forum List  »  Newbie

Password not accepted
Posted by: eiger 3970
Date: September 14, 2018 07:08PM

I'm confused about the MySQL passwords.
Upon MySQL install, I was provided a random password, then prompted to change. I changed to a password.
I then had a 2nd password from MySQL.
I added user root.
Somehow I cannot complete the below command with the user root and root password?

App: Jira 7.12.1.
Database MySQL: mysql Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL).
OS: CentOS Linux release 7.5.1804 (Core).

Clean Jira and MySQL install.

I'm following https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-938846854.html

Step 3 for MySQL 5.7.6 and above, command fails:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
Error message: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '<password entered when I setup the MySQL database>'' at line 1

Options: ReplyQuote


Subject
Written By
Posted
Password not accepted
September 14, 2018 07:08PM
September 17, 2018 07:03AM
September 17, 2018 07:09AM
September 17, 2018 10:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.