无法连接到mysql数据库[strato] [英] Can not connect to mysql database [strato]
问题描述
我通过strato购买了一个Web空间,现在我正尝试通过php连接到mysql数据库.但是每次php说Lost connection to MySQL server at 'reading initial communication packet', system error: 111
i bought a web space by strato and now i am trying to connect to the mysql database through php. But every time php say Lost connection to MySQL server at 'reading initial communication packet', system error: 111
Host: rdbms.strato.de
User: Uxxxxx
Database: DBxxxx
我也尝试连接本地主机或127.0.0.1主机的宽度,但是它不起作用.
I also tried to connect width the localhost or 127.0.0.1 host but it doesen't work.
解决方案是连接到URL"rdbms.strato.de".作为用户名,您需要数据库用户名("UXXXXX"),并且作为密码,需要数据库密码.连接成功后,您需要将数据库更改为数据库名称("DBXXXXX").
The solution was to connect to the url "rdbms.strato.de". As username you need your database user name ("UXXXXX") and as password your database password. After the connection was successfully you need to change your database to your database name ("DBXXXXX").
希望有帮助.
推荐答案
连接可能性(访问权限)取决于您的托管软件包.但是,实际上,不允许与strato mySQL进行远程连接(出于安全原因). 我在使用PowerWeb Basic时遇到了同样的麻烦.
Connection posibilities(access) depends on your hosting package. But, actually, remote connections to strato mySQL is not allowed(security reasons). I have the same trouble with PowerWeb Basic.
这篇关于无法连接到mysql数据库[strato]的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!