Bruce Family

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

See also [[Database:Database]], [[Database:MySQL]], [[Database:Postgresql]]

====== MySQL Info ======

Original date: 2006/04/13 23:54

tags: mysql, sql, database, draft

Description: Some info about MySQL that I wanted to keep track of.

MySQL is a free database available from My SQL AB (www.mysql.com) (then Sun and now Oracle). This database is a fully relational database environment and there are several tools available to help you manage the database.

====== User Management ======

When managing users (i.e., adding, deleting, or modifying), don't forget that the database permission tables need to be reloaded with the ''flush privileges'' or ''reload'' commands. You can enter this using either the Mysqladmin or mysql client tools.

====== Remote Host Access ======

Network access to a MySQL server under Debian is disabled by default for security reasons. You can enable it by commenting out the skip-networking option in ''/etc/mysql/my.cnf''.

If you don't allow such access then your local MySQL client will report:

<code>
    ERROR 2003: Can't connect to MySQL server on 'festival' (111)
</code>