default_socket = /tmp/mysql.sock
As a result, PHP cannot reach MySQL. We can change it to:
mysql.default_socket = /var/lib/mysql/mysql.sock
However, to be sure, we must find the exact location of this socket.
Named Pipe Problem (Windows)
This is a problem similar to the above, but on Windows. It can be solved by adjusting
mysql.default_socket with the correct named pipe used to connect locally to a
MySQL server. For example:
mysql.default_socket = MySQL
Error # 2003: The Server is not Responding
If the MySQL server is not on the same machine as the web server, and is not
answering, phpMyAdmin (starting with version 2.6.0) detects the fact and reports
it, accordingly.
Troubleshooting and Support
[ 300 ]
MySQL Said: Access Denied
This error can be solved when we understand the relevant login parameters.
When Using http Authentication
We cannot use the web server security mechanism based on a .htaccess file and the
http authentication in config.inc.php together. A workaround is to use cookie as
the authentication type instead of http.
When Using http, cookie, or config Authentication
The host parameter in config.inc.php must match the host defined in the user
access privileges. Sometimes, a system administrator may create an account
authorizing user bill and host localhost. If we try to use 127.0.0.1 host in
config.
Pages:
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271