Cisco Unified Application Environment Developer Forums

User Account MySQL Permissions

Sean Galloway Posts: 2 Join Date: 8/17/10 Recent Posts	User Account MySQL Permissions Answer 9/22/10 10:34 PM Mark as an Answer Submit Reply with Quote Quick Reply Forum, I had the issue in the below thread pop up. The fix I used was to grant all privileges to the user account for MySQL access. I am no DBA however, I bet this isn't the best posture to have. Anyways, one line form the post stated, "The account must already exist in MySQL and have permissions on the "mce" database to work." Could someone please state the exact MySQL permissions needed in MySQL? IE: FILE, CREATE, etc... The install instructions are vague, well vague to a non-DBA. Thank you for your time. Good day. http://developer.cisco.com/web/cuae/forums/-/message_boards/message/1112837?_19_delta=20&_19_keywords=&_19_advancedSearch=false&_19_andOperator=true&cur=1
	Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

Nabhonil Sinha Posts: 197 Join Date: 5/30/08 Recent Posts	RE: User Account MySQL Permissions Answer 9/23/10 6:17 PM as a reply to Sean Galloway. Mark as an Answer Submit Reply with Quote Quick Reply Hi Sean, One suggestion here is, since we are creating a new user and giving all permissions on the mce database, why not directly use the root user instead during the install. This will avoid the creation of the database user and its permissions. However if you still want to create a new user then try this SQL command GRANT ALL ON . TO [url=mailto:'myuser'@'localhost']'myuser'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; Hope it helps Thanks Nabhonil. Forum, I had the issue in the below thread pop up. The fix I used was to grant all privileges to the user account for MySQL access. I am no DBA however, I bet this isn't the best posture to have. Anyways, one line form the post stated, "The account must already exist in MySQL and have permissions on the "mce" database to work." Could someone please state the exact MySQL permissions needed in MySQL? IE: FILE, CREATE, etc... The install instructions are vague, well vague to a non-DBA. Thank you for your time. Good day. http://developer.cisco.com/web/cuae/forums/-/message_boards/message/1112837?_19_delta=20&_19_keywords=&_19_advancedSearch=false&_19_andOperator=true&cur=1
	Sign in to vote. Flag Please sign in to flag this as inappropriate. Top

Sean Galloway Posts: 2 Join Date: 8/17/10 Recent Posts	RE: User Account MySQL Permissions Answer 9/24/10 8:01 PM as a reply to Nabhonil Sinha. Mark as an Answer Submit Reply with Quote Quick Reply Nabhonil, That is pretty much what I did. I was trying to create the account with the least amount of privileges, as I thought that was best practice. Just so you understand what I am basing this off of, the instructions stated, "create a MySQL user with sufficient privileges too...." Could help the documentation to specify what permissions those are. Please reference the link below under the section "Installing Platform Services" steps 6, and 7. Have a good day. -Sean http://developer.cisco.com/web/cuae/wikidocs/-/wiki/Main/3.2%20Installation%20Guide Hi Sean, One suggestion here is, since we are creating a new user and giving all permissions on the mce database, why not directly use the root user instead during the install. This will avoid the creation of the database user and its permissions. However if you still want to create a new user then try this SQL command GRANT ALL ON . TO [url=mailto:'myuser'@'localhost']'myuser'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; Hope it helps Thanks Nabhonil.
	Sign in to vote. Flag Please sign in to flag this as inappropriate. Top