如何跟踪Google Cloud SQL中的mysql日志？ [英] How to trace mysql log in Google Cloud SQL?

问题描述

我只是为Google Cloud SQL设置phpMyAdmin（ http://goo.gl/Ey53WS ），但我无法完成步骤登录到phpMyAdmin。我可以从登录页面看到错误信息无法登录到MySQL服务器。

有没有办法让我跟踪MySQL中的错误日志或可能出现的错误）？

解决方案

是的，您可以启用Mysql标志 general_log ON并且 log_output TABLE。然后，你可以在表'mysql'中运行查询： select * from general_log; 并查看是否失败您可以查看App Engine日志。

检查登录（默认为root）和密码（默认情况下为空）在PHP配置文件中，并检查CloudSQL授权访问您的应用程序。

I just setup the phpMyAdmin for the Google Cloud SQL (http://goo.gl/Ey53WS) but am unable to finish at step "Log in to phpMyAdmin". I can just see the error message "Cannot log in to the MySQL server" from the login page.

Is there anyway for me to trace the error log from the MySQL (or the possible error for this)?

解决方案

Yes, you can enable Mysql flags general_log ON and log_output TABLE.

Then you can run query in table 'mysql': select * from general_log; and see if there are failed connections.

You can look at the App Engine logs too.

Check login (root by default) and password (empty by default) in PHP config file and check that CloudSQL authorize access to your application.

这篇关于如何跟踪Google Cloud SQL中的mysql日志？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！