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.

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.

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:

    ERROR 2003: Can't connect to MySQL server on 'festival' (111)