Just pointing this out… You have "mysql_password", the correct metadata key name is "mysql_pw". And yes, it needs to be "internal_metadata" not "customer_metadata".
-- Brian Bennett Systems Engineer, Cloud Operations, Joyent, Inc. 655 Montgomery St., Suite 1600 | San Francisco | California | 94111 [email protected] <mailto:[email protected]> | www.joyent.com <http://www.joyent.com/> > On May 7, 2015, at 1:39 AM, Gavin Ang <[email protected]> wrote: > > Hi, > I’m trying to work with the Joyent SmartOS image that comes bundled with > Mysql Cluster. Firstly trying to get the basic mysqld working, I could start > mysql, but then couldn’t log in. > > According to the documentation, I need to set the password while > provisioning, so I have included this in the json: > > "customer_metadata": { > "mysql_password": "xxxxxx" > }, > > Which I verified using vmadm get $uuid > > But when I login to the instance and try to access mysql using > > [root@e3f9cb38-6af7-4f1d-b719-c414ebedb0b0 ~]# mysql -uroot -p$(mdata-get > mysql_pw) > No metadata for 'mysql_pw' > Enter password: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > How can I get round this. Can’t even stop the DB now. > > Thanks, > Gavin > > smartos-discuss | Archives > <https://www.listbox.com/member/archive/184463/=now> > <https://www.listbox.com/member/archive/rss/184463/26986985-d0246faa> | > Modify <https://www.listbox.com/member/?&;> Your Subscription > <http://www.listbox.com/>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
