Failed remote mysql in Bluemix
After binding mysql service on my app. I got credentials like this
{ "mysql-5.5": { "name": "mysql-wp", "label": "mysql-5.5", "plan": "100", "credentials": { "name": "da459bf3d5b6a42799e6fd14ea8a38e05", "hostname": "198.11.234.73", "host": "198.11.234.73", "port": 3307, "user": "xx", "username": "xx", "password": "xx", "uri": "mysql://uxwlzmc839lBN:pmhfru4KyYOiT@198.11.234.73:3307/da459bf3d5b6a42799e6fd14ea8a38e05" } } }
I want to create and manage database remotely via Mysql Workbench. When i put the credential for testing the connection, error occured . It said "Failed to Connect Mysql Server @ ..."
Other one: Does Bluemix provide Mysql Management Tools on the fly like "PHPMyAdmin"?
Thanks in Advance.
Hi Gemblue,
You've got a couple of options. Either use the ClearDB MySQL service which will give you credentials and a URL to a public IP [ I have then successfully used local tools such as Sequel Pro. More info here or you can choose to bind your existing "experimental" MySQL service to a PHPMyAdmin app that you deploy within your own Bluemix org/space. You can find a Bluemix/CloudFoundry friendly PHPMyAdmin deploy @ https://github.com/dmikusa-pivotal/cf-ex-phpmyadmin . I've used this PHPMyAdmin tool successfully as well. You will need to leverage the username and password provided by the credentials in the VCAP_SERVICES as your login. One caveat is on file upload limits (for import of MySQL exports). If you find the limit too small (eg. 2 Mb), then you'll need to fork the php buildpack and adjust its php.ini files yourself. Then repush the PHPMyAdmin app again with your modified buildpack.
Good luck.
Hi Sanjay,
I try to use phpmyadmin to manage a db instance on blumix. I take the #2002 error code when I try to connect via phpmyadmin interface.
What parameters did you use in your test ?
Many thanks in advance
I update my config.inc.php file in a following mode
$i++;
$cfg['Servers'][$i]['host']='myServerId'; $cfg['Servers'][$i]['port']=myportId; $cfg['Servers'][$i]['user']='myUser'; $cfg['Servers'][$i]['password']='myPsw'; $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['compress'] = false;
I retrieve the data from the file provide me from blumix interface
"mysql-5.5": { "name": "mysql", "label": "mysql-5.5", "plan": "100", "credentials": { "name": "db9f6faca3e2e49169e8adefc1f526c9c", "hostname": "myServerId", "host": "myServerId", "port": myportId, "user": "myUser", "username": "myUser", "password": "myPsw", "uri": "-------" } } }