3rd party software/SQL
From Freeside
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
forport =
settings. (file location varies)
-
- As a mysql client
- Review the
[client]
section of/etc/mysql/my.cnf
forport =
settings. (file location varies) - As a last resort,
strace -e connect mysql -h example.com
Output will be less noisy if you useexample.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 ...>
- Review the