![\"Screen](\"http:\/\/www.haxed.me.uk\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-03-at-9.33.17-AM.png\")
<\/a><\/p>\nHowever I have included the script source code underneath for reference. This has been tested and works.<\/p>\n
Script Code:<\/p>\n
#!\/bin\/bash
\n# Enable root dbaas user access
\n# User Alterable variables
\n# Author: Adam Bull
\n# Date: Monday, November 30 2015
\n# Company: Rackspace UK Server Hosting<\/p>\n
# ACCOUNTID forms part of your control panel login; https:\/\/mycloud.rackspace.co.uk\/cloud\/1001111\/database#rax%3Adatabase%2CcloudDatabases%2CLON\/321738d5-1b20-4b0f-ad43-ded24f4b3655<\/p>\n
echo “Enter your Account (DDI) this is the number which forms part of your control panel login e.g. https:\/\/mycloud.rackspace.co.uk\/cloud\/1001111\/”
\nread ACCOUNTID<\/p>\n
echo “Enter your Database ID, this is the number which forms part of your control panel login when browsing the database instance e.g. https:\/\/mycloud.rackspace.co.uk\/cloud\/1001111\/database#rax%3Adatabase%2CcloudDatabases%2CLON\/242738d5-1b20-4b0f-ad43-ded24f4b3655”
\nread DATABASEID<\/p>\n
echo “Enter what Region your database is in i.e. lon, dfw, ord, iad, syd, etc”
\nread REGION<\/p>\n
echo “Enter your customer username login (visible from account settings page)”
\nread USERNAME<\/p>\n
echo “Enter your customer apikey (visible from account settings page)”
\nread APIKEY<\/p>\n
echo “$USERNAME $APIKEY”<\/p>\n
TOKEN=`curl https:\/\/identity.api.rackspacecloud.com\/v2.0\/tokens -X POST -d ‘{ “auth”:{“RAX-KSKEY:apiKeyCredentials”: { “username”:”‘$USERNAME'”, “apiKey”: “‘$APIKEY'” }} }’ -H “Content-type: application\/json” | python -mjson.tool | grep -A5 token | grep id | cut -d ‘”‘ -f4`<\/p>\n
echo “Enabling root access for instance $DATABASEID…see below for credentials”
\n# Enable the root user for instance id
\ncurl -X POST -i \\
\n-H “X-Auth-Token: $TOKEN” \\
\n-H ‘Content-Type: application\/json’ \\
\n“https:\/\/$REGION.databases.api.rackspacecloud.com\/v1.0\/$ACCOUNTID\/instances\/$DATABASEID\/root”<\/p>\n
# Confirm root user added
\ncurl -i \\
\n-H “X-Auth-Token: $TOKEN” \\
\n-H ‘Content-Type: application\/json’ \\
\n“https:\/\/$REGION.databases.api.rackspacecloud.com\/v1.0\/$ACCOUNTID\/instances\/$DATABASEID\/root”<\/p>\n","protected":false},"excerpt":{"rendered":"
I have noticed that we get quite a few customers asking how to enable root user in the Rackspace cloud database product. So much so that I thought I would go to the effort of compiling a wizard script which … Continue reading