Revision as of 07:51, 13 February 2008

PostgreSQL

Website

http://www.postgresql.org/

About

http://www.postgresql.org/about/

FAQ

http://www.postgresql.org/docs/faqs.FAQ.html

Wikipedia

http://en.wikipedia.org/wiki/Postgresql

Manuals

http://www.postgresql.org/docs/

MySQL

Website

http://www.mysql.com

About

http://www.mysql.org/company/

FAQ

http://www.mysql.com/industry/faq/

Wikipedia

http://en.wikipedia.org/wiki/MySQL

Manuals

http://dev.mysql.com/doc/#refman

FAQ - Why do I get "Too many connections" when connecting to MySQL, and how can I solve it?

Your max_connections setting is too low, See http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html

FAQ - How do I tell what port mysql uses?

You can check the server directly, or make a good guess from a client. The default port is most always 3306. Use these steps to confirm, or to isolate for troubleshooting.

On the server

• # netstat -tlnp | grep mysqld
• $ grep mysql /etc/services
• Review the [mysqld] section of /etc/mysql/my.cnf for port = settings. (file location varies)

As a mysql client

• Review the [client] section of /etc/mysql/my.cnf for port = settings. (file location varies)
• As a last resort, strace -e connect mysql -h example.com Output will be less noisy if you use example.com as a literal. Eg, connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...>

See Also

List of DBMS on Wikipedia