Difference between revisions of "MySQL"

From TUTOS

 
m (Reverted edits by Iqelekosaba (Talk); changed back to last version by Gero)
 
(2 intermediate revisions by 2 users not shown)
Line 7: Line 7:
 
* GRANT ALL PRIVILEGES ON $DBNAME.* TO $DBUSER@$APACHEHOST IDENTIFIED BY '$DBPASSWD';
 
* GRANT ALL PRIVILEGES ON $DBNAME.* TO $DBUSER@$APACHEHOST IDENTIFIED BY '$DBPASSWD';
 
* FLUSH PRIVILEGES;
 
* FLUSH PRIVILEGES;
 +
 +
== NOTE ==
 +
There is currently a problem with MySQL 5 which will refuse to work with TUTOS. MySQL 5 does introduce some new keywords which will conflict with fieldnames already used in TUTOS.
 +
 +
--[[User:Gero|Gero]] 08:31, 5 January 2006 (CET)

Latest revision as of 18:50, 9 December 2010

A free database

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

In order to enable this database for TUTOS do this:

  • CREATE DATABASE $DBNAME;
  • GRANT ALL PRIVILEGES ON $DBNAME.* TO $DBUSER@$APACHEHOST IDENTIFIED BY '$DBPASSWD';
  • FLUSH PRIVILEGES;

NOTE

There is currently a problem with MySQL 5 which will refuse to work with TUTOS. MySQL 5 does introduce some new keywords which will conflict with fieldnames already used in TUTOS.

--Gero 08:31, 5 January 2006 (CET)