当我使用c9.io时，如何连接到MySQL [英] When I use c9.io ,How can I connect to MySQL

问题描述

c9.io是一个非常好的网站

c9.io is a verygood website

我有一个php zoon，当我想连接到MySQL时，我不知道密码. 我尝试[空格]根... 但是，一切都错了.

I have a php zoon , and when I want to connect to MySQL,I don't know password. I have try [space] root ... but,all is wrong.

我可以在shell中打开mysql，没有密码，我的操作返回错误: 错误:无法通过套接字'/var/lib/mysql/mysql.sock'(2)连接到本地MySQL服务器"

I can open mysql in shell , no password ,my operate return error: error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

看起来好像mysqld没有启动.(我尝试过"mysqld start"，但是失败了)

It's looks like, mysqld is not started 。（I have try "mysqld start"，but faild）

我想知道的是， Mysql服务在c9.io上免费吗?

What I want to know, Is Mysql service free on c9.io ?

推荐答案

我们非常高兴地宣布我们在Cloud9中首次支持MySQL迭代.它使您可以轻松地在工作空间中轻松安装，启动和停止MySQL实例.令人高兴的是，每个工作区都将运行一个单独的数据库，因此您的项目将永远不会相互干扰.您可以使用从终端运行的mysql-ctl命令行工具来控制MySQL.

We are extremely happy to announce our first iteration of MySQL support in Cloud9. It makes it super easy to install, start and stop a MySQL instance right in your workspace. The nice thing is that every workspace will run a separate database so your projects will never interfere with each other. You can control MySQL with the mysql-ctl command line tool run from the terminal.

# start MySQL. Will create an empty database on first start
$ mysql-ctl start

# stop MySQL
$ mysql-ctl stop

# run the MySQL interactive shell
$ mysql-ctl cli

然后可以使用以下参数连接到数据库:

You can then connect to the database with following parameters:

Option    Value   Comment
Hostname  $IP The same local IP as the application you run on Cloud9
Port  3306    The default MySQL port number
User  $C9_USER    Your Cloud9 user name
Password  -   No password since you can only access the DB from within the workspace
Database  c9  The database name

当然，这仅仅是开始.例如，我们有计划添加管理UI来启动和停止数据库或预安装工具(例如phpMyAdmin).但是，我们不想让您等待完全集成的功能，而我们已经拥有了可以启用许多用例并且仍然非常易于使用的功能.

Of course this is just the beginning. We have for example plans to add a management UI to start and stop databases or pre-installing tools like phpMyAdmin. However we don’t want to make you wait for the fully integrated feature while we already have something that is enabling a lot of use cases and still super easy to use.

敬请期待和愉快的编码.

Stay tuned and happy coding.

这篇关于当我使用c9.io时，如何连接到MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！