2012/9/9 Muhammad Umair <mum...@kth.se>: > Dear Drizzle Team, > > Has any thing change in drizzle? Even root user cannot run create table > command. > > drizzle> create table t (a int); > ERROR 1044 (42000): Access denied for user 'root' to schema 'data_dictionary'
What about database selection? Try CREATE DATABASE test; USE test; CREATE TABLE ... Here is the exact sequence of steps I used, starting in the Drizzle trunk source dir: ./configure --with-prefix=$HOME/usr/opt/drizzle-trunk make make install cd $HOME/usr/opt/drizzle-trunk mkdir data sbin/drizzled --basedir=$HOME/usr/opt/drizzle-trunk --datadir=$HOME/usr/opt/drizzle-trunk/data in other terminal cd $HOME/usr/opt/drizzle-trunk/ bin/drizzle drizzle> show databases; +--------------------+ | Database | +--------------------+ | DATA_DICTIONARY | | INFORMATION_SCHEMA | +--------------------+ 2 rows in set (0.000663 sec) drizzle> create table t1 (a int); ERROR 1046 (3D000): No schema selected drizzle> create database test; Query OK, 1 row affected (0.000907 sec) drizzle> use test; Schema changed drizzle> create table (a int); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '(a int)' at line 1 drizzle> create table t1 (a int); Query OK, 0 rows affected (0.002808 sec) Hope that helps, -- Laurynas _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
