English 中文(简体)
能够连接MySQL
原标题:Can t connect to MySQL

我试图利用Sequel Pro与我的SQL联系,我以前曾多次这样做。 标题是: 我收到以下信息:

Unable to connect to host 127.0.0.1 because access was denied.

重复核对你的用户名称和密码,确保允许从你目前的地点进入。

MySQL said: Access denied for user root @ localhost (using password: NO)


对于其价值而言,我在提升到新的澳门特工(Mavericks)后发出这一信息,认识到该服务器的运行滞后,下载了新的服务器(目前正在运行),并再次尝试——但我也存在同样的问题。

问题回答
  1. Make sure you are running MySql in background System Preferences -> Mysql -> Start MySql
  2. Make sure you are able to connect to MySql through command line, if command line works, there is no reason why it should not work in SequelPro.
  3. If problem still persists, try changing the root password.

我在澳门就发生了这种情况。 我去了系统偏好——>MySQL->停机服务器,再次开机,工作。





相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签